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