FormulaCamp
Completed
2. Formatting and Presentation · Format and Style · 20 min

3. Practice: Formats

Lesson 3 of 11
Task 1 of 5
  1. Format the prices in B2:B6 as currency ($).

Lesson theory

A furniture store is getting its price list ready. You will practice the format buttons on the toolbar and the TEXT and VALUE functions.

Tip: a format changes only how a number looks. When you need to show a number nicely inside a piece of text, use TEXT.

fx

Enter — commit · F2 — edit · F4 — $ in a reference · Ctrl+C/Ctrl+V — copy and paste · Ctrl+Z — undo

Esc or F6 — leave the sheet for the «Check» button · Shift+Tab in the first cell — back to the page