Why charts make data visual in Google Sheets - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a chart from data in cells A1 to B5.

Google Sheets

InsertChart(range=[1])

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

AA1:B5

BA1:B10

CB1:C5

DA2:B6

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a range that includes empty cells

Selecting wrong columns

The range A1:B5 correctly selects the data for the chart.

2fill in blank

medium

Complete the formula to calculate the total sales in column B.

Google Sheets

=SUM([1])

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

AB1:B5

BB2:B6

CA2:B5

DA1:A5

Attempts:

3 left

💡 Hint

Common Mistakes

Summing the wrong column

Including header row in sum

The formula sums the sales values in column B from rows 2 to 6, excluding the header.

3fill in blank

hard

Fix the error in the formula to calculate average sales in column B.

Google Sheets

=AVERAGE([1])

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

AB2:B6

BA1:A5

CB1:B5

DA2:A6

Attempts:

3 left

💡 Hint

Common Mistakes

Including header row in average

Selecting wrong column

The correct range B2:B6 excludes the header and includes the sales data.

4fill in blank

hard

Fill both blanks to create a bar chart with title 'Sales Data'.

Google Sheets

Chart.new().setChartType([1]).setOption('title', [2]).build()

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

A'BAR'

B'Sales Data'

C'LINE'

D'Revenue'

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong chart type

Incorrect title string

The chart type should be 'BAR' and the title set to 'Sales Data'.

5fill in blank

hard

Fill all three blanks to create a pie chart from range A1:B5 with legend on the right.

Google Sheets

Chart.new().setChartType([1]).addRange([2]).setOption('legend', { position: [3] }).build()

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

A'PIE'

BA1:B5

C'right'

D'top'

Attempts:

3 left

💡 Hint

Common Mistakes

Wrong chart type

Incorrect data range

Legend position not set correctly

The chart type is 'PIE', data range is 'A1:B5', and legend position is 'right'.

Practice

1. Why do charts help us understand data better in Google Sheets?

easy

A. Because charts show data as pictures, making patterns easier to see

B. Because charts hide the data so you don't get confused

C. Because charts delete numbers from the sheet

D. Because charts make the sheet load faster

Solution

1. Step 1: Understand what charts do

   Charts turn numbers into pictures like bars or lines.

2. Step 2: Recognize why pictures help

   Pictures make it easier to spot trends and compare data quickly.

3. Final Answer:

   Because charts show data as pictures, making patterns easier to see -> Option A

4. Quick Check:

   Charts = Visual data easier to understand [OK]

Hint: Charts turn numbers into pictures for quick understanding [OK]

Common Mistakes:

• Thinking charts hide data
• Believing charts delete numbers
• Assuming charts speed up sheet loading

2. Which menu option do you use in Google Sheets to create a chart?

easy

A. Insert > Chart

B. Format > Text

C. File > Save

D. Data > Sort

Solution

1. Step 1: Recall the menu for adding charts

   Charts are added using the Insert menu in Google Sheets.

2. Step 2: Identify the correct submenu

   The correct submenu is Chart under Insert.

3. Final Answer:

   Insert > Chart -> Option A

4. Quick Check:

   Insert > Chart = Add chart [OK]

Hint: Use Insert menu to add charts quickly [OK]

Common Mistakes:

• Choosing File or Format menus instead
• Selecting Data > Sort which is for sorting
• Confusing chart creation with saving

3. You have monthly sales data in column A (months) and column B (sales). You select both columns and insert a chart. What type of chart will best show sales trends over time?

medium

A. Pie chart

B. Line chart

C. Scatter plot

D. Histogram

Solution

1. Step 1: Understand the data type

   Months and sales data show values changing over time.

2. Step 2: Choose chart type for trends

   Line charts connect points over time to show trends clearly.

3. Final Answer:

   Line chart -> Option B

4. Quick Check:

   Time series data = Line chart [OK]

Hint: Use line charts to show trends over time [OK]

Common Mistakes:

• Using pie charts which show parts of a whole
• Choosing scatter plots which show relationships, not trends
• Selecting histograms which show frequency, not trends

4. You inserted a chart but it shows wrong data. What is the most likely cause?

medium

A. You typed the chart title incorrectly

B. You forgot to save the sheet

C. You used the Format menu instead of Insert

D. You selected the wrong cells before inserting the chart

Solution

1. Step 1: Identify common chart errors

   Wrong data usually means the selected cells were incorrect.

2. Step 2: Check other options

   Saving or menu choice does not affect data shown; title text does not change data.

3. Final Answer:

   You selected the wrong cells before inserting the chart -> Option D

4. Quick Check:

   Wrong chart data = Wrong cell selection [OK]

Hint: Always select correct cells before inserting chart [OK]

Common Mistakes:

• Blaming save or menu choice
• Thinking title text affects data
• Not checking cell selection carefully

5. You have sales data for 4 products over 12 months. You want to compare each product's sales visually and see which product sells best each month. Which chart type should you choose and why?

hard

A. Line chart, because it shows trends for each product over months

B. Pie chart, because it shows each product's share of total sales

C. Stacked column chart, because it shows total and parts per month

D. Scatter plot, because it shows correlation between products

Solution

1. Step 1: Understand the data and goal

   Data has multiple products over months; goal is to compare sales per month and total.

2. Step 2: Evaluate chart types

   Stacked column charts show each product's contribution per month and total height shows total sales.

3. Step 3: Why others don't fit

   Pie charts show parts of one total only, line charts show trends but not clear monthly totals, scatter plots show relationships, not comparisons.

4. Final Answer:

   Stacked column chart, because it shows total and parts per month -> Option C

5. Quick Check:

   Compare parts and total monthly = Stacked column chart [OK]

Hint: Use stacked columns to compare parts and totals monthly [OK]

Common Mistakes:

• Choosing pie charts for multiple months
• Using line charts without clear monthly totals
• Picking scatter plots which don't compare sales