Exam 7: Developing an Excel Application

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

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

Range names can be up to _____ characters.

Range names must begin with _____.

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

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? 

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

Each sub procedure in VBA begins with the keyword "Sub" followed by the name of the sub procedure and a set of _____.

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

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

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 gets more comfortable with Excel,he thinks that he might be able to decide whether or not to run a macro on a case-by-case basis.What should his option be in the Trust Center? 

Case 7-3 Juan 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.Juan offers to help you. -Which of the following is a true statement Juan can make about defined names as he is explaining the rules to you? 

A _____ can be destructive and can modify or delete files that may not be recoverable.

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

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

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

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

A digital _____ is like a seal of approval.

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

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