Question 1

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?

Accepted Answer

A)   Formulas
B)   Proofing
C)   Language
D)   AdvancedE) All of the above
F) A) and B)

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A)   Change
B)   Change All
C)   Ignore Once
D)   Add to DictionaryE) None of the above
F) A) and B) A

Question 4

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

Accepted Answer

A)   Relative cell reference
B)   Absolute cell reference
C)   Function
D)   AutoSumE) None of the above
F) B) and D)

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A)   Alignment
B)   Fonts
C)   Color
D)   StylesE) C) and D)
F) A) and D)

Question 7

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

Accepted Answer

A)   F5
B)   F9
C)   F10
D)   F12E) B) and D)
F) C) and D)

Question 8

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?

Accepted Answer

A)   Calculate Now
B)   Calculate Sheet
C)   Watch Window
D)   Calculation OptionsE) B) and D)
F) B) and C)

Question 9

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

Accepted Answer

A)   one
B)   two
C)   three
D)   fourE) A) and B)
F) A) and C)

Question 10

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

Accepted Answer

A)   deleted
B)   hidden
C)   cut
D)   conditionally formattedE) A) and C)
F) C) and D)

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False  True

Question 13

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

Accepted Answer

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

Question 14

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.

Accepted Answer

A) True 
 B)False

Question 15

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?

Accepted Answer

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

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

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.E) A) and C)
F) A) and B)

Question 18

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?

Accepted Answer

A)   Change All
B)   Change
C)   Ignore Once
D)   Ignore AllE) B) and C)
F) None of the above

Question 19

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

Accepted Answer

A)   AutoSum button
B)   absolute reference
C)   reference operator
D)   mode indicatorE) All of the above
F) A) and B)

Question 20

Which of the following statements is true about COUNT functions?

Accepted Answer

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 daE) None of the above
F) B) and C)

Exam 2: Formulas,functions,and Formatting

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedA

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedTrue

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

Correct AnswerverifiedC

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.

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following statements is true about COUNT functions?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified
C

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified