Page 29 - ModularV1.1 _c6_flipbook
P. 29

4.  What are the vertical divisions called?

                      a. Rows                              b. Columns                    c. Cells

                 B.  Write ‘T’ for true and ‘F’ for false.

                    1.  Microsoft Excel is a spreadsheet application.                                      .....................
                    2.  By default, a workbook contains 4 worksheets.                                      .....................

                    3.  The Ribbon contains multiple tabs, each with several groups of commands.           .....................

                    4.  Rows are denoted by numbers in a worksheet.                                        .....................

                 C.  Fill in the blanks using the words given below.

                                                     create,  formula,  1048576,  MS Excel


                    1.  ................................. allows you to create visual presentation of facts and information.
                    2.   MS Excel is used to ................................. and manage business  transactions that deal with accounting.

                    3.  A ................................. is a mathematical expression.

                    4.  A worksheet contains ................................. rows.

                 D.  Short answer type questions.

                    1.  What is a spreadsheet?
                      ......................................................................................................................................................................................

                    2.  What is a row and column in a worksheet?
                      ......................................................................................................................................................................................

                    3.  How many columns are there in an Excel worksheet?
                      ......................................................................................................................................................................................

                 E . Long answer type questions.

                    1.  How will you enter data in a worksheet?
                    2.  Explain any three components of the Excel window.

                    3.  How many data types are there in Excel? Explain any one.


                                                   In the lab                                         Subject Enrichment



                        Create a new workbook in Excel and observe all its components.
                        Add different types of values in the Excel workbook and observe the differences.




                  Teacher's Corner
                 Do a detailed walkthrough with students on all the topics presented in the chapter.



                                                                                     Introduction to MS Excel 2010  27
   24   25   26   27   28   29   30   31   32   33   34