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 31

Multiple Choice

Review LaterAdd Note

Review Later

Case-Based Critical Thinking Questions 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 an example of a valid defined name Juan can provide to you?

A) .FY2010
B) F-Y2010
C) FY2010
D) FiscalYear2010

E) B) and D)
F) B) and C)

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

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. While just getting his feet wet with Excel, you suggest to Ted that he might want to begin without having his installation of Excel have any macros run at all. Which of the following options would he select in the Trust Center?

A) Disable all macros without notification
B) Cancel all macros
C) Disable a macro with notification
D) Disable all macros except digitally signed macros

E) None of the above
F) B) and D)

Correct Answer

verified

Show Answer

Question 33

Short Answer

Review LaterAdd Note

In the Allow list box in the Data Validation dialog box, the ____________________ option means that the cell will accept any value entered into the cell.

In VBA, macros are called _____ procedures.

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

One way to run a macro is to assign it to a(n)button that is placed directly on the worksheet. _________________________

Every cell in a workbook has a(n) _____ property that determines whether or not changes can be made to that 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. After a year of work, Ted 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?

The following are Excel-supported error alert types: _____.

Which of the following is NOT a valid defined name?

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

Defined names are automatically substituted for existing range references in a formula.

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.

The ____________________ alert, by default, rejects the invalid data, but allows you to override the rejection.

Input messages appear as ____________________ next to the active cell.

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

In the Allow list box in the Data Validation dialog box, the _____ option means that the cell will accept only times.

Range names must begin with _____.

To remove workbook protection, click the Unprotect Workbook button in the _____ group on the Review tab.

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