Page 11 - Ones and Zeros 4 (Workbook)

Programming Languages Spreadsheets

Lesson 1

Cell Format

1. Open the file ‘Changing Cell Formats.xlsx’.
2. Follow the instructions next to each cell to change cell formats.

3. When you’re done, save the file and exit.

Cell Formats
Number with 3 decimals 12.000

Date (day of the week, month, Wednesday, October 23, 2019
day number, year)
Currency (dollars) $190
Percentage with 2 decimals 76.15%
Text 2 Macquarie Street, Sydney

Lesson 2

Sum Formula

1. Open the file ‘Sum Formula.xlsx’.

2. Select cell ‘C10’.
3. Insert the sum formula to calculate the total
number of stamps in the collection.

4. When you’re done, save the file and exit.

9 9