Conditional Formatting

Exercise 1 - What is the score in cell "I1"?

• 19

• 17

• 18

• 22

Exercise 4 - What is the icon's colour in cell "I1"?

• Green

• Red

Cells that run horizontally on a spreadsheet

• Row

• Column

• Workbook

• Range

How should Headers be formatted?

• Bold
• Centered
• Wrapped Text
• All of the above

Identify the tab used for conditional formatting in MS Excel.

• Data

• Home

• File

• Insert

Locking or unlocking cells in a worksheet does not have any meaningful effect until you ____ the overall worksheet.

• lock

• protect

• hide

• delete

Unlocked cells are NOT editable if a worksheet or workbook is protected.

• TRUE

• FALSE

When using Conditional Formatting, which technique will let you highlight the top three items in a column?

• Use the Top 10 Items rule, but edit the number of items to three instead of 10.

• Create a new rule to highlight the top three items in a column.

• Highlight the top 10, but then manually format the bottom seven of those 10.

• Use Conditional Formatting > Manage Rules

How can you delete conditional formatting from selected cells?

• Use Conditional Formatting > Manage Rules

• Manually format the cells to override any conditional formatting

• Use Conditional Formatting > Clear Rules > Clear Rules from Entire Sheet

• Use Conditional Formatting > Clear Rules > Clear Rules from Selected Cells

Suppose you create a PivotTable and then make changes to the source data for that PivotTable. You return to the PivotTable, and notice that the changes are not showing up. What do you need to do?

• Go to Analyze > Refresh to update the PivotTable

• Go to Data > initialize to update the PivotTable

• Delete the PivotTable, then generate a new one

• Save the workbook to update the PivotTable