Deck 2: Formulas,functions,and Formatting

Question 1

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

Answer 1

True

Question 2

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

A) F5
B) F9
C) F10
D) F12

Answer 2

B

Question 3

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?

A) Calculate Now
B) Calculate Sheet
C) Watch Window
D) Calculation Options

Answer 3

A

Question 4

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

Question 5

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

Question 6

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?

A) Formulas
B) Proofing
C) Language
D) Advanced

Question 7

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

A) one
B) two
C) three
D) four

Question 8

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

A) Delete the conditional formatting rule.
B) Edit the conditional formatting rule.
C) Format the range in the Font dialog box.
D) Format the range as a table.

Question 9

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

A) You can change all instances of a flagged word to a selected suggestion.
B) You cannot add words to the spell checker dictionary.
C) You must accept all spell checker suggested replacement words.
D) For multiple instances of a misspelled word,you must change each one individually.

Question 10

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?

A) =COUNT(B1:B20)
B) =COUNTIF(B1:B20)
C) =COUNTA(B1:B20)
D) =DCOUNTA(B1:B20)

Question 11

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.

Question 12

Currency is an example of a number format.

Question 13

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?

A) Change All
B) Change
C) Ignore Once
D) Ignore All

Question 14

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?

A) =COUNT(B1:B20)
B) =COUNTIF(B1:B20)
C) =SUM(B1:B20)
D) =CALCULATE(B1:B20)

Question 15

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

A) left
B) center
C) bold
D) underline

Question 16

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

Question 17

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

A) Alignment
B) Fonts
C) Color
D) Styles

Question 18

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

A) conditional formatting
B) cell formatting
C) cell styles
D) Quick Access toolbar

Question 19

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

A) Change
B) Change All
C) Ignore Once
D) Add to Dictionary

Question 20

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

A) deleted
B) hidden
C) cut
D) conditionally formatted

Question 21

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

A) Formulas
B) Proofing
C) Language
D) Advanced

Question 22

Which of the following statements is true about COUNT functions?

A) The COUNT function returns the number of calls in a range that are not blank.
B) The COUNT function returns the number of calls in a range that contain any data at all.
C) Using the COUNT function is useful for computing the average of a cell range.
D) The COUNT function returns the number of calls in a range that contain numeric da

Question 23

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.

Question 24

When should you use relative cell references?

A) When you want to preserve the exact cell address in a formula.
B) When you want to preserve the relationship to the formula location.
C) When you want to insert a function.
D) When you want to enter sequential values in a range of cells.

Question 25

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

A) Normal view
B) Page Layout view
C) Page Break Preview
D) Print Preview

Question 26

Which of the following inserts a function into a cell?

A) mode indicator
B) AutoSum button
C) argument
D) formula prefix

Question 27

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

Question 28

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

A) Formula bar
B) Insert Function dialog box
C) Insert dialog box
D) Insert tab

Question 29

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

A) Business Intelligence
B) Flash fill
C) Quick Analysis tools
D) What-if analysis

Question 30

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

A) AutoSum button
B) absolute reference
C) reference operator
D) mode indicator

Question 31

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

A) It calculates the leftmost formulas first.
B) It calculates operations outside parentheses first.
C) It follows the order of operations.
D) It calculates functions first.

Question 32

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

A) Formulas
B) Proofing
C) Language
D) Advanced

Question 33

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

A) Relative cell reference
B) Absolute cell reference
C) Function
D) AutoSum

Question 34

In formulas,calculations in square brackets are calculated first.

Question 35

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

Question 36

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?

A) Click Margins in the Page Setup group on the Page Layout tab and then click on Normal.
B) Set Width and Height to Automatic and Scale to 100% in the Scale to Fit group on the Page Layout tab.
C) Click Orientation and then select from the drop down menu in the Page Setup group on the Page Layout tab.
D) Check the boxes beside Gridlines View Point and Headings View Point in the Sheet Options group on the Page Layout tab.