Naming worksheets consistently
Name:
Date:
Class:
A
Quick Questions
Shade in the A or B circle for each question.
1. Which worksheet tab name is better for a sheet holding the original survey results?
2. Which tab name follows a consistent style with no spaces?
3. How do you rename a worksheet tab in a spreadsheet?
4. True or false: Raw data and analysis should be kept on separate tabs.
5. Your class uses the style Raw_Data, Clean_Data, Summary. Which new tab name matches it?
B
Match the Pairs
Draw a line connecting each item on the left to its match on the right.
| Left column | Right column | |
|---|---|---|
| 1Raw_Data | AThis is the default tab name. It does not describe the data, so it should be renamed to something like Raw_Data. | |
| 2Summary | BSales_2024 | |
| 3Use one agreed style with no spaces, such as underscores between words | CSheet1 -> Raw_Data | |
| 4Rename a tab by double-clicking it and typing a new name instead of keeping the default | DA tab name for the sheet that holds the original, untouched data | |
| 5Sheet1 | EA tab name for the sheet that holds the analysis, totals and results | |
| 6My final data for the whole year (copy 2) | FThe name is too long, unclear and full of spaces and brackets. It should be short and consistent, such as Raw_Data. |
C
Definitions
Raw_Data
D
Fill in the Blanks
Complete each line of code by filling in the missing parts.
1.
=SUM(________!B2:B30)
2.
Analysis tab renamed to _______
3.
Raw_Data
4.
Right-click tab > ______ > Summary
5.
=_______(Marks!B2:B30)
E
Spot the Error
Shade in the letter of the line that contains an error.
Question 1
A
Tab 1: Raw_Data
B
Tab 2: Summary
C
Tab 3: Sheet3
Question 2
A
Right-click the sheet tab
B
Choose Rename
C
Type: raw data (final) v2 NEW
D
Press Enter
Question 3
A
Sheet1 name: raw data
B
Sheet2 name: Summary
C
Sheet3 name: Charts
Question 4
A
Raw_Data holds the scores
B
Summary holds the analysis
C
=AVERAGE(Summary!B2:B30)
Question 5
A
Raw_Data: original scores
B
Summary: totals and averages
C
Keep the two tabs separate
D
Put formulas on Raw_Data
Answer Key
Naming worksheets consistently
Section A: Quick Questions
Q1
A — Raw_Data
Q2
B — Sales_Summary
Q3
A — Right-click the tab (or double-click it) and type the new name
Q4
A — True
Q5
B — Chart_Data
Section B: Match the Pairs
Q1
Raw_Data → A tab name for the sheet that holds the original, untouched data
Q2
Summary → A tab name for the sheet that holds the analysis, totals and results
Q3
Use one agreed style with no spaces, such as underscores between words → Sales_2024
Q4
Rename a tab by double-clicking it and typing a new name instead of keeping the default → Sheet1 -> Raw_Data
Q5
Sheet1 → This is the default tab name. It does not describe the data, so it should be renamed to something like Raw_Data.
Q6
My final data for the whole year (copy 2) → The name is too long, unclear and full of spaces and brackets. It should be short and consistent, such as Raw_Data.
Section C: Definitions
Q1
Raw_Data — A short, clear worksheet tab name that describes what the sheet holds. Use one consistent style with no spaces, and keep raw data on a separate tab from analysis, such as Summary.Section D: Fill in the Blanks
Q1
=SUM(Raw_Data!B2:B30)Q2
Analysis tab renamed to SummaryQ3
Raw_DataQ4
Right-click tab > Rename > SummaryQ5
=AVERAGE(Marks!B2:B30)Section E: Spot the Error
Q1
C — Sheet3 is a default name that says nothing about what the tab holds. Give it a clear name such as Charts, like the other tabs.
Q2
C — The name is long, vague and full of spaces and brackets. Use a short, clear name with no spaces, such as Raw_Data.
Q3
A — The name has a space and does not follow the style of the other tabs. It should use an underscore and capitals, as in Raw_Data.
Q4
C — The scores are on the Raw_Data tab, not Summary. The formula must point to Raw_Data!B2:B30.
Q5
D — Raw data and analysis should be on separate tabs. The formulas belong on Summary so Raw_Data stays unchanged.