
Advanced Spreadsheet Skills Quiz
Authored by Rasel Amamag
English
11th Grade

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
14 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of the =SUM function in Excel?
Counts the number of cells in a range
Calculates the sum of the values of a range of cells
Calculates the maximum value in a range of cells
Calculates the average of a range of cells
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use to find the minimum value in a range of cells?
=COUNT
=MIN
=MAX
=AVERAGE
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the COUNTIF function do?
Counts all cells in a range
Calculates the average of a range
Calculates the sum of a range
Counts cells with a specified content within a range
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which operator is used for multiplication in Excel formulas?
+
-
*
/
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the IF function do in Excel?
Finds the maximum value in a range
Performs a logical test and returns a value based on the result
Calculates the sum of a range of cells
Counts the number of cells in a range
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use to combine text from multiple fields into one cell?
=IF
=SUM
=AVERAGE
=CONCATENATE
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the VLOOKUP function do?
Counts the number of cells in a range
Finds the minimum value in a range
Calculates the average of a range of cells
Searches for a value in the first column of a table and returns a value in the same row
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
14 questions
Sheikh Zayed: our father
Quiz
•
10th - 11th Grade
19 questions
In the kitchen (7)
Quiz
•
1st - 12th Grade
12 questions
Konark Sun Temple
Quiz
•
6th - 12th Grade
15 questions
Expressing O and T
Quiz
•
10th - 12th Grade
10 questions
Pre-Test (Sharing Personal Data)
Quiz
•
4th - 11th Grade
10 questions
UGC NET English Literature
Quiz
•
10th Grade - University
15 questions
Main Ideas & Texts
Quiz
•
10th - 12th Grade
13 questions
Verb patterns
Quiz
•
10th - 11th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
29 questions
Alg. 1 Section 5.1 Coordinate Plane
Quiz
•
9th Grade
22 questions
fractions
Quiz
•
3rd Grade
11 questions
FOREST Effective communication
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for English
15 questions
ACT Reading Practice
Quiz
•
11th Grade
12 questions
IREAD Week 4 - Review
Quiz
•
3rd Grade - University
20 questions
ACT Punctuation Review
Quiz
•
11th Grade
20 questions
The Crucible Act 1
Quiz
•
11th Grade
20 questions
Nonfiction Text Structures
Quiz
•
6th - 12th Grade
20 questions
Editing and Revising Practice
Quiz
•
9th - 11th Grade
20 questions
Implicit vs. Explicit
Quiz
•
6th Grade - University
33 questions
ACT English Practice
Quiz
•
9th - 12th Grade