0
0
Google Sheetsspreadsheet~10 mins

Interface navigation (toolbar, formula bar, sheet tabs) in Google Sheets - Real Business Scenario

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Scenario Mode
👤 Your Role: You are a new employee learning to use Google Sheets for your daily tasks.
📋 Request: Your manager wants you to quickly find and use key parts of the Google Sheets interface to enter and edit data.
📊 Data: You have a simple spreadsheet with sales data for three products over three months.
🎯 Deliverable: Create a short guide showing how to use the toolbar, formula bar, and sheet tabs to enter data, edit formulas, and switch between sheets.
Progress0 / 5 steps
Sample Data
ProductJanuaryFebruaryMarch
Apples120135150
Bananas8090100
Cherries607075
1
Step 1: Click on the cell B5 to select it where you want to enter a formula.
Expected Result
Cell B5 is selected and ready for input.
2
Step 2: Look at the formula bar above the sheet. Click inside it and type the formula =SUM(B2:B4) to add January sales.
=SUM(B2:B4)
Expected Result
Formula appears in the formula bar and cell B5 shows the sum 260.
3
Step 3: Use the toolbar at the top to make the total in cell B5 bold. Click the 'B' icon in the toolbar.
Toolbar > Bold button
Expected Result
The number 260 in cell B5 is now bold.
4
Step 4: To add a new sheet, click the '+' icon next to the sheet tabs at the bottom.
Click '+' icon to add new sheet
Expected Result
A new sheet named 'Sheet2' appears as a tab at the bottom.
5
Step 5: Click the new sheet tab 'Sheet2' to switch to it. Then enter data or formulas as needed.
Expected Result
You are now working on 'Sheet2' and can enter new data.
Final Result
Toolbar
↓
Sheet1
✓The formula bar shows and lets you edit the content of the selected cell.
✓The toolbar has buttons to format cells like making text bold.
✓Sheet tabs at the bottom let you switch between different sheets or add new ones.
Bonus Challenge

Try using the toolbar to change the background color of cell B5 and use the formula bar to edit the formula to include February sales as well.

Show Hint
Use the paint bucket icon in the toolbar to change background color. Edit the formula to =SUM(B2:C4) to add January and February sales.