Excel Quiz
Authored by Sabina Zamzieva
Computers
University
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
92 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is used In Excel to perform a conditlonal check and return one of two values?
IF()
CHECK)
WHETHERO
EITHER)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of Quick Sort in Excel?
To automatically apply cell farmatting
To sort data based on multiple criteria
To sort data numerically from high to low
To quickly alphabetize text in a range
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of using color scales in Excel's conditional formatting?
To visuolize data using color gracients based on cell values
To highlight cells with specific text values
To format all cells in the same color
To create colorful charts and graphs
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is complex sorting in Excel?
Sorting data using only one critenon
Sorting dota in random order
Sorting data based on multiple criteria
Soring data using a custom formula
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the moin purpose of the Find and Replace feature in Excel?
To search for specific formulas in a worksheet
To locate and highlight cells with errors
To sart data in ascending order
To find and replace specific data or formatting in cells
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What are functons ond their codes in the context of subtotals in Excel?
Codes used to hide subtotals in a worksheet
Formulas used to calculate subtotals and the corresponding color codes
Descriptions of different subtotal functions available in Excel
Shortcut keys to appiy subtotals to selected data
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is a PivotChart in Excel?
A tool for merging cells
A visual representation of PivotTable data
A way to filter data in a worksheet
A type of data validation rule
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
97 questions
Cuestionario de Seguridad Informática
Quiz
•
University
94 questions
Midterm Exam - SE2
Quiz
•
University
90 questions
Bài kiểm tra tiếng Anh
Quiz
•
University
90 questions
H
Quiz
•
University
87 questions
It essentials chapters 1-14
Quiz
•
9th Grade - University
95 questions
Mid Term Practice AX1
Quiz
•
University
90 questions
Quizzi tin CKII
Quiz
•
11th Grade - University
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
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade