Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

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

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?

Accepted Answer

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

Question 5

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

Accepted Answer

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

Question 6

Which of the following inserts a function into a cell?

Accepted Answer

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

Question 7

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.

Accepted Answer

A) True 
 B)False

Question 8

When should you use relative cell references?

Accepted Answer

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

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

Accepted Answer

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

Question 10

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

Accepted Answer

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

Question 11

Currency is an example of a number format.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

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

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

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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?

Accepted Answer

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

Question 16

In formulas,calculations in square brackets are calculated first.

Accepted Answer

A) True 
 B)False

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

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

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

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?

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

Which of the following inserts a function into a cell?

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.

When should you use relative cell references?

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

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

Currency is an example of a number format.

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

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

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

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?

In formulas,calculations in square brackets are calculated first.

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

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

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

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

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?

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

Which of the following inserts a function into a cell?

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.

When should you use relative cell references?

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

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

Currency is an example of a number format.

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

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

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

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?

In formulas,calculations in square brackets are calculated first.

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