Sheet Navigation
Formulas & Functions
Chart
100

What is Google Sheets used for?

Creating and organizing data in a spreadsheet.

100

What symbol must every formula start with?

The equals sign (=).

100

What menu do you use to insert a chart?

Insert → Chart.

200

What do you call each box where a row and column meet?

A Cell

200

Write a formula that adds cells A1 through A5.

=SUM(A1:A5)

200

What chart type shows parts of a whole?

A pie chart.

300

What does Ctrl + Shift + ↓ (down arrow) do?

Selects all the cells in a column from the current cell down to the last filled cell.

300

What does the formula bar show?

The contents or formula inside the selected cell.

300

How can you move a chart to its own sheet?

Click the chart → three dots → Move to own sheet.

400

How can you make numbers display as money?

Format as Currency.

400

What formula multiplies the numbers in cells A1 and B1?

=A1*B1

400

What panel appears on the right to customize chart style, labels, and colors?

The Chart editor.

500

How do you merge multiple cells into one larger cell?

Use the Merge cells button.

500

If the price of an item is in cell A1 and tax rate is 8%, what formula calculates the tax amount?

=A1*0.08

500

Where in Google Sheets can you add or edit X-axis and Y-axis labels?

Chart editor → Customize → Chart & axis titles