Question 1

You can calculate the number of cells in a range that match criteria you specify using the SUMIF function.

Accepted Answer

A) True 
 B)False  False

Question 2

Duplicate value highlighting helps to verify that columns of data have unique entries.

Accepted Answer

A) True 
 B)False  True

Question 3

The ____________________ function adds the values in a range that meet criteria you specify.

Accepted Answer

SUMIF

Question 4

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

Accepted Answer

A)  IF 
B)  AND 
C)  OR 
D)  THIS 
A)  IF 
B)  AND 
C)  OR 
D)  THIS

Question 5

The ____________________ function searches horizontally across a lookup table and is used when the compare values are stored in the first row of the lookup table.

Accepted Answer

The answer of The ____________________ function searches horizontally across a...

Question 6

Case-Based Critical Thinking Questions
Case 8-3
You have been using a variety of nested IF functions to calculate costs in your spreadsheet when a colleague stops by and comments on what you have been working on, suggesting that there is an easier approach to use.
If you omit the range_lookup value from a LOOKUP function, which of the following is true?

Accepted Answer

A)  The function returns the #NAME? error value. 
B)  Your function can only search the first column of the lookup table. 
C)  It is considered an approximate match. 
D)  It is considered an exact match. 
A)  The function returns the #NAME? error value. 
B)  Your function can only search the first column of the lookup table. 
C)  It is considered an approximate match. 
D)  It is considered an exact match.

Question 7

Match between columns
                        Premises: Expression that returns either a TRUE value or a FALSE value

Accepted Answer

The Answer of AVERAGE and HLOOKUP and DATEDIF and COUNTIF is...

Question 8

A(n) ____________________ IF function is when one IF function is placed inside another IF function to test an additional condition.

Accepted Answer

The answer of A(n) ____________________ IF function is when one...

Question 9

The _____ error value means that a value is not available to a function or formula.

Accepted Answer

A)  #NAME? 
B)  #N/A 
C)  #NULL! 
D)  #NUM! 
A)  #NAME? 
B)  #N/A 
C)  #NULL! 
D)  #NUM!

Question 10

A(n) ____________________ specifies the type of condition, the type of formatting when that condition occurs, and the cell or range the formatting is applied to.

Accepted Answer

conditiona

Question 11

If you are not sure of a table's name, click in the table, click the _____ tab on the Ribbon, and then click the Table Name box in the Properties group.

Accepted Answer

A)  LAYOUT 
B)  FORMAT 
C)  TABLE TOOLS DESIGN 
D)  STRUCTURED REFERENCES 
A)  LAYOUT 
B)  FORMAT 
C)  TABLE TOOLS DESIGN 
D)  STRUCTURED REFERENCES

Question 12

The complete formula that corresponds to the flowchart in the accompanying figure is _____.

Accepted Answer

A)  =IF([Perf Rating]=2,2500,IF([Perf Rating]=1,2500,7500)) 
B)  =AND([Perf Rating]=2,2500,AND([Perf Rating]=1,2500,7500)) 
C)  =IF([Perf Rating]=1,0,IF([Perf Rating]=2,2500,7500)) 
D)  =AND([Perf Rating]=1,2500,AND([Perf Rating]=2,0,7500)) 
A)  =IF([Perf Rating]=2,2500,IF([Perf Rating]=1,2500,7500)) 
B)  =AND([Perf Rating]=2,2500,AND([Perf Rating]=1,2500,7500)) 
C)  =IF([Perf Rating]=1,0,IF([Perf Rating]=2,2500,7500)) 
D)  =AND([Perf Rating]=1,2500,AND([Perf Rating]=2,0,7500))

Question 13

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

Accepted Answer

A)  unstructured references 
B)  cell and range addresses 
C)  macros 
D)  links 
A)  unstructured references 
B)  cell and range addresses 
C)  macros 
D)  links

Question 14

Match between columns
                        Premises: Adds the values in a range

Accepted Answer

The Answer of VLOOKUP and COUNTIF and DATEDIF and conditional is...

Question 15

The Conditional Formatting button provides access to the _____.

Accepted Answer

A)  Replicate Values conditional format 
B)  Manage Rules option 
C)  Criteria option 
D)  Organize Rules option 
A)  Replicate Values conditional format 
B)  Manage Rules option 
C)  Criteria option 
D)  Organize Rules option

Question 16

To change the background fill color of duplicate values, 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 17

Discuss strategies for checking formulas for matching parentheses.

Accepted Answer

A common problem when creating formulas

Question 18

When you create a formula that references all or parts of an Excel table, you can replace the specific cell or range address with a(n) ____________________ reference, the actual table name or column header.

Accepted Answer

The answer of When you create a formula that references...

Question 19

Match between columns
                        Premises: Calculates the difference between two dates

Accepted Answer

The Answer of COUNTIF and SUM and TRANSPOSE and VLOOKUP is...

Question 20

In most cases, when manually creating a conditional formatting formula, the formula should use absolute references and point to the first row of data in a table.

Accepted Answer

A) True 
 B)False

You can calculate the number of cells in a range that match criteria you specify using the SUMIF function.

Duplicate value highlighting helps to verify that columns of data have unique entries.

The ____________________ function adds the values in a range that meet criteria you specify.

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

The ____________________ function searches horizontally across a lookup table and is used when the compare values are stored in the first row of the lookup table.

A(n) ____________________ IF function is when one IF function is placed inside another IF function to test an additional condition.

The _____ error value means that a value is not available to a function or formula.

A(n) ____________________ specifies the type of condition, the type of formatting when that condition occurs, and the cell or range the formatting is applied to.

If you are not sure of a table's name, click in the table, click the _____ tab on the Ribbon, and then click the Table Name box in the Properties group.

The complete formula that corresponds to the flowchart in the accompanying figure is _____.

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

The Conditional Formatting button provides access to the _____.

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

Discuss strategies for checking formulas for matching parentheses.

When you create a formula that references all or parts of an Excel table, you can replace the specific cell or range address with a(n) ____________________ reference, the actual table name or column header.

In most cases, when manually creating a conditional formatting formula, the formula should use absolute references and point to the first row of data in a table.

Access: Creating Advanced Queries and Enhancing Table Design

Access: Using Form Tools and Creating Custom Forms

Access: Creating Custom Reports

Access: Sharing, Integrating, and Analyzing Data

Excell: Working With Excel Tables, Pivottables, and Pivotcharts

Excell: Managing Multiple Worksheets and Workbooks

Excell: Developing an Excel Application

Powerpoint: Applying Advanced Formatting to Objects

Powerpoint: Advanced Animations and Distributing Presentations

Word: Working With Templates, Themes, and Styles

Word: Using Mail Merge

Word: Collaborating With Others and Integrating Data

Filters

Exam 8: Excell: Working With Advanced Functions

You can calculate the number of cells in a range that match criteria you specify using the SUMIF function.

Duplicate value highlighting helps to verify that columns of data have unique entries.

The ____________________ function adds the values in a range that meet criteria you specify.

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

The ____________________ function searches horizontally across a lookup table and is used when the compare values are stored in the first row of the lookup table.

A(n) ____________________ IF function is when one IF function is placed inside another IF function to test an additional condition.

The _____ error value means that a value is not available to a function or formula.

A(n) ____________________ specifies the type of condition, the type of formatting when that condition occurs, and the cell or range the formatting is applied to.

If you are not sure of a table's name, click in the table, click the _____ tab on the Ribbon, and then click the Table Name box in the Properties group.

The complete formula that corresponds to the flowchart in the accompanying figure is _____.

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

The Conditional Formatting button provides access to the _____.

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

Discuss strategies for checking formulas for matching parentheses.

When you create a formula that references all or parts of an Excel table, you can replace the specific cell or range address with a(n) ____________________ reference, the actual table name or column header.

In most cases, when manually creating a conditional formatting formula, the formula should use absolute references and point to the first row of data in a table.

Access: Creating Advanced Queries and Enhancing Table Design

Access: Using Form Tools and Creating Custom Forms

Access: Creating Custom Reports

Access: Sharing, Integrating, and Analyzing Data

Excell: Working With Excel Tables, Pivottables, and Pivotcharts

Excell: Managing Multiple Worksheets and Workbooks

Excell: Developing an Excel Application

Powerpoint: Applying Advanced Formatting to Objects

Powerpoint: Advanced Animations and Distributing Presentations

Word: Working With Templates, Themes, and Styles

Word: Using Mail Merge

Word: Collaborating With Others and Integrating Data

Filters