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