Matching
Match the following terms to their descriptions:
Premises:
Total row
Conditional formatting
Sum,average,min,max
Structured reference
SUBTOTAL function
Responses:
Last row of a table to display summary statistics
Statistical functions
Highlights or emphasizes cells that meet certain conditions
Tag or use of a table element as a reference in a formula
Calculates aggregate values in a range or database
Correct Answer:
Premises:
Responses:
Total row
Conditional formatting
Sum,average,min,max
Structured reference
SUBTOTAL function
Premises:
Total row
Conditional formatting
Sum,average,min,max
Structured reference
SUBTOTAL function
Responses:
Related Questions
Q23: What are two built-in functionality features in
Q24: Match of the following:
Q25: To create a(n)_ from an existing range
Q26: The use of field headings without row
Q27: In Excel 2013 a dataset:<br>A)indicates where data
Q29: A structured reference:<br>A)is a tag or use
Q30: Unfreeze Panes only appears on the menu
Q32: A Table style controls:<br>A)check boxes to select
Q33: Banded Rows display alternate fill colors for
Q50: To _ a table into a range,