← Working With Sheets
Lesson 4 of 5
Making a sheet someone else can read
What you will be able to do
Format numbers and dates so they are unambiguous, structure headers so the sheet can be navigated, and avoid the formatting choices that break later work.
The numbers are right. Right now the sheet still looks like a data dump, and the branch manager is going to open it on a laptop and scroll. Formatting is not decoration here, some of it is the difference between a sheet that sorts and one that does not.
0 XP
Step 1 of 6 · 1 point
Format the unit prices in F2:F13 as US dollars with two decimals and a thousands separator.
Formatting
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ||||||||||
| 2 | ||||||||||
| 3 | ||||||||||
| 4 | ||||||||||
| 5 | ||||||||||
| 6 | ||||||||||
| 7 | ||||||||||
| 8 | ||||||||||
| 9 | ||||||||||
| 10 | ||||||||||
| 11 | ||||||||||
| 12 | ||||||||||
| 13 |
Rows 1 to 13 of 13