Knowledge Check 7

When you run the Spell Checker in a workbook, Excel automatically checks the spelling in all worksheets at once.

False

Which of the following is true of the Excel spell checker?

You can change all instances of a flagged word to a selected suggestion.

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

conditional formatting

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

hidden

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

hide

Which of the following are ways to align cell contents in relation to cell edges? Select all the options that apply.

left

Which of the following options should one choose to prompt Excel to calculate all open workbooks manually?

F9

Changing a worksheet window to Normal view changes the contents of the worksheet.

False

In formulas, calculations in square brackets are calculated first.

False

Jim frequently prints out the same section of a worksheet. To do so, he selects the cells he wants to define as print area, then clicks Print Area and then clicks Set Print Area on the Page Layout tab in the Scale to Fit group.

False

To change the background color of a cell, you use the Background color button.

False

To view a worksheet without headers, margins, and rulers, use Page Layout view.

False

When you copy and paste a formula to a new location, the formula's relative references do not change.

False

To enter a range of text based on examples that are already in your worksheet, which of the following can you use?

Flash fill

What should be chosen as X in the given series of clicks to calculate formulas automatically except for data tables: File < Options < X < Automatic?

Formulas

What would you choose as X in the given series of clicks to calculate formulas automatically: File < Options < X < Automatic?

Formulas

Which of the following should be selected as X in the given series of clicks to set formulas for manual calculation: File < Options < X < Manual?

Formulas

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?

Ignore All

Where can you see a brief description of a selected function?

Insert Function dialog box

In a complex formula, how does Excel determine which calculation to perform first?

It follows the order of operations.

Your worksheet appears with a reduced view of each page and blue dividers where new pages begin. What view are you in?

Page Break Preview

In the formula =A8*$A$1, which of the following describes A8?

Relative cell reference

Which of the following statements is true about COUNT functions?

The COUNT function returns the number of calls in a range that contain numeric da

Currency is an example of a number format.

True

To apply formats to data when it meets criteria you specify, you can use conditional formatting.

True

To enter data in a cell using examples already in your workbook, you can use the flash fill feature.

True

To format the cell value 44.54 as 44.540, you can use the Increase Decimal button.

True

To remove conditional formatting from a selected range, you can select the rule in the Conditional Formatting Rules Manager dialog box, then click the Delete Rule button.

True

You can apply date formats to cells by using the Date category in the Format Cells dialog box.

True

When should you use relative cell references?

When you want to preserve the relationship to the formula location.

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)

A student is given the task of counting the number of nonblank cells in the range of cells B1 to B20. Which of the following formulas should he use to do so?

=COUNTA(B1:B20)

Which of the following is true about adding cell borders?

A cell border extends the width of the cell.

What feature inserts a function that totals the cells above or to the left of the selected cell?

AutoSum button

Which of the following inserts a function into a cell?

AutoSum button

Amanda needs to manually calculate an open worksheet. Which of the following options should she click on in the Formulas tab in the Calculation group?

Calculate Now

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

Change

Steffie wants to change the margins of a worksheet to Normal to align it better on a printed page. To do this, what can she do after selecting the worksheet for this purpose?

Click Margins in the Page Setup group on the Page Layout tab and then click on Normal.

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

Color

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

Edit the conditional formatting rule.

Which of the following is true about entering a function using the Insert Function dialog box?

You can search for a function that meets your needs. You don't need to type an equal sign to begin the formula. You can select a function you've recently used.

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

two