ADVANCED FEATURES OF EXCEL

What do you use to create a chart?

• A.Pie Wizard

• B.Excel Wizard

• C.Data Wizard

• D.Chart Wizard

How will you graphically represent expenditure in different departments ?

• A.Column Chart

• B.Line Chart

• C.Pie Chart

• D.Dot Chart

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

• A.Column Chart

• B.Line Chart

• C.Pie Chart

• D.Both A and B

Which answer best describes a chart?

• A. A chart is most commonly used to display trends.

• B. A chart is most commonly used to display comparisons

• C. A chart is usually displayed in columns.

• D. A chart is usually displayed using lines.

Which of these charts does not exist in MS Excel

• A. Scatter

• B. Line

• C. Doughnut

• D. Graph

Which of these options is not available in the Chart Options in MS Excel “CHART WIZARD”?

• A) Axes

• B) Data Label

• C) Data Series

• D) Data Table

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

• A) Legend

• B) Chart area

• C) Data label

• D) Data Titles

Which types of charts can excel produce?

• A. Line graphs and pie charts only

• B. Only line graphs

• C. Bar charts, line graphs and pie charts

• D. Bar charts and line graphs only D. Bar charts and line graphs only

What is the total region surrounding the chart?

• (A) Chart area

• (B) legend

• (C) Clipart area

• (D) Plot area

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

• Pie Chart

• Bar Chart

• Area Chart

• Scatter Chart