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

Level 5: Practice

Working with Equations, part two Format the Columns Select column D and use the Currency tool Note: the numbers are aligned with two decimal places Use the toolbar to increase and decrease the decimal places Creating 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