Page 74 - TP_Pluse_V2.2_Class_5
P. 74
b. What is a range? How can you select a range of cells using the mouse?
___________________________________________________________________________
___________________________________________________________________________
c. Write steps to copying the data.
___________________________________________________________________________
___________________________________________________________________________
d. What is the purpose Auto Fill feature? Write the steps to use this feature.
___________________________________________________________________________
___________________________________________________________________________
e. Write down the steps to insert time in a cell.
___________________________________________________________________________
___________________________________________________________________________
5. Competency-based/Application-based questions.
a. 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?
b. 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?
teCh Zone
21 st
Century #Critical Thinking
Let's soLve Skills
1. Consider the giving spreadsheet and
answer the following questions:
a. Your teacher has asked to insert a new
column and type the time at which each
student came to school. List the steps to
do so.
b. You have to change the ‘Aryan’ to name
‘Bharat’. How will you do that?
72 Plus (Ver. 2.2)-V

