What you will build
Complete “Use the Explore panel where available” using the visible Category, Amount sample so each action and the final state can be checked against the source data.
Learning objectives
Open the practice workbook
Practice in your own copy
Make your own Google Sheets copy with the same data, formulas, formatting, filter and frozen header. The original remains unchanged.
Sign in to Google. If the original is not publicly shared, download the full workbook and import it into Google Sheets, or paste the example data into your own sheet.
Hands-on practice
Step 1: Select the complete A1:B4 range so Explore receives both headers, Category and Amount, plus all three data rows.
Step 2: If your interface shows the Explore button at the bottom-right, click Explore to open the Explore panel. If the button is absent, do not substitute another command and pretend it is Explore; stop here because the feature is not available in the current interface.
Step 3: Only if Explore actually opens in your interface, inspect suggested summaries, pivots, or charts from A1:B4 and compare every number with the source table: Office 55, Travel 95, Food 60; total Amount is 210. If Explore is not present in the current interface, stop at Step 2 and do not treat Gemini or another command as evidence for Explore.
Checkpoint
| Category | Amount |
|---|---|
| Office | 55 |
| Travel | 95 |
| Food | 60 |
Checkpoint: A1:B4 still contains the original three source rows and Amount totals 210. When Explore is available, the Explore panel should be showing suggestions based on the selected range rather than data from another sheet.
Common mistakes and fixes
Correction: return to the exact range and command named in the steps, then compare the live sheet with the Category, Amount source fields.
Independent practice
Add one row with the same schema, repeat the action, verify the new row behaves correctly, then remove it to restore the sample.
Key takeaways
- ✓Select the exact A1:B4 range before opening Explore.
- ✓Open Explore from the bottom-right Explore button when that control is available.
- ✓Do not substitute another command when Explore is unavailable in the current interface.
- ✓Verify every suggestion against the source data; the sample Amount total is 210.
- ✓Keep the source data unchanged after inspection.
Check your understanding
Answer four questions about the practice sheet.
Next lesson
Continue in recommended learning order with Create a table with consistent headers.
Comments
No comments yet. Be the first to join the discussion.