MOS Excel: Charting Data 4

Question 1

In Excel, 'Sparklines' differ from regular charts in which key way?

Accepted Answer

Sparklines are miniature charts inside a single cell, not separate chart objects

Answer

Sparklines are tiny, cell-embedded charts that provide an at-a-glance data trend without taking up chart object space.

Question 2

What is the purpose of the 'Hidden and Empty Cells' option in the Select Data Source dialog?

Accepted Answer

To control how the chart handles missing or hidden data points

Answer

This setting determines whether the chart gaps, connects with a line, or plots zero for cells that are blank or in hidden rows/columns.

Question 3

Which chart sub-type should you choose to plot financial stock data that shows Open, High, Low, and Close prices?

Accepted Answer

Open-High-Low-Close Stock chart

Answer

The Open-High-Low-Close (OHLC) Stock chart type is specifically designed for four-series financial price data.

Question 4

When would you use an Error Bar on a chart?

Accepted Answer

To visualize the variability or uncertainty around each data point

Answer

Error bars display the margin of error, standard deviation, or confidence interval around plotted values, communicating data uncertainty.

Question 5

If you want to reverse the order of categories on the horizontal axis so that the last category appears first, you would:

Accepted Answer

Check 'Categories in reverse order' in the Format Axis pane

Answer

The 'Categories in reverse order' checkbox in the Format Axis pane flips the display order without altering the source data.

MOS - Microsoft Office Specialist Certification Practice Test