Entering data into cells
Name:
Date:
Class:
A
Quick Questions
Shade in the A or B circle for each question.
1. You click cell B2, type 25 and press Enter. What happens?
2. Which key saves your entry and moves to the cell on the right?
3. What is the correct order to enter data in a cell?
4. You type the name Mia into a cell and press Enter. How will it line up?
5. You type 150 into a cell and press Enter. How will it line up?
B
Match the Pairs
Draw a line connecting each item on the left to its match on the right.
| Left column | Right column | |
|---|---|---|
| 1Click B2, type 25, press Enter | AApple | |
| 2Type Sam, press Tab | BThe value was never saved. You must press Enter or Tab to store it before moving on. | |
| 3Text lines up on the left side of a cell | CSaves Sam in the cell and moves one cell to the right | |
| 4Numbers line up on the right side of a cell | DEsc cancels the typing. Press Enter or Tab to save the new value instead. | |
| 5Click A1, type 10, then click B1 without pressing Enter | EStores the number 25 in cell B2 and moves down to B3 | |
| 6Type a new value in A1 to fix a mistake, but the old value is still there after pressing Esc | F42 |
C
Definitions
Click a cell, type, press Enter
D
Fill in the Blanks
Complete each line of code by filling in the missing parts.
1.
1. Click a cell
2. Type your value
3. Press _____ to save it
2.
Press ___ to save and move one cell right
3.
Text lines up on the ____ side of a cell
4.
Numbers line up on the _____ side of a cell
5.
To edit a cell, ____________ it and retype
E
Spot the Error
Shade in the letter of the line that contains an error.
Question 1
A
Click cell A1
B
Type: Apples
C
Press Escape
D
Cell A2 is now selected
Question 2
A
Goal: store 25 in cell B2
B
Click cell A1
C
Type: 25
D
Press Enter
Question 3
A
Click cell A1
B
Type: Name
C
Press Tab to move down
D
Type: Age
Question 4
A
Click cell A1
B
Type: Sam, then press Enter
C
Sam lines up on the right
Question 5
A
B2 holds 30 but should be 35
B
Click B3, type 35 over it
C
Press Enter to save it
Answer Key
Entering data into cells
Section A: Quick Questions
Q1
A — The value 25 is stored in cell B2
Q2
B — Tab
Q3
A — Click the cell, type the value, press Enter
Q4
A — On the left side of the cell
Q5
B — On the right side of the cell
Section B: Match the Pairs
Q1
Click B2, type 25, press Enter → Stores the number 25 in cell B2 and moves down to B3
Q2
Type Sam, press Tab → Saves Sam in the cell and moves one cell to the right
Q3
Text lines up on the left side of a cell → Apple
Q4
Numbers line up on the right side of a cell → 42
Q5
Click A1, type 10, then click B1 without pressing Enter → The value was never saved. You must press Enter or Tab to store it before moving on.
Q6
Type a new value in A1 to fix a mistake, but the old value is still there after pressing Esc → Esc cancels the typing. Press Enter or Tab to save the new value instead.
Section C: Definitions
Q1
Click a cell, type, press Enter — To store data, click a cell, type your value, then press Enter to save it. Tab saves it and moves right. Text lines up left and numbers line up right.Section D: Fill in the Blanks
Q1
1. Click a cell
2. Type your value
3. Press Enter to save itQ2
Press Tab to save and move one cell rightQ3
Text lines up on the left side of a cellQ4
Numbers line up on the right side of a cellQ5
To edit a cell, double-click it and retypeSection E: Spot the Error
Q1
C — Pressing Escape cancels what you typed, so nothing is stored. Press Enter to store the value in the cell.
Q2
B — The goal is to store 25 in B2, so you must click cell B2 first. Clicking A1 would put the value in the wrong cell.
Q3
C — Tab saves the value and moves one cell to the right, not down. Enter is what moves the selection down.
Q4
C — Text lines up on the left side of a cell. Only numbers line up on the right.
Q5
B — To edit the value in B2 you click B2 and type the new value. Clicking B3 would change a different cell.