ADVANCED FEATURES OF EXCEL

Front

What do you use to create a chart?

Back

Chart Wizard

Front

How will you graphically represent expenditure in different departments?

Back

Pie Chart

Front

What type of chart will you use to compare performance of sales of two products?

Back

Column Chart

Front

Which answer best describes a chart?

Back

A chart is most commonly used to display trends.

Front

Which of these charts does not exist in MS Excel: A. Scatter, B. Line, C. Doughnut, D. Graph?

Back

Graph

Front

Which of these options is not available in the Chart Options in MS Excel “CHART WIZARD”? A) Axes, B) Data Label, D) Data Table

Back

Data Series

Front

Which option of Chart Wizard contains the option of Series Name, Category and Value in Data?

Back

Data label

Front

Which types of charts can excel produce?

Back

Bar charts, line graphs and pie charts.

Front

What is the total region surrounding the chart?

Back

Chart area

Front

In excel, which chart is also known as X Y chart?

Back

Scatter Chart