Question 1

You use the MEANIF function to calculate the average of values in a range that meet criteria you specify._________________________

Accepted Answer

A) True 
 B)False  False

Question 2

In the Edit Formatting Rule dialog box,click the ____ button to open the Format Cells dialog box.

Accepted Answer

A)  Format Cells 
B)  Options 
C)  Format 
D)  Cell Tools 
A)  Format Cells 
B)  Options 
C)  Format 
D)  Cell Tools C

Question 3

Using the VLOOKUP function,an approximate match lookup occurs when the value entered falls within a range of values in ____ of the lookup table.

Accepted Answer

A)  the first column 
B)  any column 
C)  the first row 
D)  any row 
A)  the first column 
B)  any column 
C)  the first row 
D)  any row A

Question 4

Placing cell references to input values rather than constants in formulas makes a worksheet ____.

Accepted Answer

A)  more flexible 
B)  easier to update 
C)  both a.and b. 
D)  neither a.nor b. 
A)  more flexible 
B)  easier to update 
C)  both a.and b. 
D)  neither a.nor b.

Question 5

If you edit a cell in a calculated column so it is no longer consistent with the other formulas in the column,a ____ appears in the upper-left corner of the cell.

Accepted Answer

A)  red circle 
B)  blue square 
C)  red square 
D)  green triangle 
A)  red circle 
B)  blue square 
C)  red square 
D)  green triangle

Question 6

Discuss strategies for checking formulas for matching parentheses.

Accepted Answer

A common problem when creating formulas

Question 7

Omitting the range_lookup entry makes VLOOKUP a(n)____ lookup.

Accepted Answer

A)  range 
B)  approximate match 
C)  exact match 
D)  calculated 
A)  range 
B)  approximate match 
C)  exact match 
D)  calculated

Question 8

To get the effect of a calculated column in a range of data,you must copy and paste the formula or use the ____ feature.

Accepted Answer

A)  Concatenation 
B)  Merged 
C)  AutoFill 
D)  Indexed 
A)  Concatenation 
B)  Merged 
C)  AutoFill 
D)  Indexed

Question 9

-Given the flowchart in the accompanying figure,the Pay Grade of ____ yields a Bonus value of 2500.

Accepted Answer

A)  1 
B)  2 
C)  both a.and b. 
D)  neither a.nor b. 
A)  1 
B)  2 
C)  both a.and b. 
D)  neither a.nor b.

Question 10

If you see ____ as the result of a VLOOKUP formula,you might have entered a letter for the col_index_num instead of a number.

Accepted Answer

A)  #NULL 
B)  #REF? 
C)  #NAME? 
D)  #DIV/0 
A)  #NULL 
B)  #REF? 
C)  #NAME? 
D)  #DIV/0

Question 11

The ____ function searches vertically down the first column of the lookup table.

Accepted Answer

A)  VLOOK 
B)  VLOOKUP 
C)  HLOOK 
D)  HLOOKUP 
A)  VLOOK 
B)  VLOOKUP 
C)  HLOOK 
D)  HLOOKUP

Question 12

Whenever you enter a formula into an empty table row,Excel automatically fills the rest of that table row with the formula.

Accepted Answer

A) True 
 B)False

Question 13

In an unqualified structured reference,only the column qualifier appears in the reference._________________________

Accepted Answer

A) True 
 B)False

Question 14

Two common categories of formula errors in Excel are syntax errors and logic errors.

Accepted Answer

A) True 
 B)False

Question 15

-According to the dialog box in the accompanying figure,the lookup_value is found in row 2 of the table.

Accepted Answer

A) True 
 B)False

Question 16

Case-Based Critical Thinking Questions
Case 7-1
Evaluate the following formulas and functions.
-The following formula is used to determine Dean's List status.Assuming that B1 contains 15 and B2 contains 3.5,then =AND(B1>=12,B2>3.25),then ____.

Accepted Answer

A)  the formula indicates that the student is on the Dean's List 
B)  the formula indicates that the student is NOT on the Dean's List 
C)  the formula returns a value of 0 
D)  the formula returns an error message 
A)  the formula indicates that the student is on the Dean's List 
B)  the formula indicates that the student is NOT on the Dean's List 
C)  the formula returns a value of 0 
D)  the formula returns an error message

Question 17

To change the duplicate values background fill color,in the ____ group on the Home tab,click the Conditional Formatting button,and then click Manage Rules.

Accepted Answer

A)  Format 
B)  Options 
C)  Styles 
D)  Tools 
A)  Format 
B)  Options 
C)  Styles 
D)  Tools

Question 18

-According to the dialog box in the accompanying figure,the user is not looking for an exact match.

Accepted Answer

A) True 
 B)False

Question 19

The ____________________ error value appears when text is entered in a function that requires a number.

Accepted Answer

The answer of The ____________________ error value appears when text...

Question 20

Even if the compare values are not arranged in order,Excel can still retrieve the correct results from a lookup table used with a range of values.

Accepted Answer

A) True 
 B)False

You use the MEANIF function to calculate the average of values in a range that meet criteria you specify._________________________

In the Edit Formatting Rule dialog box,click the ____ button to open the Format Cells dialog box.

Using the VLOOKUP function,an approximate match lookup occurs when the value entered falls within a range of values in ____ of the lookup table.

Placing cell references to input values rather than constants in formulas makes a worksheet ____.

If you edit a cell in a calculated column so it is no longer consistent with the other formulas in the column,a ____ appears in the upper-left corner of the cell.

Discuss strategies for checking formulas for matching parentheses.

Omitting the range_lookup entry makes VLOOKUP a(n)____ lookup.

To get the effect of a calculated column in a range of data,you must copy and paste the formula or use the ____ feature.

-Given the flowchart in the accompanying figure,the Pay Grade of ____ yields a Bonus value of 2500.

If you see ____ as the result of a VLOOKUP formula,you might have entered a letter for the col_index_num instead of a number.

The ____ function searches vertically down the first column of the lookup table.

Whenever you enter a formula into an empty table row,Excel automatically fills the rest of that table row with the formula.

In an unqualified structured reference,only the column qualifier appears in the reference._________________________

Two common categories of formula errors in Excel are syntax errors and logic errors.

-According to the dialog box in the accompanying figure,the lookup_value is found in row 2 of the table.

Case-Based Critical Thinking Questions Case 7-1 Evaluate the following formulas and functions. -The following formula is used to determine Dean's List status.Assuming that B1 contains 15 and B2 contains 3.5,then =AND(B1>=12,B2>3.25),then ____.

To change the duplicate values background fill color,in the ____ group on the Home tab,click the Conditional Formatting button,and then click Manage Rules.

-According to the dialog box in the accompanying figure,the user is not looking for an exact match.

The ____________________ error value appears when text is entered in a function that requires a number.

Even if the compare values are not arranged in order,Excel can still retrieve the correct results from a lookup table used with a range of values.

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters

Exam 7: Using Advanced Functions and Conditional Formatting

You use the MEANIF function to calculate the average of values in a range that meet criteria you specify._________________________

In the Edit Formatting Rule dialog box,click the ____ button to open the Format Cells dialog box.

Using the VLOOKUP function,an approximate match lookup occurs when the value entered falls within a range of values in ____ of the lookup table.

Placing cell references to input values rather than constants in formulas makes a worksheet ____.

If you edit a cell in a calculated column so it is no longer consistent with the other formulas in the column,a ____ appears in the upper-left corner of the cell.

Discuss strategies for checking formulas for matching parentheses.

Omitting the range_lookup entry makes VLOOKUP a(n)____ lookup.

To get the effect of a calculated column in a range of data,you must copy and paste the formula or use the ____ feature.

-Given the flowchart in the accompanying figure,the Pay Grade of ____ yields a Bonus value of 2500.

If you see ____ as the result of a VLOOKUP formula,you might have entered a letter for the col_index_num instead of a number.

The ____ function searches vertically down the first column of the lookup table.

Whenever you enter a formula into an empty table row,Excel automatically fills the rest of that table row with the formula.

In an unqualified structured reference,only the column qualifier appears in the reference._________________________

Two common categories of formula errors in Excel are syntax errors and logic errors.

-According to the dialog box in the accompanying figure,the lookup_value is found in row 2 of the table.

Case-Based Critical Thinking Questions Case 7-1 Evaluate the following formulas and functions. -The following formula is used to determine Dean's List status.Assuming that B1 contains 15 and B2 contains 3.5,then =AND(B1>=12,B2>3.25),then ____.

To change the duplicate values background fill color,in the ____ group on the Home tab,click the Conditional Formatting button,and then click Manage Rules.

-According to the dialog box in the accompanying figure,the user is not looking for an exact match.

The ____________________ error value appears when text is entered in a function that requires a number.

Even if the compare values are not arranged in order,Excel can still retrieve the correct results from a lookup table used with a range of values.

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters