Name Department Level Salary (monthly)
Khalid HR entry 3,584.00 س.ر.
Ahmed Marketing entry 4,185.00 س.ر.
Sara IT middle 13,555.00 س.ر.
Amina IT middle 6,870.00 س.ر.
Noor IT middle 8,450.00 س.ر.
Abud Allah HR entry 5,475.00 س.ر.
Steve Marketing entry 7,511.00 س.ر.
Rami IT middle 11,841.00 س.ر.
Nancy Marketing middle 9,450.00 س.ر.
Jonathan HR middle 12,477.00 س.ر.
Hind Marketing senior 36,589.00 س.ر.
Muhammad Marketing middle 14,587.00 س.ر.
Kareem Marketing senior 31,647.00 س.ر.
Sam HR senior 79,461.00 س.ر.
Sultan HR entry 6,879.00 س.ر.
Haya HR senior 89,654.00 س.ر.
Ibraheem HR middle 9,766.00 س.ر.
Bonus Deductions (pension) Total Daily wage
Bonus
3.50% Deduction 9% Days 30
TASK 1:
1) Using addition, subtraction, and multiplication, calculate the TOT
assuming that:
A) the bonus is 3.5% of the salary
B) the deduction is 9% of the salary
2) Using division, how much each employee earns each day, assum
the month is 30 days?
By the end of this task you should know how to:
1) use addition, subtraction, multiplication, and division in exce
2) copy formulas
on, calculate the TOTAL
arns each day, assuming
know how to:
, and division in excel
Name Department Level Salary (monthly)
Khalid HR entry 3,584.00 س.ر.
Ahmed Marketing entry 4,185.00 س.ر.
Sara IT middle 13,555.00 س.ر.
Amina IT middle 6,870.00 س.ر.
Noor IT middle 8,450.00 س.ر.
Abud Allah HR entry 5,475.00 س.ر.
Steve Marketing entry 7,511.00 س.ر.
Rami IT middle 11,841.00 س.ر.
Nancy Marketing middle 9,450.00 س.ر.
Jonathan HR middle 12,477.00 س.ر.
Hind Marketing senior 36,589.00 س.ر.
Muhammad Marketing middle 14,587.00 س.ر.
Kareem Marketing senior 31,647.00 س.ر.
Sam HR senior 79,461.00 س.ر.
Sultan HR entry 6,879.00 س.ر.
Haya HR senior 89,654.00 س.ر.
Ibraheem HR middle 9,766.00 س.ر.
Bonus Deductions (pension) Total Daily wage
Bonus
3.50% Deduction 9% Days 30
TASK 1:
1) Using addition, subtraction, and multiplication, calculate the TOT
assuming that:
A) the bonus is 3.5% of the salary
B) the deduction is 9% of the salary
2) Using division, how much each employee earns each day, assum
the month is 30 days?
By the end of this task you should know how to:
1) use addition, subtraction, multiplication, and division in exce
2) copy formulas
on, calculate the TOTAL
arns each day, assuming
know how to:
, and division in excel
Name Department Level Salary (monthly)
Khalid HR entry 3,584.00 س.ر.
Ahmed Marketing entry 4,185.00 س.ر.
Sara IT middle 13,555.00 س.ر.
Amina IT middle 6,870.00 س.ر.
Noor IT middle 8,450.00 س.ر.
Abud Allah HR entry 5,475.00 س.ر.
Steve Marketing entry 7,511.00 س.ر.
Rami IT middle 11,841.00 س.ر.
Nancy Marketing middle 9,450.00 س.ر.
Jonathan HR middle 12,477.00 س.ر.
Hind Marketing senior 36,589.00 س.ر.
Muhammad Marketing middle 14,587.00 س.ر.
Kareem Marketing senior 31,647.00 س.ر.
Sam HR senior 79,461.00 س.ر.
Sultan HR entry 6,879.00 س.ر.
Haya HR senior 89,654.00 س.ر.
Ibraheem HR middle 9,766.00 س.ر.
Bonus Deductions (pension) Total Daily wage
Bonus
3.50% Deduction 9% Days 30
TASK 2:
1) use relative and absolute address to calcualte the bonus, deducti
and daily wage.
By the end of this task you should know how to:
1) how to use absolute address to make calcualtions easier and fa
e the bonus, deduction,
know how to:
ualtions easier and faster
Name Department Level Salary (monthly)
Khalid HR entry 3,584.00 س.ر.
Ahmed Marketing entry 4,185.00 س.ر.
Sara IT middle 13,555.00 س.ر.
Amina IT middle 6,870.00 س.ر.
Noor IT middle 8,450.00 س.ر.
Abud Allah HR entry 5,475.00 س.ر.
Steve Marketing entry 7,511.00 س.ر.
Rami IT middle 11,841.00 س.ر.
Nancy Marketing middle 9,450.00 س.ر.
Jonathan HR middle 12,477.00 س.ر.
Hind Marketing senior 36,589.00 س.ر.
Muhammad Marketing middle 14,587.00 س.ر.
Kareem Marketing senior 31,647.00 س.ر.
Sam HR senior 79,461.00 س.ر.
Sultan HR entry 6,879.00 س.ر.
Haya HR senior 89,654.00 س.ر.
Ibraheem HR middle 9,766.00 س.ر.
Bonus Deductions (pension) Total Daily wage
.ر.س 125.44 .ر.س 322.56 .ر.س 3,386.88 . Bonusر.س 112.90
.ر.س 146.48 .ر.س 376.65 .ر.س 3,954.83 .ر.س 131.83
.ر.س 474.43 .ر.س 1,219.95 .ر.س 12,809.47 .ر.س 426.98
.ر.س 240.45 .ر.س 618.30 .ر.س 6,492.15 .ر.س 216.41
.ر.س 295.75 .ر.س 760.50 .ر.س 7,985.25 .ر.س 266.18
.ر.س 191.63 .ر.س 492.75 .ر.س 5,173.88 .ر.س 172.46
.ر.س 262.89 .ر.س 675.99 .ر.س 7,097.90 .ر.س 236.60
.ر.س 414.44 .ر.س 1,065.69 .ر.س 11,189.74 .ر.س 372.99
.ر.س 330.75 .ر.س 850.50 .ر.س 8,930.25 .ر.س 297.68
.ر.س 436.70 .ر.س 1,122.93 .ر.س 11,790.77 .ر.س 393.03
.ر.س 1,280.62 .ر.س 3,293.01 .ر.س 34,576.60 .ر.س 1,152.55
.ر.س 510.55 .ر.س 1,312.83 .ر.س 13,784.72 .ر.س 459.49
.ر.س 1,107.65 .ر.س 2,848.23 .ر.س 29,906.42 .ر.س 996.88
.ر.س 2,781.14 .ر.س 7,151.49 .ر.س 75,090.64 .ر.س 2,503.02
.ر.س 240.77 .ر.س 619.11 .ر.س 6,500.66 .ر.س 216.69
.ر.س 3,137.89 .ر.س 8,068.86 .ر.س 84,723.03 .ر.س 2,824.10
.ر.س 341.81 .ر.س 878.94 .ر.س 9,228.87 .ر.س 307.63
3.50% Deduction 9% Days 30
TASK 2:
1) use relative and absolute address to calcualte the bonus, deducti
and daily wage.
By the end of this task you should know how to:
1) how to use absolute address to make calcualtions easier and fa
e the bonus, deduction,
know how to:
ualtions easier and faster
Name Department Level Salary (monthly)
Khalid HR entry 3,584.00 س.ر.
Ahmed Marketing entry 4,185.00 س.ر.
Sara IT middle 13,555.00 س.ر.
Amina IT middle 6,870.00 س.ر.
Noor IT middle 8,450.00 س.ر.
Abud Allah HR entry 5,475.00 س.ر.
Steve Marketing entry 7,511.00 س.ر.
Rami IT middle 11,841.00 س.ر.
Nancy Marketing middle 9,450.00 س.ر.
Jonathan HR middle 12,477.00 س.ر.
Hind Marketing senior 36,589.00 س.ر.
Muhammad Marketing middle 14,587.00 س.ر.
Kareem Marketing senior 31,647.00 س.ر.
Sam HR senior 79,461.00 س.ر.
Sultan HR entry 6,879.00 س.ر.
Haya HR senior 89,654.00 س.ر.
Ibraheem HR middle 9,766.00 س.ر.
Lowest
Salary
Highest
Salary
Average
Salary
Total
Salaries
Total
Salaries of
HR
Total
Salaries of
HR entrey
Average
Salaries of
HR
Average
Salaries of
HR entrey
TASK 3:
1) Using MIN, MAX, AVERAGE, and SUM, find the lowest salary, the
hightest salary, average salary, and the sum of all salaries?
2) Using SUMIFS function, what is total salaries of all HR employees?
3) Using SUMIFS function, what is total salaries of all HR, entry level
employees?
4) 4) Using AVERAGEIFS function, what is the average salary of all HR
employees? 5) Using AVERAGEIFS function, what is the average salary
of all HR, entry level employees?
By the end of this task you should know how to:
1) use SUM, MIN, MAX, AVERAGE functions
2) calculate the sum given certain conditions
3) calculate the average given certain conditions
lary, the
mployees?
ntry level
y of all HR
erage salary
:
Name Department Level Salary (monthly)
Khalid HR entry 3,584.00 س.ر.
Ahmed Marketing entry 4,185.00 س.ر.
Sara IT middle 13,555.00 س.ر.
Amina IT middle 6,870.00 س.ر.
Noor IT middle 8,450.00 س.ر.
Abud Allah HR entry 5,475.00 س.ر.
Steve Marketing entry 7,511.00 س.ر.
Rami IT middle 11,841.00 س.ر.
Nancy Marketing middle 9,450.00 س.ر.
Jonathan HR middle 12,477.00 س.ر.
Hind Marketing senior 36,589.00 س.ر.
Muhammad Marketing middle 14,587.00 س.ر.
Kareem Marketing senior 31,647.00 س.ر.
Sam HR senior 79,461.00 س.ر.
Sultan HR entry 6,879.00 س.ر.
Haya HR senior 89,654.00 س.ر.
Ibraheem HR middle 9,766.00 س.ر.
Lowest
Salary 3,584.00 س.ر.
Highest
Salary 89,654.00 س.ر.
Average
Salary 20,704.76 س.ر.
Total
Salaries 351,981.00 س.ر.
Total
Salaries of
HR 207,296.00 س.ر.
Total
Salaries of
HR entrey 15,938.00 س.ر.
Average
Salaries of
HR 29,613.71 س.ر.
Average
Salaries of
HR entrey 5,312.67 س.ر.
TASK 3:
1) Using MIN, MAX, AVERAGE, and SUM, find the lowest salary, the
hightest salary, average salary, and the sum of all salaries?
2) Using SUMIFS function, what is total salaries of all HR employees?
3) Using SUMIFS function, what is total salaries of all HR, entry level
employees?
4) 4) Using AVERAGEIFS function, what is the average salary of all HR
employees? 5) Using AVERAGEIFS function, what is the average salary
of all HR, entry level employees?
By the end of this task you should know how to:
1) use SUM, MIN, MAX, AVERAGE functions
2) calculate the sum given certain conditions
3) calculate the average given certain conditions
lary, the
mployees?
ntry level
y of all HR
erage salary
:
Safety Exam Grades
Name 2020 2021
1 Khalid Failed
2 Ahmed 65 Failed
3 Sara 70
4 Amina Failed
5 Noor 95 90
6 Abud Allah 100 95
7 Steve
How many took the exam?
How many passed the exam
How Many failed?
How many did not take the exam?
How many scored 90 or more?
How many scored more than or equal 70 but less
than 90?
xam Grades
2023
85
70
Failed
90
95
100
75 TASK 4:
1) Using COUNTA function, how many employ
year?
2) Using COUNT fucntion, how many employe
3) Using COUNTIF function, how many emplo
4) Using COUNTBLANK function, how many e
exam?
5) Using COUNTIF function, how many emplo
or more the exam?
^) Using COUNTIFS function, how many empl
70 or equal but less than 90 in the exam?
By the end of this task you should
1) using COUNTA, COUNT, COUNTIF, COOUN
functions
nction, how many employees took the exam each
ntion, how many employees passed the exam?
nction, how many employees failed the exam?
NK function, how many employees did not take the
nction, how many employees scored more than 90
unction, how many employees scored more than
than 90 in the exam?
nd of this task you should know how to:
COUNT, COUNTIF, COOUNTBLANK, and COUNTIFS
functions
Safety Exam Grades
Name 2020 2021
1 Khalid Failed
2 Ahmed 65 Failed
3 Sara 70
4 Amina Failed
5 Noor 95 90
6 Abud Allah 100 95
7 Steve
How many took the exam? 5 4
How many passed the exam 4 2
How Many failed? 1 2
How many did not take the exam? 2 3
How many scored 90 or more? 2 2
How many scored more than or equal 70 but less
than 90? 1 0
xam Grades
2023
85
70
Failed
90
95
100
75 TASK 4:
7
6 1) Using COUNTA function, how many employ
1
year?
0
3
2) Using COUNT fucntion, how many employe
3) Using COUNTIF function, how many emplo
3
4) Using COUNTBLANK function, how many e
exam?
5) Using COUNTIF function, how many emplo
or more the exam?
^) Using COUNTIFS function, how many empl
70 or equal but less than 90 in the exam?
By the end of this task you should
1) using COUNTA, COUNT, COUNTIF, COOUN
functions
nction, how many employees took the exam each
ntion, how many employees passed the exam?
nction, how many employees failed the exam?
NK function, how many employees did not take the
nction, how many employees scored more than 90
unction, how many employees scored more than
than 90 in the exam?
nd of this task you should know how to:
COUNT, COUNTIF, COOUNTBLANK, and COUNTIFS
functions
Safety Exam Grades
Name 2020 2021
1 Khalid Failed
2 Ahmed 65 Failed
3 Sara 70
4 Amina Failed
5 Noor 95 90
6 Abud Allah 100 95
7 Steve
How many took the exam? 5 4
How many passed the exam 4 2
How Many failed? 1 2
How many did not take the exam? 2 3
How many scored 90 or more? 2 2
How many scored more than or equal 70 but less
than 90? 1 0
Name Sales Commission
Khalid 2,000.00 س.ر.
Ahmed 1,950.00 س.ر.
Sara 5,800.00 س.ر.
Amina 6,700.00 س.ر.
Noor 5,000.00 س.ر.
Abud Allah 4,900.00 س.ر.
am Grades
2023 Reward
85
70
Failed
90
95
100
75 TASK 5 A:
7
6 1) the manager decided that only those who
1
deserve 7 days off and ask you to do that usin
0
3
3
By the end of this task you should
1) using IF function to show the de
TASK 5 B:
1) The sales manager decided to give 1500 SR
saleperson that achieve the sale target of 500
IF funtion to calcluate the commission of each
By the end of this task you should
1) using IF function to show the de
ded that only those who socer 90 or above in 2023
nd ask you to do that using IF function.
nd of this task you should know how to:
IF function to show the desired outcome
r decided to give 1500 SR commission for any
eve the sale target of 5000 and ask you to use the
e the commission of each saleperson?
nd of this task you should know how to:
F function to show the desired outcome
Safety Exam Grades
Name 2020 2021
1 Khalid Failed
2 Ahmed 65 Failed
3 Sara 70
4 Amina Failed
5 Noor 95 90
6 Abud Allah 100 95
7 Steve
How many took the exam? 5 4
How many passed the exam 4 2
How Many failed? 1 2
How many did not take the exam? 2 3
How many scored 90 or more? 2 2
How many scored more than or equal 70 but less
than 90? 1 0
Name Sales Commission
Khalid 2,000.00 س.ر. - س.ر.
Ahmed 1,950.00 س.ر. - س.ر.
Sara 5,800.00 س.ر. 1,500.00 س.ر.
Amina 6,700.00 س.ر. 1,500.00 س.ر.
Noor 5,000.00 س.ر. 1,500.00 س.ر.
Abud Allah 4,900.00 س.ر. - س.ر.
am Grades
2023 Reward
85 0
70 0
Failed 7 days off
90 7 days off
95 7 days off
100 7 days off
75 0 TASK 5 A:
7
6 1) the manager decided that only those who
1
deserve 7 days off and ask you to do that usin
0
3
3
By the end of this task you should
1) using IF function to show the de
TASK 5 B:
1) The sales manager decided to give 1500 SR
saleperson that achieve the sale target of 500
IF funtion to calcluate the commission of each
By the end of this task you should
1) using IF function to show the de
ded that only those who socer 90 or above in 2023
nd ask you to do that using IF function.
nd of this task you should know how to:
IF function to show the desired outcome
r decided to give 1500 SR commission for any
eve the sale target of 5000 and ask you to use the
e the commission of each saleperson?
nd of this task you should know how to:
F function to show the desired outcome
Order ID Product Unit Price Quantity
10247 Apples 14.00 س.ر. 12
10249 Oranges 9.80 س.ر. 10 Order ID Product
10250 Bananas 34.80 س.ر. 5 10250
10251 Pears 18.60 س.ر. 9
10252 Grapes 42.30 س.ر. 40 MATCH
10249
Order ID 10247 10249 10250 10251 10252 10253
Unit Price 14.00 س.ر. 2.25 س.ر. 7.70 س.ر. 16.80 س.ر. 5.00 س.ر. 64.80 س.ر.
Quantity 12 9 10 6 20 40
Order ID Product
10250
TASK 6A:
1) Using the VLOOKUP function what was the product ordered in order
number 10250?.
2)using the MATCH function, find order 10249 and 10252.
By the end of this task you should know how to:
1) using VLOOKUP function to search in databases
1) using MATCH function to search for an excat match in databases
TASK 6B:
1) Using the HLOOKUP function what was the unit price for order
number 10250?.
By the end of this task you should know how to:
1) using HLOOKUP function to search in databases
oduct ordered in order
d 10252.
ow how to:
in databases
t match in databases
t price for order
ow how to:
n databases
Order ID Product Unit Price Quantity
10247 Apples 14.00 س.ر. 12
10249 Oranges 9.80 س.ر. 10 Order ID Product
10250 Bananas 34.80 س.ر. 5 10250 Bananas
10251 Pears 18.60 س.ر. 9
10252 Grapes 42.30 س.ر. 40 MATCH
10249 3
Order ID 10247 10249 10250 10251 10252 10253
Unit Price 14.00 س.ر. 2.25 س.ر. 7.70 س.ر. 16.80 س.ر. 5.00 س.ر. 64.80 س.ر.
Quantity 12 9 10 6 20 40
Order ID Product
10250 7.7
TASK 6A:
1) Using the VLOOKUP function what was the product ordered in order
number 10250?.
2)using the MATCH function, find order 10249 and 10252.
By the end of this task you should know how to:
1) using VLOOKUP function to search in databases
1) using MATCH function to search for an excat match in databases
TASK 6B:
1) Using the HLOOKUP function what was the unit price for order
number 10250?.
By the end of this task you should know how to:
1) using HLOOKUP function to search in databases
oduct ordered in order
d 10252.
ow how to:
in databases
t match in databases
t price for order
ow how to:
n databases