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?

Revolt · Accepted Answer

✔ Data; Go to the tab on the ribbon.: Data; In the Data Tools group, you will select , and the dialog box will open.: Data Validation; To add a note for anyone viewing or editing the table, select in the box.: 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

Automating Workbook Functionality Answers

More from this Course

TRY EDGENUITY HACKS