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
   58   59   60   61   62   63   64   65   66   67   68