Advance Microsoft Advance Excel - Assessment
Authored by Ragu Nath
Other
University
Used 3+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
25 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 4 pts
1 - Which tab in Excel contains options for formatting, inserting, and deleting cells?
Home
Insert
Data
Review
2.
MULTIPLE CHOICE QUESTION
30 sec • 4 pts
2 - Which shortcut key is used to open the "Format Cells" dialog box?
Ctrl + 1
Ctrl + 2
Ctrl + F
Ctrl + S
3.
MULTIPLE CHOICE QUESTION
30 sec • 4 pts
3 - What is the purpose of Data Validation in Excel?
To format cells with colors
To restrict the type of data entered into a cell
To create charts
To sort data alphabetically
4.
MULTIPLE CHOICE QUESTION
30 sec • 4 pts
4 - Which feature allows you to create a dropdown list in a cell?
Conditional Formatting
Data Validation
Pivot Table
Filter
5.
MULTIPLE CHOICE QUESTION
30 sec • 4 pts
5 - What does the shortcut "Ctrl + T" do in Excel?
Insert a table
Insert a chart
Insert a pivot table
Insert a formula
6.
MULTIPLE CHOICE QUESTION
30 sec • 4 pts
6 - Which Excel feature allows you to create pre-designed layouts for reports?
Pivot Tables
Templates
Macros
Charts
7.
MULTIPLE CHOICE QUESTION
30 sec • 4 pts
7 - What is the purpose of the "Subtotal" feature in Excel?
To create charts
To calculate totals for grouped data
To filter data
To validate data
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 Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
