Question 1

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Searches across the first row of the lookup table

Accepted Answer

A) SUMIF 
B) VLOOKUP 
C) COUNTIF 
D) conditional formatting 
E) calculated column
F)AVERAGE
G)HLOOKUP
H)COUNT
I)logical condition
J)SUM
K)AVERAGEIF
L)cell and range addresses 
A) SUMIF 
B) VLOOKUP 
C) COUNTIF 
D) conditional formatting 
E) calculated column
F)AVERAGE
G)HLOOKUP
H)COUNT
I)logical condition
J)SUM
K)AVERAGEIF
L)cell and range addresses

Question 2

You can use a ____ function to return a value from a table that is based on an approximate match lookup.

Accepted Answer

A)  VLOOKUP 
B)  VAVERAGE 
C)  VMATCH 
D)  VAPPROXIMATE 
A)  VLOOKUP 
B)  VAVERAGE 
C)  VMATCH 
D)  VAPPROXIMATE

Question 3

You can ____ IF functions to allow for three or more outcomes.

Accepted Answer

A)  loop 
B)  cycle 
C)  nest 
D)  link 
A)  loop 
B)  cycle 
C)  nest 
D)  link

Question 4

____ just above a cell in the header row of an Excel table to select the column data but not the header.

Accepted Answer

A)  Click 
B)  Double-click 
C)  Triple-click 
D)  Right-click 
A)  Click 
B)  Double-click 
C)  Triple-click 
D)  Right-click

Question 5

The ____________________ function is a logical function that returns a TRUE value if any of the logical conditions are true and a FALSE value if the logical conditions are false.

Accepted Answer

The answer of The ____________________ function is a logical function...

Question 6

You can filter a table by color.Display the filter arrows,click a filter arrow,point to Filter by Color,and then click a color to display only cells with that fill or click ____ to display only cells without a fill.

Accepted Answer

A)  Without Fill 
B)  No Fill 
C)  Plain 
D)  Solid 
A)  Without Fill 
B)  No Fill 
C)  Plain 
D)  Solid

Question 7

Case-Based Critical Thinking Questions
Case 7-1
Evaluate the following formulas and functions.
-Assuming that G2 contains the value FT and M2 contains the value 2,evaluate the formula and tell what value is returned: =AND(G2="FT",M2>=1).

Accepted Answer

A)  TRUE 
B)  FALSE 
C)  PT 
D)  PT,2 
A)  TRUE 
B)  FALSE 
C)  PT 
D)  PT,2

Question 8

Nesting IF functions will allow for three or more outcomes.

Accepted Answer

A) True 
 B)False

Question 9

The COUNTIF function is sometimes referred to as a(n)____ count.

Accepted Answer

A)  network 
B)  criterion 
C)  conditional 
D)  basic 
A)  network 
B)  criterion 
C)  conditional 
D)  basic

Question 10

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

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 11

To set up an approximate match lookup table so it works in Excel,the leftmost column in the lookup table must represent the lower end of the range for each category,and the lookup table must be sorted in ____.

Accepted Answer

A)  ascending order based on the value in the first column 
B)  descending order based on the value in the first column 
C)  ascending order based on the value in the last column 
D)  descending order based on the value in the last column 
A)  ascending order based on the value in the first column 
B)  descending order based on the value in the first column 
C)  ascending order based on the value in the last column 
D)  descending order based on the value in the last column

Question 12

You can use ____ to reference cells within an Excel table.

Accepted Answer

A)  structured references 
B)  cell and range addresses 
C)  both a.and b. 
D)  neither a.nor b. 
A)  structured references 
B)  cell and range addresses 
C)  both a.and b. 
D)  neither a.nor b.

Question 13

If you are creating a calculated column or formula within an Excel table,you can use the ____ structured reference in the formula.

Accepted Answer

A)  basic 
B)  advanced 
C)  unqualified 
D)  restricted 
A)  basic 
B)  advanced 
C)  unqualified 
D)  restricted

Question 14

Case-Based Critical Thinking Questions
Case 7-2
Your boss in the human resources department asks you to write a function that calculates the length of time that employees have been with the firm,using the DATEDIF function.Assume that C2 contains the hire date for a given employee and that cell $AE$2 contains the cut-off date against which to compare the hire date to determine length of service.
-Just on a lark,for a year-end trivia contest,your boss wants you to calculate the length of service in complete days.What is the correct formula?

Accepted Answer

A)  =DATEDIF(C2,$AE$2,"today") 
B)  =DATEDIF($AE$2,C2,"dy") 
C)  =DATEDIF($AE$2,C2,"day") 
D)  =DATEDIF(C2,$AE$2,"d") 
A)  =DATEDIF(C2,$AE$2,"today") 
B)  =DATEDIF($AE$2,C2,"dy") 
C)  =DATEDIF($AE$2,C2,"day") 
D)  =DATEDIF(C2,$AE$2,"d")

Question 15

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-expression that returns either a TRUE value or a FALSE value

Accepted Answer

A) SUMIF 
B) VLOOKUP 
C) COUNTIF 
D) conditional formatting 
E) calculated column
F)AVERAGE
G)HLOOKUP
H)COUNT
I)logical condition
J)SUM
K)AVERAGEIF
L)cell and range addresses 
A) SUMIF 
B) VLOOKUP 
C) COUNTIF 
D) conditional formatting 
E) calculated column
F)AVERAGE
G)HLOOKUP
H)COUNT
I)logical condition
J)SUM
K)AVERAGEIF
L)cell and range addresses

Question 16

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Use to highlight duplicate values in a range with a font and/or fill color

Accepted Answer

A) SUMIF 
B) VLOOKUP 
C) COUNTIF 
D) conditional formatting 
E) calculated column
F)AVERAGE
G)HLOOKUP
H)COUNT
I)logical condition
J)SUM
K)AVERAGEIF
L)cell and range addresses 
A) SUMIF 
B) VLOOKUP 
C) COUNTIF 
D) conditional formatting 
E) calculated column
F)AVERAGE
G)HLOOKUP
H)COUNT
I)logical condition
J)SUM
K)AVERAGEIF
L)cell and range addresses

Question 17

You can edit existing conditional formatting rules from the Conditional Formatting ____ dialog box.Click the Edit Rule button and make the appropriate changes.

Accepted Answer

A)  Rules Editor 
B)  Rules Manager 
C)  Editor 
D)  Manager 
A)  Rules Editor 
B)  Rules Manager 
C)  Editor 
D)  Manager

Question 18

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Searches down the first column of the lookup table

Accepted Answer

A) SUMIF 
B) VLOOKUP 
C) COUNTIF 
D) conditional formatting 
E) calculated column
F)AVERAGE
G)HLOOKUP
H)COUNT
I)logical condition
J)SUM
K)AVERAGEIF
L)cell and range addresses 
A) SUMIF 
B) VLOOKUP 
C) COUNTIF 
D) conditional formatting 
E) calculated column
F)AVERAGE
G)HLOOKUP
H)COUNT
I)logical condition
J)SUM
K)AVERAGEIF
L)cell and range addresses

Question 19

You can edit existing conditional formatting ____ from the Conditional Formatting Rules Manager dialog box.

Accepted Answer

A)  themes 
B)  objects 
C)  tables 
D)  rules 
A)  themes 
B)  objects 
C)  tables 
D)  rules

Question 20

The COUNTAS function counts the number of cells within a range that meet multiple criteria.

Accepted Answer

A) True 
 B)False

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Searches across the first row of the lookup table

You can use a ____ function to return a value from a table that is based on an approximate match lookup.

You can ____ IF functions to allow for three or more outcomes.

____ just above a cell in the header row of an Excel table to select the column data but not the header.

The ____________________ function is a logical function that returns a TRUE value if any of the logical conditions are true and a FALSE value if the logical conditions are false.

You can filter a table by color.Display the filter arrows,click a filter arrow,point to Filter by Color,and then click a color to display only cells with that fill or click ____ to display only cells without a fill.

Case-Based Critical Thinking Questions Case 7-1 Evaluate the following formulas and functions. -Assuming that G2 contains the value FT and M2 contains the value 2,evaluate the formula and tell what value is returned: =AND(G2="FT",M2>=1).

Nesting IF functions will allow for three or more outcomes.

The COUNTIF function is sometimes referred to as a(n)____ count.

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

To set up an approximate match lookup table so it works in Excel,the leftmost column in the lookup table must represent the lower end of the range for each category,and the lookup table must be sorted in ____.

You can use ____ to reference cells within an Excel table.

If you are creating a calculated column or formula within an Excel table,you can use the ____ structured reference in the formula.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -expression that returns either a TRUE value or a FALSE value

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Use to highlight duplicate values in a range with a font and/or fill color

You can edit existing conditional formatting rules from the Conditional Formatting ____ dialog box.Click the Edit Rule button and make the appropriate changes.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Searches down the first column of the lookup table

You can edit existing conditional formatting ____ from the Conditional Formatting Rules Manager dialog box.

The COUNTAS function counts the number of cells within a range that meet multiple criteria.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Searches across the first row of the lookup table

You can use a ____ function to return a value from a table that is based on an approximate match lookup.

You can ____ IF functions to allow for three or more outcomes.

____ just above a cell in the header row of an Excel table to select the column data but not the header.

The ____________________ function is a logical function that returns a TRUE value if any of the logical conditions are true and a FALSE value if the logical conditions are false.

You can filter a table by color.Display the filter arrows,click a filter arrow,point to Filter by Color,and then click a color to display only cells with that fill or click ____ to display only cells without a fill.

Case-Based Critical Thinking Questions Case 7-1 Evaluate the following formulas and functions. -Assuming that G2 contains the value FT and M2 contains the value 2,evaluate the formula and tell what value is returned: =AND(G2="FT",M2>=1).

Nesting IF functions will allow for three or more outcomes.

The COUNTIF function is sometimes referred to as a(n)____ count.

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

To set up an approximate match lookup table so it works in Excel,the leftmost column in the lookup table must represent the lower end of the range for each category,and the lookup table must be sorted in ____.

You can use ____ to reference cells within an Excel table.

If you are creating a calculated column or formula within an Excel table,you can use the ____ structured reference in the formula.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -expression that returns either a TRUE value or a FALSE value

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Use to highlight duplicate values in a range with a font and/or fill color

You can edit existing conditional formatting rules from the Conditional Formatting ____ dialog box.Click the Edit Rule button and make the appropriate changes.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Searches down the first column of the lookup table

You can edit existing conditional formatting ____ from the Conditional Formatting Rules Manager dialog box.

The COUNTAS function counts the number of cells within a range that meet multiple criteria.

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