Question: When you set up worksheet protection, you specify which actions users are allowed to perform in the protected sheet. True False What must you add
When you set up worksheet protection, you specify which actions users are allowed to perform in the protected sheet.
True
False
What must you add to the Excel ribbon before you can insert a form control or create a macro?
| a. | Macro tab | |
| b. | Form tab | |
| c. | Power User tab | |
| d. | Developer tab |
How can you edit a macro to change its actions?
| a. | Open the macro in the VBA Editor. | |
| b. | Step into the macro. | |
| c. | Convert the macro to a function. | |
| d. | Run the macro. |
Samira has a workbook containing many worksheets with interconnected formulas. What can she use to display the values of specified cells located throughout the workbook?
| a. | Automatic Update Window | |
| b. | Observe Formula dialog box | |
| c. | Show Formulas command | |
| d. | Watch Window |
You use the Evaluate Formula dialog box to enter a formula that uses a financial function.
True
False
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
