Multiple Choice
____ references make it easier to create formulas that use portions or all of an Excel table because the names or headers are usually simpler to identify than cell addresses.
A) Indexed
B) Structured
C) Key
D) Logical
Correct Answer:

Verified
Correct Answer:
Verified
Q106: The _ qualifier references the entire table.<br>A)#Data<br>B)#All<br>C)#Headers<br>D)#Totals
Q107: For conditional formatting a formula must be
Q108: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TBX9149/.jpg" alt=" Given the dialog
Q109: If you need to modify the formula
Q110: _ formatting changes a cell's formatting when
Q112: If a formula is in a calculated
Q113: All the logical conditions listed in an
Q114: The _ error value means that the
Q115: In most cases a formula should use
Q116: Identify the letter of the choice that