Class 10 Spreadsheet Quiz

Preview



/23
65

Class 10 Spreadsheet Quiz

Please provide your details for result on your email address.

1 / 23

What is a macro?

2 / 23

What is data consolidation?

3 / 23

Which option can be used to assign names to cells in a worksheet

4 / 23

Which option is quickly fine tune a worksheet?

5 / 23

Which option makes the workbook cover the entire screen?

6 / 23

Which feature of spreadsheet can be used to keep  headers constant (frozen) while scrolling through the data?

7 / 23

Which option can be used to create range?

8 / 23

Which option arranges the selected data either in an ascending or descending order?

9 / 23

Which of the following chart emphasizes the comparison between items at a fixed period of time?

10 / 23

Panes are formed where your __________ is placed

11 / 23

Which chart shows the relationship of the parts to the whole?

12 / 23

Which option can be used to select area in spreadsheet to be printed?

13 / 23

________________ helps you to view a selected area of a workbook

14 / 23

____________ allows you to change the formatting of the cells based on the values in it.

15 / 23

What is a chart?

16 / 23

Assigning names to cells in a worksheet help you to _________________ specific cells.

 

17 / 23

Which feature is used for extracting particular data using some condition.

18 / 23

Which Excel feature is used to keep headers constant.

19 / 23

__________ option is used for adding the values given in cells automatically without writing the formula.

20 / 23

Which option can be used to find sum of data in cells?

21 / 23

What is the benefit of sharing worksheet data?

22 / 23

Which chart is useful for showing a correlation among the data points that may not be easy to see from data alone?

23 / 23

What are orientation options available in spreadsheet?



 

Spread the love
Lesson tags: Class 10 Spreadsheet Quiz
Back to: CLASS 10 INFORMATION TECHNOLOGY (402)
Spread the love