
Excel Formula Application Challenge
Authored by LaKiella Rose
Business
11th Grade
Used 3+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
You have a list of sales figures for the past year in cells A1 to A12. You want to find out the total sales for the year. Which formula should you use?
`=IF(A1:A12)`
`=SUM(A1:A12)`
`=CONCAT(A1:A12)`
`=MAX(A1:A12)`
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
You are given a list of student scores in cells B1 to B10. You need to find the highest score among them. Which formula will help you achieve this?
`=MIN(B1:B10)`
`=AVERAGE(B1:B10)`
`=MAX(B1:B10)`
`=RANDBETWEEN(B1, B10)`
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
You have a dataset of product prices in cells C1 to C20. You want to find the average price of the products. Which formula should you use?
`=SUM(C1:C20)`
`=AVERAGE(C1:C20)`
`=IF(C1:C20)`
`=CONCAT(C1:C20)`
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
You need to generate a random number between 1 and 100 for a lottery draw. Which formula will you use?
`=RANDBETWEEN(1, 100)`
`=MAX(1, 100)`
`=MIN(1, 100)`
`=SUM(1, 100)`
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
You have a list of expenses in cells D1 to D15. You want to find the minimum expense. Which formula should you use?
`=MAX(D1:D15)`
`=SUM(D1:D15)`
`=MIN(D1:D15)`
`=AVERAGE(D1:D15)`
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
You want to create a sentence by joining the text in cells E1, E2, and E3. Which formula will help you concatenate these cells?
`=SUM(E1, E2, E3)`
`=CONCAT(E1, E2, E3)`
`=IF(E1, E2, E3)`
`=MAX(E1, E2, E3)`
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
You have a list of numbers in cells F1 to F10. You want to check if the number in F1 is greater than 50 and return "Pass" if true, otherwise "Fail". Which formula should you use?
`=IF(F1 > 50, "Pass", "Fail")`
`=SUM(F1:F10)`
`=MAX(F1:F10)`
`=MIN(F1:F10)`
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
10 questions
Component 3 - Revenue/Costs Part 1 -Topic 3
Quiz
•
1st - 12th Grade
14 questions
Taxes Personal Finance Review
Quiz
•
10th - 12th Grade
10 questions
Accounting - Internal Controls for Cash
Quiz
•
11th - 12th Grade
12 questions
Component 3 - Revenue/Costs Part 2 - Topic 4
Quiz
•
1st - 12th Grade
10 questions
CLASS 11 BUSINESS MCQ 2
Quiz
•
11th Grade
10 questions
SAFETY IN THE WORKPLACE
Quiz
•
9th - 12th Grade
20 questions
Finance for business growth
Quiz
•
10th - 11th Grade
15 questions
Revamped New Hire Induction
Quiz
•
KG - 12th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
10 questions
Probability Practice
Quiz
•
4th Grade
15 questions
Probability on Number LIne
Quiz
•
4th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
6 questions
Appropriate Chromebook Usage
Lesson
•
7th Grade
10 questions
Greek Bases tele and phon
Quiz
•
6th - 8th Grade