Site MapHelpFeedbackMultiple Choice Quiz
Multiple Choice Quiz
(See related pages)

1
Excel can check data when it is entered using a process called data:
A)Check.
B)AutoCorrect.
C)Validation.
D)Verification.
2
A pop-up message that appears after an error is entered is called:
A)An error alert,
B)A data check,
C)A caution box,
D)A rule query,
3
When you create a warning box to prevent an invalid data entry, its message shows:
A)A yellow triangle,
B)A red X,
C)A wavy blue underline,
D)An orange highlight,
4
The Insert Controls button for creating forms is found on this tab:
A)Insert
B)Data
C)Formatting
D)Developer
5
An object that you can use to execute commands or perform actions in a worksheet is called:
A)A macro,
B)A text box,
C)A frame,
D)A form control,
6
What is the maximum number of fields that a data input form can display?
A)1
B)16
C)32
D)64
7
How many records are visible at any one time in a data input form?
A)1
B)16
C)32
D)64
8
ActiveX controls are found under this tab:
A)Add-ins
B)Formulas
C)Data
D)Developer
9
To edit an Excel worksheet that is marked as final and therefore should not be edited, click:
A)Edit Anyway.
B)Revert.
C)Undo Final.
D)Ignore.
10
To remove a password on a protected worksheet, you must first must open the workbook, and then select:
A)Edit.
B)Protect Workbook.
C)Encrypt with password.
D)Undo password.
11
To prohibit changes to the layout of the workbook separately from the data, select:
A)Lock Layout.
B)Save as Template.
C)Protect Workbook Structure.
D)Finalize Format.
12
Shared workbooks save a record of each change that has been made which is called a(n):
A)Data track.
B)Edit log.
C)Running edit.
D)Change history.
13
Properties that are embedded in an Excel file, such as the user name at time of creation, are called:
A)Metadata.
B)Property tags.
C)Backstage data.
D)Background.
14
A worksheet designed specifically for easy entry, tracking, and organizing of data is called a:
A)Table.
B)Survey.
C)Record.
D)Form.
15
A folder that contains secure, safe workbooks is referred to as a(n):
A)Vault.
B)Protected file.
C)Trusted location.
D)Personal file.





To learn more about the book this website supports, please visit its Information Center.
Copyright (c)2014 McGraw-Hill Education .
Any use is subject to the Terms of Use and Privacy Notice | Report Piracy


Nordell, 1eOnline Learning Center

Home > Excel > Chapter 7 > Ch 7: Multiple Choice Quiz