TestOut Office Pro – Excel Videos 5.9.1 & 5.9.2 (15)

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

Which Excel feature is used to highlight the top 10 items?

• Data Validation

• Pivot Table

• Top/Bottom Rules

• Data Filter

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

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

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

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

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

What can you do to arrange sellers by highest sales for Q3 in Excel?

• Click 'Insert Chart'

• Click the arrow on the header and choose 'Sort Largest to Smallest'

• Increase the font size

• Add more columns

What is the purpose of conditional formatting in Excel?

• To create pie charts

• To make data easy to read

• To increase font size

• To add more columns

What is included in the listing of a company's sales representatives in the example?

• Only names

• Names, phone numbers, and sales totals

• Only phone numbers

• Only sales totals