Page 191 - IT_V1.0_Class10
P. 191

Exercise



                                                   Section A (Objective Type Questions)
                 A.  Multiple choice questions.
                    1.  Sahil and his partners have created a list of their company employees in one of the spreadsheets in the office.
                      Now the rest of the task they want to complete from home. Which option they should use to access the same
                      Spreadsheet from home?
                       i.  Consolidate Worksheet                        ii.  Link Worksheet
                       iii.  Merge Worksheet                            iv. Lock Worksheet

                    2.  How can you rename a sheet in a spreadsheet?
                       i.  Right-click on the sheet tab and select Rename Sheet.
                       ii.  Double-click on the sheet tab, type the desired name, and press Enter.
                       iii. Click on the File menu and select Rename Sheet.
                       iv. Use the shortcut key Ctrl + R.
                   3.  ............................. refers to cell G10 of the sheet named Sales Data.

                       i.  $Sales Data.G10                              ii.  $ ‘Sales Data’.G10
                       iii. ‘Sales Data’!G10                            iv. ‘Sales Data’_G10
                    4.  A ............................. refers to a cell or a range of cells on a sheet and can be used to find the values or data that you
                      want formula to calculate.                                                 [CBSE Sample Paper, 2023]
                       i.  Cell reference                               ii.  Block
                       iii. Sheet reference                             iv. Data concantenation
                    5.  If you have two spreadsheets in the same folder linked to each other and you move the entire folder to a new
                      location, a relative hyperlink will ..............................
                       i.  not work           ii.  work                iii.  may work                iv.  break
                    6.  Hyperlink in Calc can be used

                       i.  to jump from one sheet to another sheet.
                       ii.  to jump from one sheet to website.
                       iii. to jump from one section to another section of the same sheet.
                       iv. All of the above
                    7.  Hyperlink icon is present on ..............................
                       i.  Format Toolbar     ii.  Standard Toolbar    iii.  Menu Bar                iv. Status bar
                    8.  When you open a new spreadsheet, by default, it has a sheet named ............................. which is managed using
                      tabs at the bottom of the spreadsheet.
                       i.  Sheet__1           ii.  Untitled1           iii.  Sheet1                  iv.  New Sheet
                    9.  In a spreadsheet using to create a hyperlink to a web, FTP, or Telnet, click on the ............................. icon available
                      in the Hyperlink dialog box.                                               [CBSE Sample Paper, 2023]
                       i.  Browser            ii.  Hyperlink           iii.  Internet                iv.  Mail & News
                 B.  Fill in the blanks.

                     1.  Hyperlinks in a spreadsheet are easily recognisable as they are highlighted in ............................. colour.

                     2.  A ............................. refers to a cell or range in a sheet, and updates automatically when the referenced data changes.





                                                                                         Linking Spreadsheet Data   189
   186   187   188   189   190   191   192   193   194   195   196