Multiple Choice
To specify a long list of valid entries you can type them ____ and then type the list range in the Source text box.
A) on a new sheet
B) in the formula bar
C) in another workbook
D) elsewhere in the worksheet
Correct Answer:

Verified
Correct Answer:
Verified
Q44: To clear a filter,click the _.<br>A) Clear
Q45: You can filter records based on information
Q46: The menu that appears when you click
Q47: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB7032/.jpg" alt=" -In the accompanying
Q48: When you define the criteria range and
Q50: You often create subtotals with the _
Q51: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB7032/.jpg" alt=" -In the accompanying
Q52: When you create a table,Excel automatically generates
Q53: Use the _ function when you want
Q54: When you _ data,you place a copy