Page 76 - 2422_C5_Flipbook
P. 76
V. Answer the following questions:
1. What is the use of Redo command?
___________________________________________________________________________
___________________________________________________________________________
2. What is a range? How can you select a range of cells using the mouse?
___________________________________________________________________________
___________________________________________________________________________
3. Write a short note on Formula bar.
___________________________________________________________________________
___________________________________________________________________________
4. What is the purpose Auto Fill feature? Explain in detail.
___________________________________________________________________________
___________________________________________________________________________
5. Differentiate between rows and columns.
___________________________________________________________________________
___________________________________________________________________________
VI. Competency-based/Application-based questions.
1. Raj has a list of his favourite books in Excel 2016. He wants to move the list
from one worksheet to another and copy the names of the authors to a
new column in the same worksheet. How can Raj move the list of books to
a different worksheet, and what steps should he follow to copy the authors'
names to a new column?
2. Emma wants to quickly fill a column with the names of the months of the year in Excel
2016. She has already typed "Jan" into the first cell. How can Emma use the Auto Fill
feature to complete the column with the names of the remaining months, and what
should she do after entering "Jan" in the first cell?
3. Rohan entered some incorrect data in an Excel cell. What are two ways he can edit it?
4. Simran wants to fill a list of dates sequentially without entering them manually. Which
feature should she use?
5. Vikram needs to copy and move data from one cell to another. What are the steps to
do this?
VII. Assertion and Reasoning questions.
Direction: The following question consist of two statements – Assertion (A) and
Reasoning (R). Answer these questions by selecting the appropriate option given below:
a. Both A and R are correct and R is the correct explanation of A.
b. Both A and R are correct but R is NOT the correct explanation of A.
74 Premium Edition-V

