Name:
Class:
Date:
Excel Module 07: Developing an Excel Application
1. For cell and range names, names of 5 to 15 characters are considered practical, although names can be up to 255
characters.
a. True
b. False
2. Defined names are automatically substituted for existing range references in a formula.
a. True
b. False
3. The Stop alert prevents an entry from being stored in the cell.
a. True
b. False
4. Even when the worksheet is unprotected, the locked property determines whether or not changes can be made to a
given cell.
a. True
b. False
5. Validation rules come into play only during data entry.
a. True
b. False
6. Each macro must have a unique name that begins with a letter.
a. True
b. False
7. Running a macro means Excel performs a portion of the steps that were recorded.
a. True
b. False
Name:
Class:
Date:
Excel Module 07: Developing an Excel Application
8. Cell and range references do not indicate what data is stored in those cells. _________________________
9. Any blanks or parentheses in row or column labels are changed to underscore characters in defined names.
_________________________
10. The Name dialog box lists all of the names currently defined in the workbook, including Excel table names.
_________________________
11. To open the Data Validation dialog box, click the Data tab on the Ribbon, and then click Authentication in the Data
Tools group. _________________________
12. Every cell in a workbook has a(n) locked property that determines whether or not changes can be made to that cell.
_________________________
13. A digital certificate confirms that the macro created by the signer has not been altered since the digital certificate was
created. _________________________
14. The Visual Basic Editor is a separate application that works with Excel and all of the Office products to edit and
manage VBA code. _________________________
Name:
Class:
Date:
Excel Module 07: Developing an Excel Application
15. One way to run a macro is to assign it to a(n) button that is placed directly on the worksheet.
_________________________
16. When Excel creates a macro button, the Assign Macro dialog box opens with the button’s default name showing.
_________________________
17. Which of the following is NOT a valid defined name?
a. netincome b. Net_Income
c. Net-Income d. NetIncome
18. Range names must begin with _____.
a. a letter or an underscore b. a number
c. a hash tag d. an asterisk
19. Range names can be up to _____ characters.
a. 15 b. 27
c. 56 d. 255
20. The _____ dialog box displays all of the names in the workbook.
a. Name Manager b. Ranges
c. Definition d. Terms
21. Any blanks or parentheses in a row or column label will be changed to _____ in defined names.
a. ampersands b. underscore characters
c. hyphens d. dashes
Name:
Class:
Date:
Excel Module 07: Developing an Excel Application
22. The Excel data _____ feature restricts data entry to follow a defined set of rules.
a. error-checking b. rule-based
c. validation d. contingent
23. 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.
a. aspect b. type
c. format d. cast
24. One way to ensure that correct data is entered into a cell or range is to use the Excel data _____ feature.
a. validation b. concatenation
c. security d. index
25. In the Allow list box in the Data Validation dialog box, the _____ option means that the cell will accept only integers.
a. Integer b. Decimal
c. Numerical d. Whole Number
26. 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.
a. Custom b. Text Length
c. Any Value d. Specified Text
27. In the Allow list box in the Data Validation dialog box, the _____ option means that the cell will accept only times.
a. Chronology b. Clock
c. Time d. Calendar
28. 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.
Name:
Class:
Date:
Excel Module 07: Developing an Excel Application
a. value b. input
c. key d. user
29. Which of the following tabs in the Data Validation dialog box allows you to set validation criteria?
a. Criteria b. Input Message
c. Error Alert d. Settings
30. You use the _____ tab in the Data Validation dialog box to enter the validation rules for the active cell.
a. Active Cell b. Criteria
c. Settings d. Input Message
31. _____ messages appear as ScreenTips next to the active cell.
a. Value b. Input
c. Key d. User
32. The following are Excel-supported error alert types: _____.
a. Stop, Warning, and Alert b. Alert, Warning, and Information
c. Security, Warning, and Alert d. Stop, Warning, and Information
33. The _____ alert accepts the invalid data but still allows you to cancel the data entry.
a. Information b. Stop
c. Security d. Warning
34. When you _____ a workbook, you control the ability users have to make changes to the file.
a. ensure b. protect
c. secure d. seal
Name:
Class:
Date:
Excel Module 07: Developing an Excel Application
35. Every cell in a workbook has a(n) _____ property that determines whether or not changes can be made to that cell.
a. ensured b. locked
c. security d. changeable
36. Usually, you will want to protect a worksheet but leave some cells _____.
a. open b. empty
c. clear d. unlocked
37. Protecting the _____ prohibits users from renaming, deleting, hiding, or inserting worksheets.
a. skeleton b. structure
c. format d. location
38. To remove workbook protection, click the Unprotect Workbook button in the _____ group on the Review tab.
a. Format b. Changes
c. Sheet d. Options
39. A _____ can be destructive and can modify or delete files that may not be recoverable.
a. digital signature b. macro virus
c. comment virus d. micro virus
40. The _____ Center is a central location for all the security settings in Office.
a. Secure b. Security
c. Trust d. Protection
41. 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
Name:
Class:
Date:
Excel Module 07: Developing an Excel Application
42. A(n) _____ certificate is another name for a digital ID.
a. analog b. signature
c. digital d. secure
43. A digital _____ is like a seal of approval.
a. affidavit b. clause
c. signature d. salutation
44. To create a macro, you can enter a series of commands in the _____ programming language.
a. HTML b. Java
c. VBA d. Perl
45. The _____ Macro workbook is a hidden workbook opened whenever you start Excel, making its macros available
anytime you use Excel.
a. Universal b. Personal
c. Microsoft d. XP
46. You can turn off the macro recorder by clicking the Stop Recording button in the Code group on the _____ tab.
a. Insert b. Developer
c. Layout d. Macro
47. If a _____ error appears when you run a macro that has worked in the past, some part of the macro code no longer
makes sense to Excel.
a. syntax b. run-time
c. logic d. baseline
Name:
Class:
Date:
Excel Module 07: Developing an Excel Application
48. To view the code of a macro, you need to open the Visual Basic _____.
a. Manager b. Code Window
c. Reader d. Editor
49. In VBA, macros are called _____ procedures.
a. body b. sub
c. commented d. modular
50. Each sub procedure in VBA begins with the keyword “Sub” followed by the name of the sub procedure and a set of
_____.
a. brackets b. braces
c. parentheses d. asterisks
51. After the comments, in VBA code the next item is the _____ of the macro.
a. module b. body
c. procedure d. command
52. To save a workbook with macros, the default Excel Workbook format needs to change to a macro-enabled workbook,
which has the _____ file extension.
a. xlsm b. xlst
c. xlsx d. xls
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.
53. 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?
Name:
Class:
Date:
Excel Module 07: Developing an Excel Application
a. Disable all macros without notification
b. Cancel all macros
c. Disable a macro with notification
d. Disable all macros except digitally signed macros
54. 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?
a. Disable all macros without notification
b. Cancel all macros
c. Disable all macros with notification
d. Disable all macros except digitally signed macros
55. 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. Enable all trusted macros
b. Enable all macros
c. Disable all macros except digitally signed macros
d. Disable a macro with notification
56. 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?
a. Enable all trusted macros
b. Enable all macros
c. Disable all macros except digitally signed macros
Case-Based Critical Thinking Questions
Case 7-2
Rina 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.
Name:
Class:
Date:
Excel Module 07: Developing an Excel Application
57. What phrase could Rina use to best describe a digital signature?
a. a merit badge b. an indication of value
c. an invitation to collaborate d. a seal of approval
58. Based on what she has learned, which of the following would Rina say is a true statement about digital signatures?
a. Adding a digital signature is the first step before you distribute a file.
b. A digital signature is often used to identify the author of a workbook that contains macros.
c. Before you can add a digital ID to a workbook, you need to obtain a digital signature.
d. Digital certificates are usually issued by Microsoft.
59. By digitally signing a workbook that contains a macro that she intends to publicly distribute, Rina assures her
audience _____.
a. of the identity of the user of the macro
b. that the macro has not been altered since the digital signature was created
c. that the macro will perform as expected
d. that no data entry errors will stop the macro from running
60. Which of the following can Rina tell when she opens a digitally signed file?
a. Who the author of the file is
b. Whether the information in the file is correct
c. Whether the macros in the workbook will produce accurate results
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.
61. Which of the following is a true statement Juan can make about defined names as he is explaining the rules to you?
Name:
Class:
Date:
Excel Module 07: Developing an Excel Application
a. The name can include letters, numbers, periods, and underscores
b. To distinguish multiword names, use a hyphen between the words
c. Defined names are case sensitive
d. The name should start with a hash tag
62. 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
63. A(n) ____________________ is a spreadsheet written or tailored to meet the user’s specific needs.
64. In addition to referring to cells by their cell references, it is easier to remember where different data is stored by
assigning a meaningful, descriptive ____________________ to each cell or range.
65. One way to ensure that correct data is entered into a cell or range is to use the Excel data ____________________
feature.
66. 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.
67. Input messages appear as ____________________ next to the active cell.
68. The ____________________ alert, by default, rejects the invalid data, but allows you to override the rejection.
Name:
Class:
Date:
Excel Module 07: Developing an Excel Application
69. When you ____________________ a workbook, you control the ability users have to make changes to the file.
70. A protected sheet can always be unprotected, but you can also require users to enter a(n) ____________________
before the protection is removed.
71. Protecting the ____________________ of a workbook prohibits users from moving, resizing, closing, or hiding parts
of the Excel window.
72. A(n) ____________________ is a text box that is attached to a specific cell in a worksheet.
73. A(n) ____________________ is a series of stored commands that can be run whenever you need to perform a task.
74. A macro ____________________ uses a program’s own macro programming language for distribution.
75. A digital ____________________ is often used to identify the author of a workbook that contains macros.