Question 1

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

Accepted Answer

A) True 
 B)False  True

Question 2

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 Preview 
A)  Normal view 
B)  Page Layout view 
C)  Page Break Preview 
D)  Print Preview C

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 Dictionary 
A)  Change 
B)  Change All 
C)  Ignore Once 
D)  Add to Dictionary A

Question 4

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 All 
A)  Change All 
B)  Change 
C)  Ignore Once 
D)  Ignore All

Question 5

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)  F12 
A)  F5 
B)  F9 
C)  F10 
D)  F12

Question 6

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 Options 
A)  Calculate Now 
B)  Calculate Sheet 
C)  Watch Window 
D)  Calculation Options

Question 7

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 8

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 9

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 indicator 
A)  AutoSum button 
B)  absolute reference 
C)  reference operator 
D)  mode indicator

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?

Accepted Answer

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

Question 11

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

Accepted Answer

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

Question 12

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)  Advanced 
A)  Formulas 
B)  Proofing 
C)  Language 
D)  Advanced

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 15

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)  AutoSum 
A)  Relative cell reference 
B)  Absolute cell reference 
C)  Function 
D)  AutoSum

Question 16

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 formatted 
A)  deleted 
B)  hidden 
C)  cut 
D)  conditionally formatted

Question 17

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)  Styles 
A)  Alignment 
B)  Fonts 
C)  Color 
D)  Styles

Question 18

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 da 
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 19

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. 
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 20

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

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

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

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

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?

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

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?

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

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

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

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?

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

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?

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

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

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

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

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

Which of the following statements is true about COUNT functions?

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

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.

Creating a Worksheet and a Chart

Working With Large Worksheets, charting, and What-If Analysis

Financial Functions, data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, sorting, and Querying a Table

Creating Templates, importing Data, and Working With Smartart, images, and Screenshots

Working With Trendlines, pivot Table Reports, pivotchart Reports, and Slicers

Formula Auditing, data Validation, and Complex Problem Solving

Data Analysis With Power Tools and Creating Macros

User Interfaces, visual Basic for Applications Vba, and Collaboration Features in Excel

Filters

Exam 2: Formulas,functions,and Formatting

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

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

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

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?

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

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?

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

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

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

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?

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

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?

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

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

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

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

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

Which of the following statements is true about COUNT functions?

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

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.

Creating a Worksheet and a Chart

Working With Large Worksheets, charting, and What-If Analysis

Financial Functions, data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, sorting, and Querying a Table

Creating Templates, importing Data, and Working With Smartart, images, and Screenshots

Working With Trendlines, pivot Table Reports, pivotchart Reports, and Slicers

Formula Auditing, data Validation, and Complex Problem Solving

Data Analysis With Power Tools and Creating Macros

User Interfaces, visual Basic for Applications Vba, and Collaboration Features in Excel

Filters