Page 60 - iPro_trackGPT_V5_Class7
P. 60
4. What is the purpose of the Quick Access Toolbar?
...................................................................................................................................................................................
...................................................................................................................................................................................
B. Long answer type questions.
1. Describe how to create a new workbook in Excel.
...................................................................................................................................................................................
...................................................................................................................................................................................
...................................................................................................................................................................................
2. Explain why it is important to save your work regularly in Excel.
...................................................................................................................................................................................
...................................................................................................................................................................................
...................................................................................................................................................................................
3. Describe two types of data that can be entered in Excel.
...................................................................................................................................................................................
...................................................................................................................................................................................
...................................................................................................................................................................................
...................................................................................................................................................................................
C. Application-based questions.
1. Amit is responsible for tracking class attendance using Excel and is unsure
about which data types to include. What types of data should he consider to
effectively manage and analyse attendance records?
2. Aisha is analysing sales data and wants to perform a calculation that involves multiple
cells. She knows she needs to enter a formula but isn't sure how to start. What steps
should she take to enter her formula in the Formula Bar?
#Digital Literacy
Higher Order Thinking Skills (HOTS)
1. Describe the advantages of Auto Fill in Excel 2021 and its role in improving efficiency
when working with large datasets.
2. Compare the efficiency of using the worksheet tab, navigation buttons, and manually
clicking on the tabs. Which method would be more effective in a workbook with many
sheets?
58 TrackGPT iPRO (V5.0)-VII

