Excel 2016 Expert Lesson 1

Which of the following is the file extension used for Excel Template files?

• .xlsm

• .xltx

• .xlsx

• .xlam

Which of the following demonstrates the general format of a formula that references a cell in a different worksheet?

• CellAddress!SheetName

• SheetName#CellAddress

• CellAddress#SheetName

• SheetName!CellAddress

Which of the following statements best describes how to copy macros from one workbook to another?

• Drag the module from one project to another in the Project Explorer window of the Visual Basic Editor

• Use the Record Macro button on the Developer tab

• Use the Add-Ins button on the Developer tab

• Open the Visual Basic Editor and type RUN COPYMACROS in the Project Explorer window

Which of the following represents the syntax for a structured reference to a field in an Excel table?

• FieldName[TableName]

• TableName[FieldName]

• [FieldName]TableName

• [TableName]FieldName

Your co-worker sent you a workbook to update. You have entered new numbers in your worksheet, but the totals are not updating. Which of the following statements best describes how to remedy the problem?

• Click the Share Workbook button on the Review tab

• Go to the cells with the totals that are not updating, press the F2 key and then press Enter to re-enter the formulas

• Click the Calculation Options button on the Formulas tab and change the calculation setting from Manual to Automatic.

• Send the workbook back to your co-worker and have them fix it

Which of the following methods is used to display a hidden tab on the ribbon?

• On the View tab, in the Show group, click the Tabs button and select the tab you want to display.

• Right-click any tab on the ribbon and select Display Hidden Tabs

• On the Home tab, in the Cells group, click Insert and then select Show Hidden Tabs

• Display the Excel Options dialog box, select Customize Ribbon, and then select the check box next to the name of the tab you want to add.

Which of the following statements best describes how to create a custom template of your own?

• Click the File tab, select Save As, click Browse, and change the file type to .xltx.

• Click the File tab, select Save As, click Browse, and change the file type to .xlsm.

• Click the File tab, select Save As, click Browse, and change the file type to .xlam

• Click the File tab, select Options, click Save, select the Save as Template check box, and save the file as usual.

What is the name of the feature that saves copies of your files at specified intervals?

• Protect Sheet

• Track Changes

• AutoRecover

• Document Recovery

Which of the following would be considered a strong password based on the definition in this lesson?

• Tsj1961x

• 927%851*

• 4Nw9!tP@

• 239OAK$T

What is the name of the separate worksheet that temporarily lists all tracked changes in a shared workbook?

• Changes

• History

• Review

• Tracking