Matching
Identify the letter of the choice that best matches the phrase or definition.
Premises:
A feature that instantly adds a formula that totals the worksheet data to a cell.
Displays specific selections from which you can choose.
An option that separates data for you, rather than you having to retype it yourself.
A feature that enables you to view data from one worksheet while you enter or view data in another worksheet.
A feature that is used to set rules about how data can be entered.
Responses:
Data Validation
Subtotal
Convert Text to Columns
drop-down list
Watch Window
Correct Answer:
Premises:
Responses:
A feature that instantly adds a formula that totals the worksheet data to a cell.
Displays specific selections from which you can choose.
An option that separates data for you, rather than you having to retype it yourself.
A feature that enables you to view data from one worksheet while you enter or view data in another worksheet.
A feature that is used to set rules about how data can be entered.
Premises:
A feature that instantly adds a formula that totals the worksheet data to a cell.
Displays specific selections from which you can choose.
An option that separates data for you, rather than you having to retype it yourself.
A feature that enables you to view data from one worksheet while you enter or view data in another worksheet.
A feature that is used to set rules about how data can be entered.
Responses:
Related Questions
Q82: You can create custom sorting options in
Q204: Case EX 11-2 Sharon has a large
Q206: The _ feature is useful when you
Q248: To add subtotals, you select the Subtotal
Q271: Using a(n) _ lets you view two
Q275: In the outline format, you can click
Q314: To remove subtotals from the data, click
Q386: The _ feature is a great method
Q721: Adding a _ allows you to set
Q733: The _ feature quickly calculates subtotals and