Level 5: Working with Equations, part one

 

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

Start Microsoft Excel

Create the following labels:

  • Enter the Labels

    • In Cell A1 type: First Name

    • In Cell B1 type: Last Name

    • In Cell C1 type: Department

    • In Cell D1 type: Salary

  • Select Row 1 and format the labels big, bold, and centered

Add the data

  • Type in at least five records

  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

 

more on the next page