Chapter Seven

Question 1

What is a comment message that appears on screen as soon as a cell with data validation is selected?

Answer 1

Input Message

Question 2

What is NOT an option in the ALLOW drop-down list when setting data validation with an operator?
Any Value
Between
Decimal
Whole Number

Answer 2

Between

Question 3

What are the RULES applied to data as it is entered?

Answer 3

Validation Settings

Question 4

What extension does Excel assign to templates?

Answer 4

.xltx

Question 5

What function would be the best option for converting the numeric output of a combo box lined cell into the original user section and placing it into worksheet cell?

Answer 5

INDEX

Question 6

What name is assigned to the person who shares a workbook?

Answer 6

the owner

Question 7

An object that you can use to display a choice, run commands, or perform actions in a worksheet is called what?

Answer 7

Form Control

Question 8

What is true when creating a workbook from a template?

Answer 8

the Backstage New command displays recently published templates, a workbook with the same name as the template followed by a number opens, the Blank workbook template creates a new workbook