Question 1

What are the guidelines to keep in mind when creating fields in an Excel table?

Accepted Answer

Excel tables should be easy to use as we

Question 2

Case-Based Critical Thinking Questions
Case 8-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.
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 3

To highlight duplicate values, in the Styles group on the _____ tab, click the Conditional Formatting button, point to Highlight Cells Rules, and then click Duplicate Values.

Accepted Answer

A)  HOME 
B)  PAGE LAYOUT 
C)  FORMULAS 
D)  DATA 
A)  HOME 
B)  PAGE LAYOUT 
C)  FORMULAS 
D)  DATA

Question 4

The ____________________ function is used to change the orientation of a range-that is, return a vertical range of cells as a horizontal range, or vice versa.

Accepted Answer

The answer of The ____________________ function is used to change...

Question 5

Match between columns
                        Premises: Searches across the first row of the lookup table

Accepted Answer

The Answer of TRANSPOSE and DATEDIF and logical condition and is...

Question 6

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 7

Match between columns
                        Premises: Adds the values in a range that meet criteria you specify

Accepted Answer

The Answer of SUMIF and COUNTIF and AVERAGE and conditional is...

Question 8

According to the dialog box in the accompanying figure, the MedicalRates table is the one from which the data in your funtion argument will be obtained.

Accepted Answer

A) True 
 B)False

Question 9

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 10

Match between columns
                        Premises: Calculates the number of cells in a range that match criteria you specify using this function

Accepted Answer

The Answer of logical condition and conditional formatting and SUM is...

Question 11

A(n) ____________________ match lookup occurs when the lookup value is found within a range of numbers in the first column (or row) of the lookup table.

Accepted Answer

The answer of A(n) ____________________ match lookup occurs when the...

Question 12

A formula that includes a structured reference can be fully qualified or unqualified.

Accepted Answer

A) True 
 B)False

Question 13

Lookup _____ allow you to use tables of data to "look up" values and insert them in another worksheet location.

Accepted Answer

A)  functions 
B)  formulas 
C)  equations 
D)  calculations 
A)  functions 
B)  formulas 
C)  equations 
D)  calculations

Question 14

Match between columns
                        Premises: Changes a cell's formatting when its contents match a specified condition

Accepted Answer

The Answer of SUMIF and logical condition and VLOOKUP and is...

Question 15

The _____ function is a logical function that evaluates a condition and then returns one value if the condition is true and another value if the condition is false.

Accepted Answer

A)  THIS 
B)  IF 
C)  WHEN 
D)  NOT 
A)  THIS 
B)  IF 
C)  WHEN 
D)  NOT

Question 16

The IF function evaluates a(n) single condition.

Accepted Answer

A) True 
 B)False

Question 17

If a formula is in a calculated table column, you need to make a change in only one cell and the change will automatically be copied to all the cells in the column.

Accepted Answer

A) True 
 B)False

Question 18

Given the flowchart in the accompanying figure, the Perf Rating of _____ yields a Bonus value of 2500.

Accepted Answer

A)  1 
B)  2 
C)  0 
D)  7500 
A)  1 
B)  2 
C)  0 
D)  7500

Question 19

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 20

In a fully qualified structured reference, the table name follows the column qualifier.

Accepted Answer

A) True 
 B)False

What are the guidelines to keep in mind when creating fields in an Excel table?

To highlight duplicate values, in the Styles group on the _____ tab, click the Conditional Formatting button, point to Highlight Cells Rules, and then click Duplicate Values.

The ____________________ function is used to change the orientation of a range-that is, return a vertical range of cells as a horizontal range, or vice versa.

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

According to the dialog box in the accompanying figure, the MedicalRates table is the one from which the data in your funtion argument will be obtained.

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.

A(n) ____________________ match lookup occurs when the lookup value is found within a range of numbers in the first column (or row) of the lookup table.

A formula that includes a structured reference can be fully qualified or unqualified.

Lookup _____ allow you to use tables of data to "look up" values and insert them in another worksheet location.

The _____ function is a logical function that evaluates a condition and then returns one value if the condition is true and another value if the condition is false.

The IF function evaluates a(n) single condition.

If a formula is in a calculated table column, you need to make a change in only one cell and the change will automatically be copied to all the cells in the column.

Given the flowchart in the accompanying figure, the Perf Rating of _____ yields a Bonus value of 2500.

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

In a fully qualified structured reference, the table name follows the column qualifier.

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

What are the guidelines to keep in mind when creating fields in an Excel table?

To highlight duplicate values, in the Styles group on the _____ tab, click the Conditional Formatting button, point to Highlight Cells Rules, and then click Duplicate Values.

The ____________________ function is used to change the orientation of a range-that is, return a vertical range of cells as a horizontal range, or vice versa.

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

According to the dialog box in the accompanying figure, the MedicalRates table is the one from which the data in your funtion argument will be obtained.

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.

A(n) ____________________ match lookup occurs when the lookup value is found within a range of numbers in the first column (or row) of the lookup table.

A formula that includes a structured reference can be fully qualified or unqualified.

Lookup _____ allow you to use tables of data to "look up" values and insert them in another worksheet location.

The _____ function is a logical function that evaluates a condition and then returns one value if the condition is true and another value if the condition is false.

The IF function evaluates a(n) single condition.

If a formula is in a calculated table column, you need to make a change in only one cell and the change will automatically be copied to all the cells in the column.

Given the flowchart in the accompanying figure, the Perf Rating of _____ yields a Bonus value of 2500.

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

In a fully qualified structured reference, the table name follows the column qualifier.

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