Microsoft Excel 2019 Advanced

Which of the following buttons in the Info portion of Backstage View opens a menu which contains the command to check for accessibility issues?

• Protect Workbook
• Check for Issues
• Browser View Options
• Password

Which of the following tools can be used to inspect a document for hidden data and personal information?

• Document Inspector
• Accessibility Checker
• Compatibility Checker
• Conditional Inspector

Which of the following file types should be chosen when saving a workbook as a template?

• Custom Office Template
• Excel Template
• Excel 97-2003 Workbook
• Compatibility Template

Which of the following locations in the New portion of Backstage View should be clicked to view a workbook template you created?

• Business
• Personal
• Featured
• Design

Which of the following types of form controls should Mark enter if he wants the control to run a macro when clicked?

• List box
• Spin button
• Check box
• Button

Which of the following tabs must be present on the Ribbon to insert form controls?

• Form
• Control
• Data Form
• Developer

Which of the following tools can be used to create a data form?

• Form Tool
• Form Wizard
• Form Genie
• Form Template

Which of the following tabs contains the command to add a sparkline to a worksheet?

• File
• Home
• Insert
• Data

Which tab on the Ribbon holds the command to open the formula view?

• Home
• Page Layout
• Data
• Formulas

Which of the following is NOT a comparison operator?

• > greater than arrow
• < less than arrow
• >= greater than arrow, equal sign
• / slash