Automating Workbook Functionality

Question 1

What is the purpose of the Error Alert feature?

Revolt · Accepted Answer

to alert the user to data entry mistakes

Question 2

Record MacrosUse Relative ReferencesEdit Macros✔ View Macros

Revolt · Accepted Answer

✔ View Macros

Question 3

RunCreateStep Into✔ Edit

Revolt · Accepted Answer

✔ Edit

Question 4

What are the steps to adding a note in the Data Validation dialog box? Go to the tab on the ribbon. In the Data Tools group, you will select , and the dialog box will open. To add a note for anyone viewing or editing the table, select in the box. Complete the instructions and click OK.

Revolt · Accepted Answer

Data; Selection 1: Data; Selection 2: Data Validation; Selection 3: Insert Message

Question 5

Text to Columns✔ Data ValidationConsolidateFlash Fill

Revolt · Accepted Answer

Data Validation

Question 6

Settings✔ Insert MessageError AlertClear All

Revolt · Accepted Answer

Insert Message

Question 7

Which mark is an indicator of invalid data in a cell?

Revolt · Accepted Answer

red circle around the value

Question 8

How can you tell that your worksheet is in Macro Recording mode?

Revolt · Accepted Answer

A gray box is next to the word Ready in the bottom left corner.

Question 9

What steps will change an existing macro? Use the drop-down menu to complete the steps. Go to the tab on the ribbon. In the Macros group, click . Click , which will open the VBA editor. Find and change the code and Save and Close.

Revolt · Accepted Answer

✔ View; Selection 1: View; Selection 2: View Macros; Selection 3: Edit

Question 10

Which extension means it is a macro-enabled workbook?

Revolt · Accepted Answer

.xlsm

Automating Workbook Functionality Answers

More from this Course

TRY EDGENUITY HACKS