|
Excel: A Question of Balance
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 your
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.
|
||||
|
| ||||
Microsoft Excel 2007 Exam 77-602 Topic: 2. Formatting Data and Content
2.2. Insert and modify rows and columns: Format all cells in a row or column simultaneously