Class 10 Spreadsheet Quiz

Preview



/23
3

Class 10 Spreadsheet Quiz

Click here for Notes

Please provide your details for result on your email address.

1 / 23

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

2 / 23

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

3 / 23

What is a macro?

4 / 23

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

5 / 23

Which option is quickly fine tune a worksheet?

6 / 23

Which option can be used to create range?

7 / 23

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

8 / 23

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

9 / 23

What are orientation options available in spreadsheet?

10 / 23

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

11 / 23

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

12 / 23

Which Excel feature is used to keep headers constant.

13 / 23

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

14 / 23

________________ helps you to view a selected area of a workbook

15 / 23

What is the benefit of sharing worksheet data?

16 / 23

What is a chart?

17 / 23

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

 

18 / 23

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

19 / 23

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

20 / 23

Panes are formed where your __________ is placed

21 / 23

Which option makes the workbook cover the entire screen?

22 / 23

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

23 / 23

What is data consolidation?



 

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