NEW
Font size
WorksheetsExcel Formula Practice Quiz
Total questions: 11
Worksheet time: 55mins
Mr. Budi wants to find the total score earned by his best student in 5 daily quizzes. The scores are: 85, 92, 78, 95, and 80. Which formula should Mr. Budi use in the spreadsheet to find the total accumulated score of the 5 quizzes?
=AVERAGE(85, 92, 78, 95, 80)
=SUM(85, 92, 78, 95, 80)
=MAX(85, 92, 78, 95, 80)
A fruit shop received a delivery of 4 boxes of fruit. The first box weighs 15 kg, the second 12 kg, the third 18 kg, and the fourth 10 kg. The shop wants to know the average weight per box. Which formula should be used to find the average weight of each box?
=SUM(15, 12, 18, 10)
=AVERAGE(15, 12, 18, 10)
=COUNT(15, 12, 18, 10)
A shoe seller recorded that he sold 40 pairs of shoes on Monday, 55 pairs on Tuesday, and 30 pairs on Wednesday. To find the total number of shoes sold over the three days, which is the most appropriate formula?
=AVERAGE(40, 55, 30)
=SUM(40, 55, 30)
=MAX(40, 55, 30)
The school's running team recorded the running times (in seconds) of 5 members in a race: 12.5, 13.0, 11.8, 14.2, and 13.5. The coach wants to know the average running speed of the team. Which formula should be used to find the average running time of the team?
=SUM(12.5, 13.0, 11.8, 14.2, 13.5)
=AVERAGE(12.5, 13.0, 11.8, 14.2, 13.5)
=MIN(12.5, 13.0, 11.8, 14.2, 13.5)
Andi read 3 books. Book A has 120 pages, Book B has 85 pages, and Book C has 155 pages. He wants to know the average number of pages he needs to read per day, if he plans to finish all books in 10 days. First step, Andi must calculate the total number of pages. Which formula is used for this?
=AVERAGE(120, 85, 155)
=SUM(120, 85, 155)
=(120 + 85 + 155) / 10
Andi read 3 books. Book A has 120 pages, Book B has 85 pages, and Book C has 155 pages. He wants to know the average number of pages he needs to read per day, if he plans to finish all books in 10 days. First step, Andi must calculate the total number of pages. After finding the total pages (360 pages), what calculation must Andi do to find the average pages per day?
Use =AVERAGE on the total pages.
Divide (Total Pages) by 10.
Multiply (Total Pages) by 10.
The Science Club has 30 members. 12 members are girls, and the rest are boys. Every boy member pays a fee of Rp 5,000. First step, what is the number of boy members?
=SUM(30, 12)
=AVERAGE(30, 12)
=30 - 12
The Science Club has 30 members. 12 members are girls, and the rest are boys. Every boy member pays a fee of Rp 5,000. What is the total fee collected from the boy members?
(Number of Boys) * Rp 5,000.
(Number of Boys) / Rp 5,000.
=AVERAGE(Rp 5,000)
The Meteorological Agency recorded the air temperature in a city for 7 days (in Celsius): 28, 30, 31, 29, 27, 32, 28. A farmer wants to know the average temperature for this week. If the temperature data is in cells A1 to A7, the correct Excel formula to get the average is:
=SUM(A1:A7)
=AVERAGE(A1:A7)
=(A1+A2+A3+A4+A5+A6+A7) / 7
A family used electricity (in kWh) for 4 months: 150, 180, 120, and 200. They plan to pay the total electricity cost in 2 equal installments. The first step is to find the total electricity usage for the 4 months. Which formula is used?
=AVERAGE(150, 180, 120, 200)
=SUM(150, 180, 120, 200)
=(150 + 180 + 120 + 200) * 2
A family used electricity (in kWh) for 4 months: 150, 180, 120, and 200. They plan to pay the total electricity cost in 2 equal installments. After finding the total (650 kWh), what calculation must be done to find the installment amount (paid 2 times)?
Divide (Total Usage) by 2.
Use =AVERAGE on the total number.
Multiply (Total Usage) by 2.
