Page 174 - Ms Excel Note and Workbook

MICROSOFT EXCEL NOTE AND WORKBOOK

PRACTICE QUESTION 3

Working with Equations

Enter the labels and format the labels big, bold, and centered
• In Cell A1 type: First Name
• In Cell B1 type: Last Name
• In Cell C1 type: Department
• In Cell D1 type: Salary

Add the data
Type at least five sample records. For example:
A B C D
1 First Name Last Name Department Salary
2 ROZAIDI ROZHAN Training RM5400

Format the Columns

Select column D and use the Currency tool

Creating Equations

Select Cell D8 and use AutoSum to add up the SUM of the Salaries in the D
Column.
Select Cell D9 and use Insert Function to calculate the AVERAGE of the Salaries.

Using IF Functions
This activity compares the employee’s salary with the Average in Cell D9.
Insert the label “ Compare” into cell E1.
In E2, insert the IF function.
In the Wizard, enter the following information
Logical Test: D2>D9
Value_if_true: “Above”
Value_if_false: “Below”

Use the Insert Function wizard to put the correct formula for the remaining cells.

165 | P a g e