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

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

What is a macro?

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

Which option is quickly fine tune a worksheet?

Which option can be used to create range?

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

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

What are orientation options available in spreadsheet?

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

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

Which Excel feature is used to keep headers constant.

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

________________ helps you to view a selected area of a workbook

What is the benefit of sharing worksheet data?

What is a chart?

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

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

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

Panes are formed where your __________ is placed

Which option makes the workbook cover the entire screen?

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

What is data consolidation?