Excel_Mod_2

To accept a suggested spelling for that instance only, which of the following would you click?

• Change
• Change All
• Ignore Once
• Add to Dictionary

Which of the following is true about adding cell borders?

• You cannot apply borders to all worksheet cells.
• A cell border underlines the cell text, not the entire cell.
• A cell border extends the width of the cell.
• You can only apply a border to the bottom of a cell.

Clicking the Percentage style in the Number Format list applies _____ decimal places by default.

• One
• Two
• Three
• Four

To help you easily identify sheets in a workbook, you can add _____ to the sheet tab.

• Alignment
• Font
• Color
• Styles

To format a range so that all values greater than $500 appear in red, which of the following can you use?

• conditional formatting
• cell formatting
• cell styles
• Quick Access Toolbar

Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data, you can _____ column C.

• delete
• conditionally format
• edit
• hide

You receive a worksheet in which the rows are numbered 1, 2, 3, 5,6. This means that row 4 is _____.

• deleted
• hidden
• cur
• conditionally formatted

The spell checker flags your company's name as a misspelling. Which of the following will stop the spell checker from flagging later occurrences in the document?

• Change All
• Change All
• Ignore Once
• Ignore All

To change a range's conditional formatting from data bars to icon sets, which of the following can you do?

• Delete the conditional formatting rule.
• Edit the conditional formatting rule.
• Format the range in the Font dialog box.
• Format the range as a table.

Sam wants to count the number of cells between B1 and B20 that contain numbers in them. Which of the following formula should he use to do so?

• =COUNT(B1:B20)
• '=COUNTIF(B1:B20)
• =SUM(B1:B20)
• =CALCULATE(B1:B20)