← Cómo trabajar con hojas de cálculo
Lección 4 de 5
Making a sheet someone else can read
Lo que podrás hacer
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
Paso 1 de 6 · 1 punto
Format the unit prices in F2:F13 as US dollars with two decimals and a thousands separator.
Formato
| 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