Spreadsheet Exercise
1. Run the spreadsheet program in your computer and type the following:
|
|
A
|
B
|
C
|
D
|
E
|
F
|
|
1
|
PAYROLL
|
|
2
|
XYZ COMPANY
|
Employee Name
|
Department
|
Degree
|
Salary
|
Need Increase?
|
|
3
|
Nasser
|
Mechanical
|
Master
|
15000
|
|
|
4
|
Waleed
|
Electrical
|
Master
|
9500
|
|
|
5
|
Hasan
|
Management
|
PH.D
|
17000
|
|
|
6
|
Khalid
|
Electrical
|
Bachelor
|
8000
|
|
|
7
|
Naif
|
Chemical
|
Bachelor
|
6500
|
|
|
8
|
Mshari
|
English
|
Diploma
|
9500
|
|
|
9
|
Abdullah
|
General
|
Master
|
13500
|
|
|
10
|
Talal
|
Mechanical
|
Diploma
|
8650
|
|
|
11
|
Brekan
|
Electrical
|
PH.D
|
20000
|
|
|
12
|
Nasser
|
Management
|
Master
|
19000
|
|
|
13
|
Hamad
|
Electrical
|
PH.D
|
14500
|
|
|
14
|
The number of employees in the electrical department is
|
|
2. Save the workbook as spreadsheet-exercise-04-YourldNumber in your folder.
3. Calculate the values of Need Increase? Column as follows: If the employee's salary is greater than or equal to 10000, then it is "NO" otherwise "YES".
4. Make 6 copies of sheet 1 and name them as filter a, filter b, filter c, and filter f.
5. Show the following information using the Filter feature in the corresponding sheet
a. The employees whose name is Nasser
b. The employees whose degree is Master
c. The employees whose department is Electrical
d. The employees whose salary is less than 9000 or is greater than 14000
e. The employees whose department is mechanical or management.
f. The employees whose name ends with d.
6. By using Conditional Formatting feature, format all the cells of the degree column that contain the word PH.D. The format is: Green Fill with Dark Green Text.
7. Calculate the number of employees in the electrical department
8. Type your first and last name, your ID number, and section number at the end of the worksheet.
9. Save the changes to the workbook.