Finalizing a Workbook

Question 1

Inspect a workbook for hidden properties and personal info

Answer 1

file tab/ info section/ inspect workbook/ inspect document/document inspector

Question 2

Inspect a Workbook for Accessibility Issues

Answer 2

file tab/ info sec/ inspect workbook/ check accessibility/

Question 3

Inspect a Workbook for Compatibility Issues

Answer 3

older verisons that may not be compatitble with the latest windows verison.
file tab/ inspect workbook/ check compatitability/compatitability window

Question 4

Restrict Editing and Protect a Workbook

Answer 4

review tab/ protect group/ protect sheet button/ enter password/ check desired boxes

restrict sections:* hightlight desired range/ home tab/ alignment down arrow/ format cells window, protection tab/ check desired boxes*

Note: it only applies to the sheet you’ve requested.

Question 5

Protect Workbook Structure

Answer 5

**review tab/ protect group/ protect workbook icon/ add password **
or
**file tab/protect workbook button **

Question 6

Encrypt a Workbook With A Passwordfil

Answer 6

**file tab/ protect workbook/ encrypt w. password/ Encrypt document windwo/ enter password/ save **

Question 7

Manage Workbook Versions

Answer 7

file tab/ manage workbook button

Note: you can also check other unsaved files

	Settings:  ***Options tab/ options window, save/***

Question 8

Retrieve Previous Versions Excel 365

Answer 8

file tab/ info button/ verison history/ verison history panel

Note: restore will bring back the older (be careful). Can save the older verison in separate file.

Question 9

Macro

Answer 9

is a recorded sequence of actions or commands that you can run to automate repetitive tasks, effectively saving time and effort.
Create Developer Tab: ** file tab/ Options button/ Excel options window/ customize ribbons/ clk developer/under Main tabs, clk Developer/clk ok **

Set Macro: **Developer tab/ code group/ clk relative references for different variations/ clk record macro/start editing, formulas etc. /clk stop recodring. **

Create a Macro: Select area/clk Marco button

Question 10

Macro

Create Developer Tab

Answer 10

** file tab/ Options button/ Excel options window/ customize ribbons/ clk developer/under Main tabs, clk Developer/clk ok **

Question 11

Set Macro formula

Answer 11

**Developer tab/ code group/ clk relative references for different variations/ clk record macro/start editing, formulas etc. /clk stop recodring. **

Note: 365 has autosave where save as under different file format .xslm.

Question 12

Create Macro

Answer 12

Select area/clk Marco button

Question 13

Modify a Simple Macro

Answer 13

developer tab / Macros button/ macro window, Edit button/ check Macro list to edit/ close****

Question 14

Save and Enable Macros in a Workbook

Answer 14

save as/ clk no/ file/file name/save

Question 15

Copy Macros Between Workbooks

Answer 15

Have both workbooks open/ developer/ visual basic button/ visual basic editor/ in editor drag file into the other workbook in list/save

Question 16

macros

form control

Answer 16

are interactive elements (like buttons, checkboxes, and dropdown lists) that you can add to a worksheet to create user-friendly interfaces for data entry and manipulation.

Answer 17

developer tab/