Exam 8: Developing an Excel Application

In the Allow list box in the Data Validation dialog box,the ____ option means that the validation rule will be based on an Excel logical formula.

A digital ____ is like a seal of approval.

Case-Based Critical Thinking Questions Case 8-3 Javier tells you that your work in Excel will go a lot faster if you start using defined names instead of cell and range addresses.You believe him but you have been frustrated by defined names in the past because you did not know the rules for naming them and you have run into errors as a result.Javier offers to help you. -Which of the following is a valid defined name Javier can provide to you?

Data validation can verify data that was entered into a worksheet before the validation criteria were applied.

Sub procedures are organized into ____.

One way of reducing the chance of data-entry error is to display a(n)____ message when a user clicks on the cell.

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. -What is the best phrase to describe a digital signature?

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

In the Allow list box in the Data Validation dialog box,the ____ option means that the cell will accept only text of a specified number of characters.

You can allow users to insert new rows or columns into a sheet,even if the sheet is protected.

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. -Now it's a year later and Joe is taking coursework to become a VBA programmer.He is working on developing an application that contains macros.Which should his option be in the Trust Center?

For simple macros,it is easier to create a macro using the macro ____.

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

The least severe error alert is the ____ alert.

By default,a macro will select the same cells regardless of which cell is first selected because the macro records a selection using relative cell references.

The ____ Macro workbook is a hidden workbook opened whenever you start Excel,making its macros available anytime you use Excel.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Series of stored commands

The Excel data ____ feature restricts data entry to follow a defined set of rules.

Protecting the ____ prohibits users from moving,resizing,closing,or hiding parts of the Excel window.

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