Excel EA 25-29 Tutorial Review

Which feature is presented in tutorial 25 that can be engaged to review changes before making them permanent.

• Comments

• Track Changes

• Show/Hide

• Show All

What option in tutorial 25 allows users to see formatting marks that are otherwise invisible?

• Track Changes

• Comments

• Show/Hide

• Review Pane

In tutorial 25, which feature enables users to add annotations or notes to the document?

• Comments

• Show All

• Track Changes

• Document Inspector

Which tool is highlighted in tutorial 25 for comparing two versions of a document?

• Compare

• Track Changes

• Document Inspector

• Review Pane

Which feature parented in tutorial 26, allows the user to search for and remove personal information before sharing a workbook with others?

• Protect Workbook

• Check Compatibility

• Check Accessibility

• Document Inspector

In tutorial 26, which option is used to add a digital signature to the document?

• Encrypt with Password

• Mark as Final

• Add a Digital Signature

• Protect Workbook

If you want to keep others from editing your excel workbook, which feature should you use?

• Restrict Access

• Document Inspector

• Mark Final

• Show/Hide

In tutorial 26, which feature helps in ensuring that the document adheres to accessibility standards?

• Check Compatibility

• Document Inspector

• Check Accessibility

• Protect Workbook

Which feature in tutorial 26 is used to encrypt the document with a password?

• Protect Workbook

• Encrypt with Password

• Document Inspector

• Restrict Access

In tutorial 27, what is introduced these that are used to drill down in data analysis to help summarize and manipulate visualizations to suit your needs?

• Analyze>Refresh

• Field List

• Summarize Reports

• PivotTables