
Functions in Excel
Authored by Sin Yoon Chong
Computers
7th - 9th Grade
Used 148+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
22 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Which error is obtained when a formatted number does not fit within a cell?
#####
#DIV/0
#DIV@
#VALUE!
2.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
This function adds all of the values of the cells in the argument
SUM
AVERAGE
MAX
MIN
3.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
What does the AVERAGE function do?
Returns the median number in a set of values
Returns the average number in a set of values
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which functioning Excel tells how many numeric entries are there ?
NUM
COUNT
SUM
None of these
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula finds the minimum value among a range of cells from A4, A5, A6, A7 and A8 in MS Excel?
=MIN(A4 to A8)
=MIN(A4-A8)
=MIN(A4:A8)
All of the above
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
B2:B6 is called?
cell address
sum formula
cell range
7.
MULTIPLE CHOICE QUESTION
10 sec • 5 pts
The Count column found on the Grade Count table, can be computed by this function.
counta
countif
count
countblank
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
20 questions
Computer Science Annual Revision
Quiz
•
7th Grade
20 questions
Class 6 TCS Analysing data
Quiz
•
5th - 7th Grade
20 questions
Y3 Funtime
Quiz
•
1st - 7th Grade
20 questions
CSS GRADE 9 - QUIZ PECs and EM
Quiz
•
9th Grade
20 questions
Video Editing Exam
Quiz
•
9th Grade
21 questions
Y9 Creative iMedia RO81 Quiz Part 1
Quiz
•
9th Grade
20 questions
Microsoft Excel
Quiz
•
KG - Professional Dev...
17 questions
Basic Docs
Quiz
•
8th - 9th Grade
Popular Resources on Wayground
8 questions
2 Step Word Problems
Quiz
•
KG - University
20 questions
Comparing Fractions
Quiz
•
4th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Latin Bases claus(clois,clos, clud, clus) and ped
Quiz
•
6th - 8th Grade
22 questions
fractions
Quiz
•
3rd Grade
7 questions
The Story of Books
Quiz
•
6th - 8th Grade