Pie charts in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a pie chart from the data range A1:B5.

Google Sheets

Insert a chart and set the chart type to [1].

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

ABar chart

BScatter chart

CLine chart

DPie chart

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a bar chart instead of a pie chart.

Selecting a line chart which shows trends over time.

The pie chart is the correct chart type to represent parts of a whole visually.

2fill in blank

medium

Complete the formula to calculate the percentage for each category in column C.

Google Sheets

=B2/[1]

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

AMIN(B2:B5)

BAVERAGE(B2:B5)

CSUM(B2:B5)

DMAX(B2:B5)

Attempts:

3 left

💡 Hint

Common Mistakes

Using AVERAGE instead of SUM.

Using MAX or MIN which do not represent total.

To find the percentage, divide each value by the total sum of the values.

3fill in blank

hard

Fix the error in the formula to calculate the percentage with two decimal places.

Google Sheets

=ROUND([1]*100, 2)

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

AB2/SUM(B2:B5)

BSUM(B2:B5)/B2

CB2*SUM(B2:B5)

DB2+SUM(B2:B5)

Attempts:

3 left

💡 Hint

Common Mistakes

Dividing total by part instead of part by total.

Multiplying instead of dividing.

The formula divides the value by the total sum, multiplies by 100, and rounds to 2 decimals.

4fill in blank

hard

Fill both blanks to create a pie chart with labels showing percentages.

Google Sheets

Insert chart with type [1] and set slice label to [2].

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

APie chart

BBar chart

CPercentage

DValue

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing bar chart instead of pie chart.

Setting labels to value instead of percentage.

Pie chart is the correct chart type, and setting slice labels to percentage shows the part size clearly.

5fill in blank

hard

Fill all three blanks to create a pie chart showing category names and percentages.

Google Sheets

Select data range [1], insert chart type [2], and set label to [3].

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

AA1:B5

BPie chart

CPercentage

DLine chart

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting wrong data range.

Choosing line chart instead of pie chart.

Not showing percentages on labels.

Use the correct data range, choose pie chart type, and set labels to percentage for clear visualization.