Excel Navigation and Functions Quiz
Authored by Dr.Himanshu Sharma
Science
University
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
21 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What are some shortcuts to improve speed in Excel navigation?
Ctrl + C
Ctrl + V
Alt + Tab
Ctrl + Z
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you freeze panes in Excel?
View > Freeze Panes
Home > Freeze Panes
Data > Freeze Panes
Insert > Freeze Panes
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What are the view options available in Excel?
Normal
Page Layout
Page Break Preview
All of the above
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you create and manage range names in Excel?
Formulas > Name Manager
Data > Name Manager
View > Name Manager
Insert > Name Manager
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of linking multiple worksheets and workbooks?
To consolidate data
To create charts
To format cells
To print reports
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What are custom number formats used for in management reports?
To change font size
To format numbers
To add colors
To create charts
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you apply conditional formatting in Excel?
Home > Conditional Formatting
Data > Conditional Formatting
View > Conditional Formatting
Insert > Conditional Formatting
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?
