Chapter 8: Case studies
Exercise 36: Finish a price quote for a client
Task
Unmerge the title and use Center Across Selection, add "pcs" to the quantities, add thousands separators to unit prices and amounts, and make the headers light gray and bold.
Moves 0 (target 6)19 difference(s) from the model
File
Font
Alignment
Number
Styles
Cells
A1Press and release Alt to show KeyTips (Windows). Ctrl + 1 opens Format Cells, Ctrl + Z undoes.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Price Quote | ||||
| 2 | |||||
| 3 | Item | Qty | Unit price | Amount | |
| 4 | Copy paper (Letter) | 20 | 480 | 9600 | |
| 5 | Ballpoint pen (black) | 100 | 85 | 8500 | |
| 6 | Clear folder | 200 | 32 | 6400 | |
| 7 | |||||
| 8 | |||||
Unmerge the title and use Center Across Selection, add "pcs" to the quantities, add thousands separators to unit prices and amounts, and make the headers light gray and bold.
This drill is for computer screens. On a phone you can review the steps.
- Unmerge A1:D1, then Ctrl + 1 > Alignment > Center Across Selection
- Format B4:B6 with the custom format #,##0" pcs"
- Apply Comma Style to C4:D6 (Alt → H → K)
- Fill A3:D3 with light gray and bold it with Ctrl + B
Key takeaway
The quote is done. Before printing, check that no text is cut off by the column widths.
See how to make a table in Excel for details.