Exam 7: Excell: Developing an Excel Application

A macro ____________________ uses a program's own macro programming language for distribution.

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

A(n) ____________________ is a spreadsheet written or tailored to meet the user's specific needs.

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

To save a workbook with macros, the default Excel Workbook format needs to change to a macro-enabled workbook, which has the _____ file extension.

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

Any blanks or parentheses in a row or column label will be changed to _____ in defined names.

Sometimes when you build a worksheet for other users, you may decide to add a(n) _____ message to a cell even if you do not validate the data in that cell.

You can use the Name Manager dialog box, shown in the accompanying figure, to create a defined name.

Validation rules come into play only during data entry.

Cell and range references do not indicate what data is stored in those cells.

Running a macro means Excel performs a portion of the steps that were recorded.

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.

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

Case-Based Critical Thinking Questions Case 7-2 Rina 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 can Rina tell when she opens a digitally signed file?

The Stop alert prevents an entry from being stored in the cell.

Case-Based Critical Thinking Questions Case 7-1 Ted 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. As Ted does more even work in Excel, he has begun to develop a collection of publishers whom he trusts to deliver macros that are problem-free. What should his option be in the Trust Center?

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

If content is blocked, the _____ located under the Ribbon appears, notifying you that some content was disabled.

In the accompanying figure, clicking the New button opens the New _____ dialog box.