Page 75 - iPro_trackGPT_V5_Class7
P. 75
4. Differentiate between contiguous and non-contiguous cell ranges.
...................................................................................................................................................................................
...................................................................................................................................................................................
...................................................................................................................................................................................
5. Describe the steps to format numbers in Excel.
...................................................................................................................................................................................
...................................................................................................................................................................................
...................................................................................................................................................................................
C. Application-based questions.
1. Aryan has created a list of product prices in a worksheet, but he wants to make the data
more understandable by displaying them in rupees. How can Aryan format the cells to
display the numbers as currency?
2. Maya wants to enter a formula that adds the values from cells A1 to A10.
However, she does not want to manually enter each value in the formula.
What shortcut can Maya use to calculate the sum?
#Digital Literacy
Higher Order Thinking Skills (HOTS)
1. You have merged several cells to create a single large cell, but now you need to
unmerge them. How would you ensure that the content is properly distributed and
the formatting is retained?
2. How would you use the Auto Fill feature to extend a custom series that is not
automatically recognise by Excel?
Code Clues #Coding & Computational Thinking
#Experiential Learning
Locate eight features of Excel in the grid.
A U T O F I L L B H L G P
H K F E H F T K B F T F J
W H A V R B P Y N T W I P
R F M D L P R N D E Z L C
A T E X T C O L O R V L M
P R R B R T H D Q I M C K
T L G F N M Y R E W P O T
E S E S P L I T C E L L S
X R O U B G D S J T C O I
T Y C E L L B O R D E R X
More on Spreadsheets 73

