

TestOut Office Pro – Excel Videos 5.9.1 & 5.9.2 (15)
Passage
•
Computers
•
8th Grade
•
Practice Problem
•
Medium
Debra Morgan
Used 3+ times
FREE Resource
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does conditional formatting help identify in a spreadsheet?
The most expensive products
The best and worst sellers
The oldest data entries
The most recent updates
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which Excel feature is used to highlight the top 10 items?
Data Validation
Pivot Table
Top/Bottom Rules
Data Filter
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you update a rule in Excel without creating a new one?
Delete the old rule
Use the Manage Rules option
Re-enter the data
Save the file as a new document
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the time range for the section titled "Sample Scenario"?
00:00-00:33
00:33-00:55
01:01-01:22
01:22-01:45
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the first step in creating a table in Excel?
Click on 'Insert Chart'
Select the data and click 'Format as Table'
Increase the font size
Add more columns
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What should you do if your table has headers when creating a table in Excel?
Uncheck the box for headers
Leave the box checked for headers
Delete the headers
Add more headers
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What appears on the ribbon when you select inside a table in Excel?
A new contextual tab
A pie chart
A font size menu
A column adder
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?