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 Which feature is used for extracting particular data using some condition. Filter Sort None of these 2 / 23 What is a chart? None of these Non graphical representation of data Graphical representation of data 3 / 23 Which option is quickly fine tune a worksheet? Page Layout None of these Full Screen 4 / 23 Panes are formed where your __________ is placed Cursor None of these Data 5 / 23 Which chart shows the relationship of the parts to the whole? Bar Chart XY (Scatter) chart Pie chart 6 / 23 Assigning names to cells in a worksheet help you to _________________ specific cells. Locate with difficulty Quickly locate None of these 7 / 23 Which of the following chart emphasizes the comparison between items at a fixed period of time? Pie chart XY (Scatter) charts Bar chart 8 / 23 Which option can be used to assign names to cells in a worksheet Range Name Define Name 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? Bar chart XY (Scatter) charts Pie chart 10 / 23 Which option can be used to find sum of data in cells? Autosum Average Count 11 / 23 ________________ helps you to view a selected area of a workbook Custom View Page Break Preview None of these 12 / 23 What is a macro? Recording of a set of actions Recording of data None of these 13 / 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 14 / 23 Which option can be used to select area in spreadsheet to be printed? Set print area Remove Print Area None of these 15 / 23 What is the benefit of sharing worksheet data? Several users can access it simultaneously Several users can't access it simultaneously None of these 16 / 23 What are orientation options available in spreadsheet? Portrait Both Portrait or Landscape Landscape 17 / 23 Which option can be used to create range? Data > Range Data > Create Range None of these 18 / 23 What is data consolidation? Contents of cells from several sheets can be combined in multiple places Contents of cells from several sheets can be combined in one place None of these 19 / 23 __________ option is used for adding the values given in cells automatically without writing the formula. Autocount Autosum Autoaverage 20 / 23 ____________ allows you to change the formatting of the cells based on the values in it. Clear Formatting Conditional formatting Formatting 21 / 23 Which option arranges the selected data either in an ascending or descending order? Sort Filter None of these 22 / 23 Which Excel feature is used to keep headers constant. Freeze Panes None of these Unfreeze Panes 23 / 23 Which option makes the workbook cover the entire screen? Full Screen None of these Hide Screen Your score is LinkedIn Facebook Twitter VKontakte Restart quiz Exit <br /> <br /> <br /> <br /> <br /> <br /> 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)