TGT1
Authored by Inez Salim
Computers
4th Grade
Used 3+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Find the youngest age from participant number 8 to 15.
=YOUNGEST(C8:C15)
=MIN(C9:C16)
=YOUNGEST(C9-C16)
=MIN(C8-C15)
2.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Find the total age of Daisy, Gwen, and Stephanie.
=C5+C6+C7
=SUM(C5:C7)
=14+10+4
All answers are correct
3.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Find the average age from participant 1 to 10.
=AVERAGE(C2,C11)
=AVERAGE(C2:C3:C4:C5:C6:C7:C8:C9:C10:C11)
=AVERAGE(C2:C11)
=AVERAGE(C2-C11)
4.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Find the oldest age from participant number 3 to 8.
=OLDEST(C3:C8)
=MAX(C4:C9)
=OLDEST(C4-C9)
=MAX(C3-C8)
5.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Find the age gap between the first participant and the last participant.
=B15-B1
=B16-B2
=C15-C1
=C16-C2
6.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
To count cells with numbers.
SUM
MIN
MAX
COUNT
7.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Math operator to do division in a spreadsheet.
*
:
÷
/
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 Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
