Exam 8: Developing an Excel Application

Case-Based Critical Thinking Questions Case 8-2 Renee has just completed some coursework in Excel application writing and wants to begin developing her own macros to share more widely.She knows that she has to learn more about digital signatures in order to make her plan a reality. -Which of the following is a true statement about digital signatures?

The ____________________ alert by default rejects the invalid data,but allows you to override the rejection.

Even if a sheet is protected,you can limit the user to selecting only unlocked cells,or allow the user to select any cell in the worksheet.

When the Ribbon is minimized,only the Quick Access Toolbar and the tab names are displayed.

You can turn off the macro recorder by clicking the Stop Recording button in the Code group on the ____ tab.

An input message appears when the cell becomes active,and can be used to specify the ____ of data the user should enter in that cell.

What are the steps for creating a validation rule?

To keep a comment like the one in the accompanying figure on the screen,in the Comments group on the ____ tab,click the Show/Hide Comment button.

Even when the worksheet is unprotected,the locked property determines whether or not changes can be made to a given cell.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Confirms that a macro or document has not been altered

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Error alert that prevents you from storing the data in the cell

-The most direct way to create defined names like the kind shown in the accompanying figure is to use the ____ box on the formula bar.

Each macro must have a unique name.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Programming language that allows you to create macros

A(n)____________________ is a series of stored commands that can be run whenever you need to perform a task.

Any blanks or parentheses in row or column labels are changed to underscore characters in defined names._________________________

You can delete or edit a macro by opening the Edit dialog box,selecting the macro from the list,and then clicking the appropriate button._________________________

To open the Data Validation dialog box,click the Data tab on the Ribbon,and then click Authentication in the Data Tools group._________________________

When you ____ a workbook,you control the ability users have to make changes to the file.

In the Allow list box in the Data Validation dialog box,the ____________________ option means that the cell will accept only times.