MOS Excel: Charting Data 5

Question 1

Which tab appears on the Ribbon only when a chart is selected?

Accepted Answer

Chart Design and Format (contextual tabs)

Answer

Excel shows the contextual 'Chart Design' and 'Format' tabs under 'Chart Tools' only when a chart object or chart sheet is active.

Question 2

A Waterfall chart is most commonly used to visualize:

Accepted Answer

Cumulative effect of sequential positive and negative values

Answer

Waterfall charts show how an initial value increases or decreases through a series of intermediate steps to reach a final total.

Question 3

To link a chart title directly to a cell value so it updates automatically, you should:

Accepted Answer

Select the chart title, type = in the formula bar, then click the source cell

Answer

After selecting the chart title, typing = in the formula bar and clicking a cell creates a live reference that keeps the title synchronized with that cell.

Question 4

Which chart element visually connects the data marker to its data label when the label is positioned away from the marker?

Accepted Answer

Leader line

Answer

Leader lines are thin lines that connect displaced data labels back to their corresponding data markers for clarity.

Question 5

What is the effect of setting the 'Gap Width' to 0% on a Column chart?

Accepted Answer

The columns touch each other with no space between them

Answer

Gap Width controls the space between column clusters; 0% removes all spacing so adjacent columns are flush against one another.

MOS - Microsoft Office Specialist Certification Practice Test

MOS - Microsoft Office Specialist Certification Practice Test

MOS Excel: Charting Data 5