BYSEX21C15SA
Forms you create in Excel can be printed and filled out on paper or directly in Excel.
Correct!
Review the section "Creating Forms."
A hyperlink can only be added to a shape or a picture.
Correct!
Review the section "Inserting Hyperlinks for Navigation."
If you aren’t sure where the next comment is, you can use the Next command in the Comments group on the Ribbon to find it.
Correct!
Review the section "Inserting and Viewing Comments."
Alt text provides a descriptive representation of the information contained in tables, charts, pictures, and shapes.
Correct!
Review the section "Adding Alternative Text to Objects for Accessibility."
The Document Inspector can locate and notify you if your workbook contains white text on a white background (which is invisible unless you select the cell or change the formatting).
Correct!
Review the section "Inspecting Your Workbook."
Between the two types of accessibility issues you might find in a workbook, warnings and errors, a warning identifies an accessibility issue that is considered more difficult for users with visual impairments to understand than an error would be.
Correct!
Review the section "Inspect a Workbook for Accessibility."
If you don’t set a password when protecting your workbook, you will be the only user who can remove the protection.
Correct!
Review the section "Protect Workbook Structure."
You want your assistant to input expense data into the range A7:H45 while preventing any other changes from being made to the worksheet. You should unlock the cells in the range A7:H45 and turn on worksheet protection (with a password).
Correct!
Review the section "Lock Cells and Hide Formulas."
To speed up the process of entering new client information into your system, you can use _____ and _____ and then allow customers to enter their own data.
Correct!
Review the section "Creating Forms."
Which cells contain a comment?
Range A8:C17. All cells are populated with text or numerical data. Cells with special markings: Cell C10: green triangle in upper-left corner, cell contents: #DIV/0!. Cell A13: red triangle in upper-right corner, cell contents: Oatmeal Biscuits Mix. Cell B13: purple mark in upper-right corner, cell contents: 4,636. Cell A15: purple mark in upper-right corner, cell contents: Clam Chowder. Cell C15: red triangle in upper-right corner, cell contents: 6,769.
Correct!
Review the section "Inserting and Viewing Comments."
Which of these is NOT included in the Document Inspector search?
Correct!
Review the section "Inspect a Workbook for Hidden Properties or Personal Information."
You created a workbook for next year’s income and expense calculations and want to prevent users from adding, deleting, and moving worksheets. You should use:
Correct!
Review the section "Protect Workbook Structure."