Why charts visualize data clearly in Excel - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a chart title in Excel.

Excel

ActiveSheet.ChartObjects(1).Chart.HasTitle = [1]

Drag options to blanks, or click blank then click option'

ATrue

BNone

C0

DFalse

Attempts:

3 left

💡 Hint

Common Mistakes

Using False disables the title.

Using 0 or None causes errors.

Setting HasTitle to True enables the chart title to be shown.

2fill in blank

medium

Complete the formula to calculate the total sales in cell B10.

Excel

=SUM(B2[1]B9)

Drag options to blanks, or click blank then click option'

A,

B:

C;

D-

Attempts:

3 left

💡 Hint

Common Mistakes

Using comma instead of colon breaks the range.

Using semicolon is for different locales.

The colon : specifies a range from B2 to B9 in Excel formulas.

3fill in blank

hard

Fix the error in the formula to calculate average sales in cell B11.

Excel

=AVERAGE([1])

Drag options to blanks, or click blank then click option'

AB2,B9

BB2-B9

CB2:B9

DB2;B9

Attempts:

3 left

💡 Hint

Common Mistakes

Using dash creates subtraction, not range.

Using semicolon may cause errors depending on locale.

The correct range syntax uses a colon : between start and end cells.

4fill in blank

hard

Fill both blanks to create a bar chart from data in range A1:B5.

Excel

ActiveSheet.Shapes.AddChart2([1], [2]).Chart.SetSourceData Source:=Range("A1:B5")

Drag options to blanks, or click blank then click option'

A51

BxlBarClustered

CxlColumnClustered

D100

Attempts:

3 left

💡 Hint

Common Mistakes

Using column chart type instead of bar chart.

Using wrong style number causes unexpected appearance.

Use 51 for chart style and xlBarClustered for bar chart type.

5fill in blank

hard

Fill all three blanks to add data labels showing values on the chart.

Excel

With ActiveSheet.ChartObjects(1).Chart.SeriesCollection(1).[1]
  .[2] = [3]
End With

Drag options to blanks, or click blank then click option'

ADataLabels

BShowValue

CTrue

DLegendEntries

Attempts:

3 left

💡 Hint

Common Mistakes

Using LegendEntries instead of DataLabels.

Setting ShowValue to False hides values.

Use DataLabels to access labels, set ShowValue to True to display values.