Working With Equations

Here is a new challenge: How do you compare a range of numbers? What tools are available in Microsoft Excel to analyze your employee salaries?

 

Before You Begin: Go to the tab at the bottom (Checkbook) and click the + sign to add a blank spreadsheet, Sheet2.

 

1. 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 $75,000.

 

Select Column D and format that column for Accounting. ($)

 

Keep going...

Home ->Number ->Accounting

Exam 77-420 Microsoft Excel 2013
2. Create Cells and Ranges
2.1 Insert Data In Cells and Ranges

graphic2

 

graphic1