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
   55   56   57   58   59   60   61   62   63   64   65