Microsoft Excel 2019 Advanced

Front

Which button in the Info portion of Backstage View opens a menu that contains the command to check for accessibility issues? Options: Protect Workbook, Browser View Options, Password

Back

Check for Issues

Front

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

Back

Document Inspector

Front

Which file type should be chosen when saving a workbook as a template? Options: Custom Office Template, Excel Template, Excel 97-2003 Workbook, Compatibility Template

Back

Excel Template

Front

Which location in the New portion of Backstage View should be clicked to view a workbook template you created? (Options: Business, Personal, Featured, Design)

Back

Personal

Front

Which type of form control should Mark enter to run a macro when clicked? Options: List box, Spin button, Check box, Button

Back

Button

Front

Which tab must be present on the Ribbon to insert form controls? (Options: Form, Control, Data Form, Developer)

Back

Developer

Front

Which of the following tools can be used to create a data form? Options: Form Tool, Form Wizard, Form Genie, Form Template

Back

Form Tool

Front

Which tab contains the command to add a sparkline to a worksheet? Options: File, Home, Insert, Data

Back

Insert

Front

Which tab on the Ribbon holds the command to open the formula view? Options: Home, Page Layout, Data, Formulas

Back

Formulas

Front

Which of the following is NOT a comparison operator? > greater than arrow, < less than arrow, >= greater than arrow, equal sign, / slash

Back

/ slash