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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!