How2Excel 3 - Basic functions
Authored by Konrad Meij
Computers
9th Grade
Used 20+ 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
30 sec • 1 pt
What function needs to be typed into A4 to add up of all the values in cell range A1:A3?
=SUM(A1,C3)
=ADD(A1:C3)
=SUM(A1:C3)
=(A1:C3)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function needs to be typed into A4 to find the largest value in cell range A1:A3?
=SUM(A1:A3)
=MAX(A1:A3)
=MAX(A1,A3)
=MAX(A4)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function needs to be typed into B4 to count all the values in cell range A1:C3 that contains NUMBERS?
=COUNTA(A1:C3)
=COUNT(A1:C3)
=COUNTIF(A1:C3)
=SUM(A1:C3)
4.
FILL IN THE BLANKS QUESTION
1 min • 1 pt
What function needs to be typed into A4 to find the average of all the values in cell range A1:A3?
REMEMBER: Use only capital letters. No spaces in between characters
(a)
5.
FILL IN THE BLANKS QUESTION
1 min • 1 pt
What function needs to be typed into A4 to find the smallest of all the values in cell range A1:C3?
REMEMBER: Use only capital letters. No spaces in between characters
(a)
6.
FILL IN THE BLANKS QUESTION
1 min • 1 pt
What function needs to be typed into B4 to count all the values in cell range A1:C3 that contains ANYTHING (eg. are not empty)?
REMEMBER: Use only capital letters. No spaces in between characters
(a)
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function needs to be typed into B4 to count all the cells that contain the number 3 in cell range A1:C3?
=COUNTA(A1:C3,3)
=COUNT(A1:C3)
=COUNTIF(A1:C3)
=COUNTIF(A1:C3,3)
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
Already have an account?
