Multiple Choice
Match the following terms with their description:
i. Unqualified reference
II. Fully qualified structured reference
III. Structured reference
IV. SUBTOTAL function
v. Total row
A) Uses a field name as the reference in a table
B) Contains the table name
C) Field headings without row references
D) Displays below the last row in a table
E) Calculates an aggregate value
Correct Answer:

Verified
Correct Answer:
Verified
Q13: What feature in Excel automatically displays a
Q14: What is not true about creating a
Q29: Which one of the following filter options
Q48: You can add a row to a
Q51: Which table style option is useful to
Q53: In a data table each row is
Q65: What would be the result if you
Q77: It is impossible to create a data
Q82: Match the following terms with their description:<br>i.
Q88: In a structured reference, when you use