Excel: A Question of Balance Page 1 2 3 4 5 6 7 8 9 10 11 12

Working With Equations

Here is a challenge: how do you compare a range of numbers? What tools are available in Microsoft Excel? At Charlotte’s Web Site, we want to analyze our employee salaries.

 

Try it: Enter the Labels

Click on a blank spreadsheet

Add the following labels:

Cell A1: Last Name

Cell B1: First Name

Cell C1: Department

Cell D1: Salary

 

Please add three sample employees and enter salaries from $45,000 to $70,000.

 

Select Column D and format that column for currency.

Home ->Format ->Number