
Excel Shortcuts and Formatting Quiz
Authored by BLANCA ABANAG
Professional Development
12th Grade
Used 2+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which keyboard shortcut enters the same data into multiple cells?
Ctrl + Enter
Ctrl + C
Ctrl + V
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the best way to format a cell to display currency?
Use font color
Apply number formatting
Add borders
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of data validation?
Change font styles
Restrict the type of data entered
Sort data in ascending order
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you quickly select an entire column in Excel?
Click the column header
Press Ctrl + A
Double-click in any cell
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does freezing panes help you achieve?
Lock specific rows or columns in place
Add conditional formatting
Merge cells
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which feature allows you to highlight duplicate values in a dataset?
Conditional Formatting
Data Validation
Freeze Panes
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If you want to auto-fill the next date in a series, what should you do?
Type each date manually
Drag the fill handle
Use a formula
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?