FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 7: Excel 3: Developing an Excel Application

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

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

A) analog
B) signature
C) digital
D) secure

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

To view the code of a macro, you need to open the Visual Basic _____.

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

_____ messages appear as ScreenTips next to the active cell.

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

The _____ dialog box displays all of the names in the workbook.

The Visual Basic Editor is a separate application that works with Excel and all of the Office products to edit and manage VBA code. _________________________

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.

One way to ensure that correct data is entered into a cell or range is to use the Excel data ____________________ feature.

Which of the following tabs in the Data Validation dialog box allows you to set validation criteria?

Each macro must have a unique name that begins with a letter.

You use the _____ tab in the Data Validation dialog box to enter the validation rules for the active cell.

Range names can be up to _____ characters.

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

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

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

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

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?

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