Formatting numbers and cells
Name:
Date:
Class:
A
Quick Questions
Shade in the A or B circle for each question.
1. A cell holds 5. You apply currency format and it shows $5.00. What is stored in the cell?
2. Which one is an example of cell formatting?
3. A cell shows 3.14159. You set it to 2 decimal places and it shows 3.14. What does the cell still hold?
4. Why would you use currency format on a column of prices?
5. The words in a column are cut off because they are too wide. What is the best fix?
B
Match the Pairs
Draw a line connecting each item on the left to its match on the right.
| Left column | Right column | |
|---|---|---|
| 1$5.00 | AColumn B width: 10 to 25 | |
| 23.14159 shown as 3.14 | BBold on cell A1: Name | |
| 3Bold makes a heading stand out without changing the words or numbers in the cell | CCurrency format only changes how the value looks. The cell still stores the number 5, so it can still be used in formulas. | |
| 4Making a column wider so a long value fits and shows fully, without changing the value | DShowing fewer decimal places only changes the display. The cell still stores 2.678 and formulas use that full value. | |
| 5Cell shows $5.00 so the cell now stores $5.00 as text | EThe currency format showing the value 5 as money, with a dollar sign and two decimal places | |
| 6Rounded 2.678 to 2.7 so the real value is now 2.7 | FDecimal places set to 2, so the cell shows fewer digits but still stores the full value |
C
Definitions
cell formatting
D
Fill in the Blanks
Complete each line of code by filling in the missing parts.
1.
A1 = 5
Format A1 as ________
A1 shows $5.00
2.
A2 = 3.14159
Decimal places = _
A2 shows 3.14
3.
Headings in A1:C1
Format A1:C1 as ____
Headings now look thick and dark
4.
B1 shows #####
Column B is too narrow
Increase column _____ of B
5.
A1 = 5
Format A1 as currency
Value in A1 is still _
E
Spot the Error
Shade in the letter of the line that contains an error.
Question 1
A
B2 = 50
B
Format B2 as currency
C
B2 shows $5.00
D
B2 value stays 5
Question 2
A
A1 = 3.14159
B
Set A1 to 2 decimal places
C
A1 shows 3.14
D
A1 value becomes 3.14
Question 3
A
Select the last data row
B
Click the Bold button
C
Headings now look heavier
D
The heading text is unchanged
Question 4
A
Title in A1 is cut off
B
Column A is too narrow
C
Make the column narrower
D
Now the full title shows
Question 5
A
C2 = 12.5
B
Format C2 as percentage
C
C2 shows $12.50
D
C2 value stays 12.5
Answer Key
Formatting numbers and cells
Section A: Quick Questions
Q1
B — Still the number 5
Q2
A — Making a heading row bold
Q3
A — 3.14159
Q4
B — So the numbers show a $ sign and cents
Q5
A — Make the column wider
Section B: Match the Pairs
Q1
$5.00 → The currency format showing the value 5 as money, with a dollar sign and two decimal places
Q2
3.14159 shown as 3.14 → Decimal places set to 2, so the cell shows fewer digits but still stores the full value
Q3
Bold makes a heading stand out without changing the words or numbers in the cell → Bold on cell A1: Name
Q4
Making a column wider so a long value fits and shows fully, without changing the value → Column B width: 10 to 25
Q5
Cell shows $5.00 so the cell now stores $5.00 as text → Currency format only changes how the value looks. The cell still stores the number 5, so it can still be used in formulas.
Q6
Rounded 2.678 to 2.7 so the real value is now 2.7 → Showing fewer decimal places only changes the display. The cell still stores 2.678 and formulas use that full value.
Section C: Definitions
Q1
cell formatting — Changing how a cell looks, such as currency, decimal places, bold or column width, without changing the value stored inside it. For example, 5 can show as $5.00.Section D: Fill in the Blanks
Q1
A1 = 5
Format A1 as currency
A1 shows $5.00Q2
A2 = 3.14159
Decimal places = 2
A2 shows 3.14Q3
Headings in A1:C1
Format A1:C1 as bold
Headings now look thick and darkQ4
B1 shows #####
Column B is too narrow
Increase column width of BQ5
A1 = 5
Format A1 as currency
Value in A1 is still 5Section E: Spot the Error
Q1
A — The cell shows $5.00, so the stored value must be 5. Currency format only changes how it looks. It would show $50.00 if the value were 50. The line should be B2 = 5.
Q2
D — Changing decimal places only changes what is shown. The stored value stays 3.14159. The line should be A1 value stays 3.14159.
Q3
A — The headings are in row 1, so row 1 must be selected before clicking Bold. Selecting the last data row would bold the wrong cells. The line should be Select the heading row 1.
Q4
C — A column that is too narrow cuts off text. Making it narrower makes the problem worse. The column needs to be wider. The line should be Make the column wider.
Q5
B — Percentage format would show 1250%, not $12.50. A dollar sign comes from currency format. The line should be Format C2 as currency.