Spreadsheet Overview (Formula & Function)
Quiz
•
Computers
•
9th - 11th Grade
•
Medium
Teacher Azratul
Used 8+ times
FREE Resource
Enhance your content in a minute
33 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
All functions and formulas begin with which symbol?
#
/
:
=
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which of the following is a formula that will add cells C9 and C10?
=C9+C10
C9+C10
SUM(C9:C10)
=SUM(C9:C10)
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
This function adds the range of cells
=AVERAGE( )
=SUM( )
=MIN( )
=MAX( )
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
This function determine the average of the range of cells
=AVERAGE( )
=SUM( )
=MIN( )
=MAX( )
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
This function finds the highest number in the range of cells
=AVERAGE( )
=SUM( )
=MIN( )
=MAX( )
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
This function finds the lowest number in the range of cells
=AVERAGE( )
=SUM( )
=MIN( )
=MAX( )
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
A mathematical operation is called a _______________.
formula
range
label
graph
Create a free account and access millions of resources
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
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
35 questions
Class X IT-402
Quiz
•
10th Grade
30 questions
Programming Techniques
Quiz
•
8th - 10th Grade
30 questions
COMPUTER 3
Quiz
•
3rd Grade - University
30 questions
SINAQ (ONLINE)
Quiz
•
11th Grade
31 questions
Simple Machines Quiz 1
Quiz
•
7th - 9th Grade
28 questions
All words GCSE Computer Science
Quiz
•
1st - 10th Grade
36 questions
Nat 5 Computer Systems Revision
Quiz
•
9th - 10th Grade
36 questions
Excel tercel parcial licenciatura
Quiz
•
9th Grade - University
Popular Resources on Wayground
20 questions
Halloween Trivia
Quiz
•
6th - 8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Order of Operations
Quiz
•
5th Grade
20 questions
Halloween
Quiz
•
5th Grade
16 questions
Halloween
Quiz
•
3rd Grade
12 questions
It's The Great Pumpkin Charlie Brown
Quiz
•
1st - 5th Grade
20 questions
Possessive Nouns
Quiz
•
5th Grade
10 questions
Halloween Traditions and Origins
Interactive video
•
5th - 10th Grade
Discover more resources for Computers
10 questions
Halloween Traditions and Origins
Interactive video
•
5th - 10th Grade
20 questions
Halloween movies trivia
Quiz
•
7th - 12th Grade
15 questions
Halloween Characters
Quiz
•
7th - 12th Grade
10 questions
Halloween Movies Trivia
Quiz
•
5th Grade - University
10 questions
Halloween Trivia Challenge
Interactive video
•
6th - 10th Grade
10 questions
Understanding Meiosis
Interactive video
•
6th - 10th Grade
14 questions
Halloween Fun
Quiz
•
2nd - 12th Grade
15 questions
Halloween Trivia
Quiz
•
9th Grade
