
Quiz
Authored by Karma Dorji
Computers
Professional Development
Used 1+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
16 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the "Remove Duplicates" feature in Excel do?
Deletes all rows with the same values in every column
Removes repeated values from a selected range or table
Sorts the data and highlights duplicates
Only removes duplicates if conditional formatting is applied
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the TEXT function do in Excel?
Converts numbers to formatted text
Extracts text from formulas
Combines multiple strings
Formats fonts in text
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is used to combine the contents of two cells (e.g., A1 and B1) in older versions of Excel?
MERGE()
CONCATENATE(A1, B1)
TEXTJOIN(A1)
JOIN(A1, B1)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use to replace all occurrences of "cat" with "dog" in cell A1?
=REPLACE(A1, "cat", "dog")
=SWITCH(A1, "cat", "dog")
=SUBSTITUTE(A1, "cat", "dog")
=SUBSTITUTE(A1, "dog", "cat")
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the main purpose of Data Validation in Excel?
To validate formulas
To remove incorrect entries
To restrict user input based on specific criteria
To compare worksheet data
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which Data Validation setting allows users to choose from a predefined list of values?
Whole Number
List
Custom
Text Length
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the "Filter" feature in Excel allow you to do?
Merge cells
Display rows matching specific conditions
Validate data formats
Highlight text
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
15 questions
AI-102_MODULE-4
Quiz
•
Professional Development
15 questions
Tin 7-CHU DE 1-BAI 1+2
Quiz
•
1st Grade - Professio...
20 questions
Kuis TIK 1
Quiz
•
KG - Professional Dev...
11 questions
Marvel Future Fight
Quiz
•
KG - Professional Dev...
15 questions
CSS
Quiz
•
Professional Development
14 questions
Input, output and storage de
Quiz
•
8th Grade - Professio...
11 questions
computer
Quiz
•
KG - Professional Dev...
20 questions
Teaching Strategy
Quiz
•
Professional Development
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
Discover more resources for Computers
20 questions
Black History Month Trivia Game #1
Quiz
•
Professional Development
100 questions
Screening Test Customer Service
Quiz
•
Professional Development
20 questions
90s Cartoons
Quiz
•
Professional Development
10 questions
Reading a ruler in Inches
Quiz
•
4th Grade - Professio...
16 questions
Parallel, Perpendicular, and Intersecting Lines
Quiz
•
KG - Professional Dev...
12 questions
Valentines Day Trivia
Quiz
•
Professional Development