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 41

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

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

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

E) C) and D)
F) B) and C)

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

When using VLOOKUP,the _____argument is optional.

The ____________________ function calculates the difference between two dates and shows the result in months,days,or years.

When you create a calculated column,you can use _____ references to create the formula.

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.

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.

_____ references make it easier to create formulas that use portions or all of an Excel table because the names of headers are usually simpler to identify than cell addresses.

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.

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. -You implement the VLOOKUP formula at your colleague's suggestion,but you get the #VALUE! error as the result of the formula.Which of the following is likely true? 

Using the VLOOKUP function,an exact match lookup occurs when the value entered must match one of the values in _____ of the lookup table.

_____ just above the header row of an Excel table to select the column data but not the header.

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 the Edit Formatting Rule dialog box,click the _____ button to open the Format Cells dialog box.

When you want to reference an entire column of data in a table,you create a column _____.