Page 328 - TP_IT_V1.0_C9_flipbpookl
P. 328

6.  The column immediately next to column “Z” is       .
                 7.  The shortcut key to create a new spreadsheet is     .
                 8.  The spreadsheet's feature used to fill the series is called   .
                 9.  The formula “=MIN(C1:C5)” stored in cell C6 when copied to cell D6 changes to   .
                10.  The formula in cell A2 is =B2+C3. On copying this formula to cell C2, the formula will change to   .
                11.  The cell address of the cell formed by the intersection of the tenth column and the eighth row will be   .

                12.  $A1$B2 is an example of           referencing in spreadsheet software.
                13.  Numbers entered into a cell are automatically       aligned.
                14.  If A1:A5 contains the numbers 16, 10, 3, 25 and 6 then =Average(A1:A5,60) will display   .
                15.  In              referencing, the reference changes rows and columns automatically when it is copied to a new cell.
                Ans.  1. cell range     2. Formatting Toolbar   3. Charts      4. mathematical      5. Column chart

                     6. AA           7. Ctrl + N            8. Autofill      9. =min(D1:D5)         10. =D2+E3
                    11. J8           12. mixed              13. right        14. 20                 15. relative

              C.  Match the following
                 1.   Ctrl + Shift + S                      a.  Right aligned
                 2.  Numbers                                b. File, Edit
                 3.  A45                                    c.  Sheet
                 4.  Rows and Columns                       d. Save As
                 5.  Menu Bar                               e. Cell address
                Ans.  1. d   2. a   3. e   4. c   5. b

              D.  State whether the following statements are true or false:

                 1.  The F3 key is used to edit the current cell's data.
                 2.  =B4+B5 is an example of a function in a spreadsheet.
                 3.  SUM() returns the count of the number of cells that contain number values.
                 4.  New column can be inserted from the Insert menu.
                 5.  Semicolon (;) is used to separate the arguments in a function.
                 6.  A cell address is made up of a row and a column.
                 7.  Align Right option aligns the selected text to the right within a cell.
                 8.  There are a fixed number of sheets in a spreadsheet and you cannot add more.

                 9.  In a spreadsheet, we can change the column width and row height.
                10.  To show the preceding ‘0’, the data type has to be specified as ‘Text’.
                Ans.  1. False   2. False   3. False   4. True    5. True    6. True    7. True     8. False
                     9. True    10. True

              E.  Solve the following in a spreadsheet:

                 1.  If cell A1 contains the number 10 and B1 contains 5, what will be the contents of cell C1, if the formula =A1+B1*2^3 is
                    entered in cell C1?
                 2.  The contents of cell A1, B1, C1 and D1 are 5, –25, 30 and –35, respectively. What will be the value displayed in cell E1, which
                    contains the formula =MIN(A1:D1)?
                 3.  If cell D5 contains the formula =$B$5+C5 and this formula is copied to cell E5, what will be the copied formula in cell E5?
                 4.  If cell D5 contains the formula =$B5 + C5 and this formula is copied to cell E5, what will be the copied formula in cell E5?



                326   Trackpad Information Technology (Ver. 1.0)-IX
   323   324   325   326   327   328   329   330   331   332   333