← Mit Tabellen arbeiten

Lektion 4 von 5

Making a sheet someone else can read

Was du danach kannst

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

Schritt 1 von 6 · 1 Punkt

Format the unit prices in F2:F13 as US dollars with two decimals and a thousands separator.

Formatierung

ABCDEFGHIJKLMN
1OrderDateBranchProductQtyUnitPriceSales tax rate0.08BranchTarget12
240012026-01-05FairviewRomex 12-2 250ft4148.00592640.84Brookside30003000
340022026-01-05FairviewRomex 12-2 250ft5148.00740Fairview4500
440032026-01-06NorthgateWood primer, 1gal246.7593.5Northgate3600
540042026-01-07NorthgateBall valve 1/2in19.259.25
640052026-01-07BrooksideCopper pipe 1/2in 10ft131.4031.4
740062026-01-08BrooksideCopper pipe 1/2in 10ft131.4031.4
840072026-01-08BrooksideInterior latex paint, 5gal3138.00414
940082026-01-08BrooksideCordless drill 18V5209.001045
1040092026-01-09FairviewBall valve 1/2in39.2527.75
1140102026-01-09NorthgateRoller and tray set614.2085.2
1240112026-01-09BrooksideWater heater element 4500W624.10144.6
1340122026-01-10NorthgateCordless drill 18V1209.00209
Rows 1 to 13 of 13