Interface navigation (toolbar, formula bar, sheet tabs) in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to select the formula bar in Google Sheets.

Google Sheets

Click on the [1] to enter or edit a formula in a cell.

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

Aformula bar

Bsheet tab

Ctoolbar

Dmenu

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing the formula bar with the toolbar or sheet tabs.

Trying to type formulas directly on the sheet tabs.

The formula bar is where you type or edit formulas in Google Sheets.

2fill in blank

medium

Complete the code to switch between sheets in Google Sheets.

Google Sheets

To view a different sheet, click on the [1] at the bottom of the window.

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

Asheet tab

Bmenu

Cformula bar

Dtoolbar

Attempts:

3 left

💡 Hint

Common Mistakes

Trying to switch sheets using the toolbar or formula bar.

Confusing sheet tabs with menu options.

Sheet tabs are located at the bottom and let you switch between different sheets in a file.

3fill in blank

hard

Fix the error in the instruction to open the toolbar in Google Sheets.

Google Sheets

To access formatting options, click on the [1] located above the sheet tabs.

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

Amenu

Btoolbar

Cformula bar

Dsheet tab

Attempts:

3 left

💡 Hint

Common Mistakes

Saying the toolbar is below the sheet tabs.

Confusing the toolbar with the formula bar.

The toolbar is above the sheet tabs and contains buttons for formatting and other tools.

4fill in blank

hard

Fill both blanks to describe how to rename a sheet tab in Google Sheets.

Google Sheets

Right-click on the [1] you want to rename, then select [2] from the menu.

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

Asheet tab

Bformula bar

CRename

DDelete

Attempts:

3 left

💡 Hint

Common Mistakes

Trying to rename the formula bar or toolbar.

Selecting Delete instead of Rename.

You rename a sheet by right-clicking its tab and choosing Rename from the menu.

5fill in blank

hard

Fill all three blanks to explain how to add a new sheet and enter a formula.

Google Sheets

Click the [1] button next to the sheet tabs, then select the new sheet and type [2] in the [3].

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

A+

B=SUM(A1:A5)

Cformula bar

Dsheet tab

Attempts:

3 left

💡 Hint

Common Mistakes

Typing formulas directly on the sheet tab.

Clicking the sheet tab to add a new sheet instead of the + button.

Click the + button to add a sheet, select it, then type formulas in the formula bar.