Questions

Multiple Choice

1. Excel can check data as it is entered using a process called data:
   1. Check.
   2. AutoCorrect.
   3. Validation.
   4. Protection.
   5. Verification.
2. A pop-up message that appears after an error is entered is called a(n):
   1. Input check.
   2. Data check.
   3. Caution box.
   4. Rule query.
   5. Error alert.
3. When you create a Warning alert box to prevent an invalid data entry, its message shows a(n):
   1. Yellow triangle.
   2. Red X.
   3. Red exclamation point.
   4. Wavy blue underline.
   5. Orange highlight.
4. The Insert Controls button for creating forms is found on this tab:
   1. Insert.
   2. Developer.
   3. Home.
   4. Data.
   5. Page Layout.
5. An object that you can use to display a choice, run commands, or perform actions in a worksheet is called a:
   1. Macro.
   2. Text box.
   3. Frame.
   4. Form control.
   5. Calculated field.
6. A step in finalizing a workbook for distribution in which you evaluate its readability for individuals with visual impairment is:
   1. Inspect Document.
   2. Check Accessibility.
   3. Form Control.
   4. Smart Lookup.
   5. Check Compatibility.
7. Alternative text can be added to an object in a worksheet to provide oral descriptions through use of a(n):
   1. Screen reader.
   2. Compatibility checker.
   3. Smart reader.
   4. Output message.
   5. Accessibility checker.
8. ActiveX controls are found under this tab:
   1. Add-ins.
   2. Formulas.
   3. View.
   4. Developer.
   5. Data.
9. To access recently used and popular Excel templates, open the Backstage view for the _____ command.
   1. Import
   2. New
   3. Publish
   4. Open
   5. Print
10. The Locked cell property is active by default for all cells, but is not enabled until you turn on:
    1. Passwords.
    2. Workbook protection.
    3. Worksheet protection.
    4. Encryption
    5. Lock Worksheet.
11. To prohibit changes to the layout of the workbook separately from the data, select:
    1. Lock Layout.
    2. Save as Template.
    3. Protect Workbook.
    4. Finalize Format.
    5. Protect Sheet.
12. Shared workbooks save a record of each change that has been made, which is called a(n):
    1. Data track.
    2. Edit log.
    3. Running edit.
    4. Version history.
    5. Record backup.
13. Properties that are embedded in an Excel file, such as the user name at time of creation, are called:
    1. Document data.
    2. Property tags.
    3. Backstage data.
    4. Background.
    5. Metadata.
14. A radio button that enables the user to select one choice from a set of possibilities is a(n):
    1. Table control.
    2. Survey control.
    3. Record control.
    4. Option Button control.
    5. Chart control.
15. A pop-up text box for a cell with explanations or questions for coworkers is a(n):
    1. Error alert.
    2. Validation setting.
    3. Note.
    4. Input message.
    5. Comment.