MCAS Charts, Tables & Visual Data 1

Question 1

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

Accepted Answer

Line chart

Answer

Line charts are ideal for displaying trends over continuous time periods because the connected points show the direction of change.

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

You must first select the data range so Excel knows which values to plot in the chart.

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

Pie charts display each category as a slice of the whole circle, making proportions and percentages easy to visualize.

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

The Insert tab contains the Table command where you can use 'Insert Table' to specify exact row and column counts.

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

The legend is a key that identifies each data series in the chart by associating colors or patterns with series names.

MCAS - Microsoft Certified Application Specialist Practice Test