Go to: Level 1 2 3 4 5 6 7 8 9 10 11 12 16 13 14 15 17

Format the Columns Select column D and use the Currency format Note: the numbers are aligned with two decimal places Can you increase and decrease the decimal places? Use Equations Select Cell D7 and use the AutoSum tool to add up the SUM cost Select Cell D8 and use the Function tool to add up the AVERAGE cost     A B C D 1 First Name Last Name Department Salary 2 Deeter Poohbah Training $34,000 3 Mary Contrary Marketing $48,000 4 Alex West Web Designer $37,500 5 Leo Michaels Engineer $53,000 6 Charlie Barliman Sales $45,000

Go to Level 5 Samples Practice: Equations1 Practice: Equations 2 Practice: Checkbook 1 Practice: Checkbook 2 Level 5: Working with Equations, part two