MGT 2180 EXCEL CHAPTER 7 QUESTIONS AND
ANSWERS
validation - Answers - excel can check data when it is entered using a process called
data:
error alert - Answers - a pop-up that appears after an error is entered is called a(n):
yellow triangle - Answers - when you create a Warning box to prevent an invalid data
entry, its message shows a(n):
developer - Answers - the Insert Controls button for creating from is found on this tab:
form control - Answers - an object that you can use to execute commands or perform
actions in a worksheet is called a(n):
32 - Answers - what is the maximum number of fields that a data input form can
display?
1 - Answers - how many records are visible at any one time in a data input form?
developer - Answers - ActiveX controls are found under this tab:
New - Answers - to access recently used and popular Excel templates, open the
backstage view for the _______ command.
worksheet protection - Answers - the locked cell property is turned on by default for all
cells, but is not enabled until you turn on:
Protect Workbook - Answers - to prohibit changes to the layout of the workbook
separately from the data, select:
change history - Answers - shared workbooks save a record of each change that has
been made which is called a(n):
metadata - Answers - properties that are embedded in an excel file, such as the user
name at time of creation, are called:
form - Answers - an excel screen object designed specifically for easy entry, tracking,
and organizing of data is called a(n):
trusted location - Answers - a folder that is designated as a secure, safe place to save
files is referred to as a(n):
ANSWERS
validation - Answers - excel can check data when it is entered using a process called
data:
error alert - Answers - a pop-up that appears after an error is entered is called a(n):
yellow triangle - Answers - when you create a Warning box to prevent an invalid data
entry, its message shows a(n):
developer - Answers - the Insert Controls button for creating from is found on this tab:
form control - Answers - an object that you can use to execute commands or perform
actions in a worksheet is called a(n):
32 - Answers - what is the maximum number of fields that a data input form can
display?
1 - Answers - how many records are visible at any one time in a data input form?
developer - Answers - ActiveX controls are found under this tab:
New - Answers - to access recently used and popular Excel templates, open the
backstage view for the _______ command.
worksheet protection - Answers - the locked cell property is turned on by default for all
cells, but is not enabled until you turn on:
Protect Workbook - Answers - to prohibit changes to the layout of the workbook
separately from the data, select:
change history - Answers - shared workbooks save a record of each change that has
been made which is called a(n):
metadata - Answers - properties that are embedded in an excel file, such as the user
name at time of creation, are called:
form - Answers - an excel screen object designed specifically for easy entry, tracking,
and organizing of data is called a(n):
trusted location - Answers - a folder that is designated as a secure, safe place to save
files is referred to as a(n):
