Exam 8: Developing an Excel Application

A(n)____________________ is a text box that is attached to a specific cell in a worksheet.

When Excel creates a macro button,the Assign Macro dialog box opens with the button's default name showing._________________________

A(n)____ certificate is another name for a digital ID.

When a workbook is protected such that options to modify the worksheet are no longer available,what do the corresponding commands on the shortcut menu look like?

The frequency of error alert determines what choices the user is presented with when an invalid entry is attempted.

The following are Excel-supported error alert types: ____.

The ____ alert accepts the invalid data but still allows you to cancel the data entry.

In addition to referring to cells by their cell references,it is easier to remember where different data is stored by assigning a descriptive ____________________,to each cell or range.

The ____ Center is a central location for all the security settings in Office 2007.

Usually,you will want to protect a worksheet but leave some cells ____.

A digital ____________________ is often used to identify the author of a workbook that contains macros.

Excel supports ____ types of error alerts.

A protected sheet can always be unprotected,but you can also require users to enter a(n)____________________ before the protection is removed.

Case-Based Critical Thinking Questions Case 8-1 Joe knows that macros can be helpful to him in his work with Excel spreadsheets,but he also knows they have their hazards,so he comes to you for guidance about what kind of security settings he should put in place,and at what times. -While he just getting his feet wet with Excel,you suggest to Joe that he might want to begin without having his installation of Excel have any macros run at all.Which of the following options would he select in the Trust Center?

In the Allow list box in the Data Validation dialog box,the ____________________ option means that the cell will accept any value entered into the cell.

For cell and range names,names of 25 to 50 characters are considered practical,although names can be up to 255 characters.

To remove workbook protection,click the Unprotect Workbook button in the ____ group on the Review tab.

The ____ Reference button controls how Excel records the act of selecting a range in the worksheet.

When you find an error in a macro,all of the following are options EXCEPT ____.

A range name is more descriptive than a(n)cell reference._________________________