Page 63 - Trackpad_ipro 4.1_Class7
P. 63
4. What is the Name Box in Excel?
...................................................................................................................................................................................
B. Long answer type questions.
1. What is the use of a formula bar?
...................................................................................................................................................................................
...................................................................................................................................................................................
2. Define row heading.
...................................................................................................................................................................................
...................................................................................................................................................................................
3. What is the difference between a workbook and a worksheet?
...................................................................................................................................................................................
...................................................................................................................................................................................
...................................................................................................................................................................................
4. Write the steps to create a new workbook.
...................................................................................................................................................................................
...................................................................................................................................................................................
...................................................................................................................................................................................
C. Application-based questions.
1. Ravi entered both numbers and dates into his spreadsheet, but his friend is
confused as they appear similar. Explain the different data types and how to
identify and format numbers and dates correctly.
2. Jasleen was trying to change the column header in a spreadsheet by double-clicking on it
but was unsuccessful. What might be the issue?
Higher Order Thinking Skills (HOTS) #Experiential Learning
Analyse the given image of the components of Excel 2019 window and answer the following
question:
a Which component represents active cell?
b. You have to save an Excel file. On which of the given components will you click to do
so? What will you do after clicking on that component to save the file?
c. You have to enter data in component “S.” How will you do so?
d. What is the use of component “V” in the given image?
Spreadsheets—An Introduction 61

