
Excel Functions and Features Quiz
Authored by Javier Díaz
Computers
University
Used 2+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the 'Text to Columns' feature in Excel allow you to do?
Merge cells together
Split data in a cell based on a delimiter
Apply conditional formatting to text
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is used to "Merge" multiple cell values into a single cell?
COMBINE
CONCATENATE
TEXTTOCOLUMN
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the primary purpose of 'Data Validation' in Excel?
Automatically correct errors in data
Limit the type of data entered into a cell
Create pivot tables
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the main function of VLOOKUP in Excel?
Calculate values within a range
Look up values in a vertical table array
Perform arithmetic operations
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you create a hyperlink to another cell or worksheet in Excel?
Use the "Insert" tab or right-click to select "Hyperlink"
Double-click a cell and then paste the link
Type the URL directly into a cell
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which feature allows custom sorting based on specific criteria in Excel?
A-Z Sort
Custom Sort button
Filter Button
7.
MULTIPLE SELECT QUESTION
30 sec • 1 pt
How can you split the Excel window into two panes for easier navigation?
Drag the split box at the top of the vertical scrollbar
Use the "View" tab and select "Split"
Press Ctrl + Shift + D
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
Review Quiz (Chapter 3&4)
Quiz
•
University
20 questions
C Programming Unit-1 Test-2
Quiz
•
University
15 questions
HTML Quiz
Quiz
•
11th Grade - University
20 questions
Java Quiz 1
Quiz
•
University
15 questions
Computer Applications in Banking and Finance Quiz
Quiz
•
University
15 questions
Computer Science Quiz
Quiz
•
University
18 questions
Fiber Optic
Quiz
•
University
20 questions
ICT Short Quiz
Quiz
•
University
Popular Resources on Wayground
7 questions
History of Valentine's Day
Interactive video
•
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
22 questions
fractions
Quiz
•
3rd Grade
15 questions
Valentine's Day Trivia
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Computers
18 questions
Valentines Day Trivia
Quiz
•
3rd Grade - University
12 questions
IREAD Week 4 - Review
Quiz
•
3rd Grade - University
23 questions
Subject Verb Agreement
Quiz
•
9th Grade - University
5 questions
What is Presidents' Day?
Interactive video
•
10th Grade - University
7 questions
Renewable and Nonrenewable Resources
Interactive video
•
4th Grade - University
20 questions
Mardi Gras History
Quiz
•
6th Grade - University
10 questions
The Roaring 20's Crash Course US History
Interactive video
•
11th Grade - University
17 questions
Review9_TEACHER
Quiz
•
University