FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 7: Developing an Excel Application

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

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

A)  Mini toolbar
B)  Quick Launch toolbar 
C)  Message Bar
D)  Status Bar

Correct Answer

verified

Show Answer

Question 22

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

Range names can be up to _____ characters.

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

A digital _____ is like a seal of approval.

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? 

Range names must begin with _____.

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

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

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 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? 

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

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

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

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

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

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

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

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

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?