Class 10 Spreadsheet Quiz Preview /23 4 Class 10 Spreadsheet Quiz Click here for Notes Please provide your details for result on your email address. NameEmail 1 / 23 __________ option is used for adding the values given in cells automatically without writing the formula. Autoaverage Autosum Autocount 2 / 23 Which option can be used to select area in spreadsheet to be printed? Set print area None of these Remove Print Area 3 / 23 Which option arranges the selected data either in an ascending or descending order? Filter None of these Sort 4 / 23 What are orientation options available in spreadsheet? Both Portrait or Landscape Landscape Portrait 5 / 23 Which feature of spreadsheet can be used to keep headers constant (frozen) while scrolling through the data? None of these unfreezing rows and columns Freezing rows and columns 6 / 23 Which option is quickly fine tune a worksheet? Page Layout Full Screen None of these 7 / 23 Which feature is used for extracting particular data using some condition. None of these Sort Filter 8 / 23 What is a macro? Recording of a set of actions Recording of data None of these 9 / 23 Which chart is useful for showing a correlation among the data points that may not be easy to see from data alone? Pie chart XY (Scatter) charts Bar chart 10 / 23 Assigning names to cells in a worksheet help you to _________________ specific cells. None of these Quickly locate Locate with difficulty 11 / 23 Which option can be used to assign names to cells in a worksheet Range Name None of these Define Name 12 / 23 Which of the following chart emphasizes the comparison between items at a fixed period of time? XY (Scatter) charts Pie chart Bar chart 13 / 23 What is data consolidation? None of these Contents of cells from several sheets can be combined in multiple places Contents of cells from several sheets can be combined in one place 14 / 23 What is the benefit of sharing worksheet data? Several users can't access it simultaneously None of these Several users can access it simultaneously 15 / 23 Which chart shows the relationship of the parts to the whole? XY (Scatter) chart Pie chart Bar Chart 16 / 23 Which option makes the workbook cover the entire screen? Full Screen None of these Hide Screen 17 / 23 Which option can be used to create range? Data > Create Range Data > Range None of these 18 / 23 ________________ helps you to view a selected area of a workbook None of these Page Break Preview Custom View 19 / 23 ____________ allows you to change the formatting of the cells based on the values in it. Formatting Clear Formatting Conditional formatting 20 / 23 Which Excel feature is used to keep headers constant. Freeze Panes None of these Unfreeze Panes 21 / 23 Panes are formed where your __________ is placed None of these Data Cursor 22 / 23 Which option can be used to find sum of data in cells? Count Average Autosum 23 / 23 What is a chart? Non graphical representation of data None of these Graphical representation of data Your score is LinkedIn Facebook Twitter VKontakte Restart quiz Exit Lesson tags: Class 10 Spreadsheet Quiz Class 10 Digital Documentation Quiz Class 10 Digital Documentation (Very Short Questions) Back to: CLASS 10 INFORMATION TECHNOLOGY (402)