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.

Practice

1. What does a pie chart in Google Sheets best represent?

easy

A. Trends over time with lines

B. Parts of a whole as slices of a circle

C. Exact values in a table

D. Relationships between two variables

Solution

1. Step 1: Understand pie chart purpose

   A pie chart visually shows how different parts contribute to a total.

2. Step 2: Match chart type to description

   Only Parts of a whole as slices of a circle describes parts of a whole as slices of a circle, which is a pie chart.

3. Final Answer:

   Parts of a whole as slices of a circle -> Option B

4. Quick Check:

   Pie chart = parts of whole [OK]

Hint: Pie charts show parts of a whole, like slices of a pizza [OK]

Common Mistakes:

• Confusing pie charts with line charts
• Thinking pie charts show exact numbers
• Using pie charts for trends over time

2. Which of these is the correct way to insert a pie chart in Google Sheets?

easy

A. Right-click a cell and select 'Add Pie Chart'

B. Type =PIECHART() in a cell

C. Use the formula =CHART(Pie, A1:B5)

D. Select data, then Insert > Chart, and choose Pie chart

Solution

1. Step 1: Recall how to insert charts in Google Sheets

   You select the data range, then go to Insert menu and choose Chart.

2. Step 2: Choose the correct chart type

   After opening the Chart editor, select Pie chart as the chart type.

3. Final Answer:

   Select data, then Insert > Chart, and choose Pie chart -> Option D

4. Quick Check:

   Insert menu > Chart > Pie chart [OK]

Hint: Use Insert > Chart, then pick Pie chart from options [OK]

Common Mistakes:

• Trying to create pie charts with formulas
• Looking for pie chart options in right-click menu
• Using non-existent functions like =PIECHART()

3. Given this data in A1:B4:
Fruit | Quantity
Apple | 30
Banana | 20
Cherry | 50
What percentage slice will Cherry have in a pie chart?

medium

A. 50%

B. 30%

C. 20%

D. 50 slices

Solution

1. Step 1: Calculate total quantity

   Total = 30 (Apple) + 20 (Banana) + 50 (Cherry) = 100

2. Step 2: Calculate Cherry's percentage

   Cherry's percentage = (50 / 100) * 100 = 50%

3. Final Answer:

   50% -> Option A

4. Quick Check:

   Cherry = 50% of total [OK]

Hint: Divide part by total, multiply by 100 for percentage [OK]

Common Mistakes:

• Using raw quantity instead of percentage
• Adding quantities incorrectly
• Confusing percentage with slice count

4. You created a pie chart but it shows incorrect slices. The data range is A1:B5 but your data is only in A1:B4. What is the likely fix?

medium

A. Change data range to A1:B4 to match actual data

B. Add a new row with zero values at A5:B5

C. Use a line chart instead

D. Delete the chart and start over

Solution

1. Step 1: Identify data range mismatch

   The chart includes an extra row (A5:B5) which may be empty or have wrong data.

2. Step 2: Correct the data range

   Adjust the data range to only include actual data cells A1:B4 to fix the slices.

3. Final Answer:

   Change data range to A1:B4 to match actual data -> Option A

4. Quick Check:

   Data range must match data size [OK]

Hint: Match chart data range exactly to your data cells [OK]

Common Mistakes:

• Ignoring extra empty rows in data range
• Trying unrelated chart types
• Deleting chart unnecessarily

5. You want to create a pie chart showing sales by region, but your data has some regions with zero sales. How should you prepare your data for the pie chart?

hard

A. Use a bar chart instead because pie charts can't handle zeros

B. Keep zero sales regions; pie chart will show empty slices

C. Remove regions with zero sales before creating the chart

D. Replace zero sales with 1 to show small slices

Solution

1. Step 1: Understand pie chart behavior with zero values

   Pie charts do not show slices for zero values, which can confuse viewers if zeros appear as empty slices.

2. Step 2: Prepare data by removing zero sales regions

   Removing zero sales rows keeps the chart clean and only shows meaningful slices.

3. Final Answer:

   Remove regions with zero sales before creating the chart -> Option C

4. Quick Check:

   Exclude zero values for clear pie charts [OK]

Hint: Exclude zero values to avoid confusing empty slices [OK]

Common Mistakes:

• Leaving zero sales which create misleading empty slices
• Replacing zeros with fake values
• Switching chart types unnecessarily