Sales

Item Fruit Name Add

January February March Instructions
1 Grapes 150 197 236 583
2 Apples 125 165 221 511 1. Add the Sales for the month of January
3 Lemons 156 145 214 515
4 Avocados 189 132 218 539
5 Banana 147 154 225 526
6 Orange 135 157 226 518
7 Blueberry 118 193 214 525
8 Dragon Fruit 198 123 219 540
9 Papaya 154 175 242 571
10 Watermelon 165 195 253 613
TOTAL 5441
ales for the month of January, February and March
 Sales
Item Fruit Name Subtract
January February March Instructions
1 Grapes 150 197 236 86
2 Apples 125 165 221 96 1. Subtract the Sales from March with the
3 Lemons 156 145 214 58
4 Avocados 189 132 218 29
5 Banana 147 154 225 78
6 Orange 135 157 226 91
7 Blueberry 118 193 214 96
8 Dragon Fruit 198 123 219 21
9 Papaya 154 175 242 88
10 Watermelon 165 195 253 88
he Sales from March with the Sales in January.
 Sales
Item Fruit Name Cost/Kilo
January Instructions
1 Grapes 150 150 22500
2 Apples 125 100 12500 1. Compute the Sale by multiplying the Sales for Januar
3 Lemons 156 180 28080
4 Avocados 189 90 17010
5 Banana 147 50 7350
6 Orange 135 130 17550
7 Blueberry 118 180 21240
8 Dragon Fruit 198 200 39600
9 Papaya 154 30 4620
10 Watermelon 165 50 8250
TOTAL 178700
g the Sales for January with the Cost per Kilo
 Sales
Item Fruit Name Cost/Kilo Subtotal Divide
January Instructions
1 Grapes 150 150 22500 2250
2 Apples 125 100 12500 1250 1. Compute the Sale by multiplying the Sales fo
3 Lemons 156 180 28080 2808 2. Divide the Subtotal with 10
4 Avocados 189 90 17010 1701
5 Banana 147 50 7350 735
6 Orange 135 130 17550 1755
7 Blueberry 118 180 21240 2124
8 Dragon Fruit 198 200 39600 3960
9 Papaya 154 30 4620 462
10 Watermelon 165 50 8250 825
TOTAL 178700 17870
y multiplying the Sales for January with the Cost per Kilo
Students Subjects
Students Name Average
No. Math English Biology Filipino PE Instructions
1 Faith Canales 98 95 96 95 95 95.8
2 Dexter Jayme 95 90 91 89 96 92.2 1. Using a formula or a func
3 Jessa Angeli Temelo 93 96 91 97 95 94.4
4 Maribelle Laru-an 94 96 94 95 95 94.8
5 Vanessa Joy Tuburan 98 96 92 92 90 93.6
6 Arnold Abagat 94 93 92 91 90 92
7 Rendy Bueno 90 90 91 92 92 91
8 Juliet Magdael 93 96 93 91 90 92.6
9 Nelia Pereira 89 92 93 91 94 91.8
10 Carolyn Israel 90 90 91 95 93 91.8
nstructions

. Using a formula or a function, calculate the average grade of each student.

 List of Numbers
761 Instructions
847
968 1. Using a formula or a function, get the highest value among the following number g
849
772
601
877
754
741
863
Highest Value: 968
mong the following number given.
Rank List of Numbers
6 761
4 847
1 968
3 849
5 772
9 601
2 877
7 754
10 2
8 741
1. User Rank function to determine the rank of the number
 List of Numbers

761 Instructions
847
968 1. Using a formula or a function, count the number of value of all the numbers given.
849
772
601
877
754
2
741
863
No of Values: 11
he numbers given.
 Sales
Item Fruit Name Cost/Kilo Subtotal
January February March Instructions
1 Grapes 150 197 236 150 ₱ 733.00
2 Apples 125 165 221 100 ₱ 611.00 1. Get the subtotal of the
3 Lemons 156 145 214 180 ₱ 695.00 2. Using the 'Format Cell',
4 Avocados 189 132 218 90 ₱ 629.00 3. Get the total sales of th
5 Banana 147 154 225 50 ₱ 576.00
6 Orange 135 157 226 130 ₱ 648.00
7 Blueberry 118 193 214 180 ₱ 705.00
8 Dragon Fruit 198 123 219 200 ₱ 740.00
9 Papaya 154 175 242 30 ₱ 601.00
10 Watermelon 165 195 253 50 ₱ 663.00
TOTAL ₱ 6,601.00
nstructions

. Get the subtotal of the sales of fruits for the month of January, February and March
. Using the 'Format Cell', put a peso sign on the fields that requires currency.
. Get the total sales of the fruits sold for the month of January, February and March.

v
First Name Middle Initial Last Name Full Name
Faith Y Canales Faith Y Canales Instructions
Dexter D Jayme Dexter D Jayme
Jessa T Temelo Jessa T Temelo 1. Using a formula or a function, provide the Full name o
Maribelle L Laru-an Maribelle L Laru-an 2. Use the concat formula or function.
Vanessa Joy V Tuburan Vanessa Joy V Tuburan
Arnold V Abagat Arnold V Abagat
Rendy S Bueno Rendy S Bueno
Juliet P Magdael Juliet P Magdael
Nelia B Pereira Nelia B Pereira
Carolyn Y Israel Carolyn Y Israel
provide the Full name of each individuals.
 Full Name First Name
Faith Canales Faith
Dexter Jayme Dexter
Jessa Temelo Jessa
Maribelle Laru-an Maribelle
Vanessa Tuburan Vanessa
Arnold Abagat Arnold
Nelia Pereira Nelia
Juliet Magdael Juliet
Carolyn Israel Carolyn
Rendy Fuentes Rendy
Last Name
Canales Instructions
Jayme
Temelo 1. Using a formula or a function, s
Laru-an
Tuburan
Abagat
Pereira
Magdael
Israel
Fuentes
or a function, separate the Full Name into First Name and L
Name and Last Name of each individuals.