Interface navigation (toolbar, formula bar, sheet tabs) in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the purpose of the toolbar in Google Sheets?

The toolbar contains buttons and menus that let you quickly do tasks like formatting text, inserting charts, or sorting data.

beginner

Where do you enter or edit formulas in Google Sheets?

You use the formula bar, which is the long box above the sheet grid, to type or change formulas and see their results.

beginner

What do sheet tabs do in Google Sheets?

Sheet tabs let you switch between different sheets (pages) in the same spreadsheet file. You can add, rename, or delete sheets here.

beginner

How can you add a new sheet using the interface?

Click the plus (+) icon next to the sheet tabs at the bottom to add a new blank sheet.

beginner

What happens when you click a button on the toolbar?

Clicking a toolbar button applies a command immediately, like making text bold or inserting a chart, without needing to type anything.

Where is the formula bar located in Google Sheets?

A At the bottom of the sheet

B Next to the sheet tabs

C Above the grid, below the toolbar

D Inside the toolbar menu

The formula bar is the long box above the grid and below the toolbar where you enter or edit formulas.

What does clicking a sheet tab do?

A Deletes the sheet

B Switches to that sheet

C Opens a new spreadsheet

D Saves the file

Clicking a sheet tab switches your view to that sheet within the same spreadsheet.

How do you add a new sheet in Google Sheets?

A Click the plus (+) icon next to sheet tabs

B Right-click toolbar and select 'New Sheet'

C Type 'new sheet' in the formula bar

D Use the File menu

The plus (+) icon next to the sheet tabs adds a new blank sheet.

Which toolbar button would you use to make text bold?

A Bold (B)

B Underline (U)

C Strikethrough (S)

D Italic (I)

The Bold button (B) makes selected text bold.

What can you NOT do directly from the sheet tabs?

A Rename a sheet

B Delete a sheet

C Add a new sheet

D Format cell colors

Formatting cell colors is done using the toolbar or menu, not from the sheet tabs.

Describe how you would navigate between sheets and add a new sheet in Google Sheets.

Think about the bottom part of the spreadsheet window.

Explain the role of the toolbar and formula bar in Google Sheets.

One is for clicking commands, the other for typing formulas.