FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 8: Working With Advanced Functions

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

An error value begins with a(n)number sign followed by an error name,which indicates the type of error._________________________

A) True
B) False

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

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

If all of the logical conditions are true,the AND function returns the logical value _____.

With the DATEDIF function,the _____ interval code means months.

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

The ORERROR function can determine if a cell contains an error value and then display the message you choose.

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

If any logical condition listed in the function is true,the AND function returns a TRUE value._________________________

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.

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

You can include up to _____ logical conditions in the AND function.

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 -For a separate service recognition program,you need to calculate the length of service in complete years.What is the correct formula? 

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

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

In the DATEDIF function,the first date argument is the latest date._________________________

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.

Case 8-1 Evaluate the formula =AND(G2="FT",M2>=1) based upon the information provided. -What value is returned assuming that G2 contains the value FT and M2 contains the value 2? 

The _____ function calculates the number of cells in a range that match criteria you specify.

You could test two or more conditions and determine whether all conditions are true using the _____ function.