MCAS Charts, Tables & Visual Data

Question 1

In Microsoft Excel, which chart type is best suited for showing trends over time with continuous data?

Accepted Answer

Line chart

Answer

Bar chart

Answer

Pie chart

Answer

Scatter chart

Question 2

In Excel, what must you do before creating a chart from worksheet data?

Accepted Answer

Select the data range you want to include in the chart

Answer

Format all cells as percentages

Answer

Sort the data in ascending order

Answer

Apply a table style to the data

Question 3

Which type of chart is most appropriate for displaying the percentage contribution of each category to a whole?

Accepted Answer

Pie chart

Answer

Clustered column chart

Answer

Line chart

Answer

Bubble chart

Question 4

In Microsoft Word, how do you insert a table with a specific number of rows and columns?

Accepted Answer

Insert tab > Table > Insert Table (specify rows and columns)

Answer

Home tab > Styles > Table

Answer

Page Layout > Columns > More Columns

Answer

View > Table Options

Question 5

In an Excel chart, what is the 'Legend' used for?

Accepted Answer

To identify the data series represented by different colors or patterns

Answer

To provide a title for the entire chart

Answer

To display the source data range of the chart

Answer

To add annotations to specific data points

Question 6

In Excel, how do you change the chart type of an existing chart?

Accepted Answer

Right-click the chart and select 'Change Chart Type'

Answer

Delete the chart and create a new one

Answer

Double-click a data point to open chart settings

Answer

Use Format > Chart > Type from the menu bar