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: Please go to a blank spreadsheet, say 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...
Exam 77-882: Microsoft Excel 2010
Core
2. Creating Cell Data
2.1. Construct cell data: Format all
cells in a row or column simultaneously
|
|
| |
