Deck 7: Excel 3: Developing an Excel Application

Question 1

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

Answer 1

True

Question 2

Running a macro means Excel performs a portion of the steps that were recorded.

Answer 2

False

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

Question 6

For cell and range names, names of 5 to 15 characters are considered practical, although names can be up to 255 characters.

Question 7

Any blanks or parentheses in row or column labels are changed to underscore characters in defined names. _________________________

Question 8

Range names must begin with _____.

A)a letter or an underscore
B)a number
C)a hash tag
D)an asterisk

Question 9

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

Question 10

The Name dialog box lists all of the names currently defined in the workbook, including Excel table names. _________________________

Question 11

Validation rules come into play only during data entry.

Question 12

The Stop alert prevents an entry from being stored in the cell.

Question 13

Range names can be up to _____ characters.

A)15
B)27
C)56
D)255

Question 14

Which of the following is NOT a valid defined name?

A)netincome
B)Net_Income
C)Net-Income
D)NetIncome

Question 15

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

Question 16

Each macro must have a unique name that begins with a letter.

Question 17

Every cell in a workbook has a(n)locked property that determines whether or not changes can be made to that cell. _________________________

Question 18

When Excel creates a macro button, the Assign Macro dialog box opens with the button's default name showing. _________________________

Question 19

A digital certificate confirms that the macro created by the signer has not been altered since the digital certificate was created. _________________________

Question 20

The _____ dialog box displays all of the names in the workbook.

A)Name Manager
B)Ranges
C)Definition
D)Terms

Question 21

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.

A)value
B)input
C)key
D)user

Question 22

Usually, you will want to protect a worksheet but leave some cells _____.

A)open
B)empty
C)clear
D)unlocked

Question 23

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

Question 24

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

A)Format
B)Changes
C)Sheet
D)Options

Question 25

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

Question 26

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

Question 27

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

Question 28

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

A)error-checking
B)rule-based
C)validation
D)contingent

Question 29

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

Question 30

Protecting the _____ prohibits users from renaming, deleting, hiding, or inserting worksheets.

A)skeleton
B)structure
C)format
D)location

Question 31

_____ messages appear as ScreenTips next to the active cell.

A)Value
B)Input
C)Key
D)User

Question 32

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

Question 33

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

Question 34

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

Question 35

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

Question 36

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

A)Secure
B)Security
C)Trust
D)Protection

Question 37

When you _____ a workbook, you control the ability users have to make changes to the file.

A)ensure
B)protect
C)secure
D)seal

Question 38

The _____ alert accepts the invalid data but still allows you to cancel the data entry.

A)Information
B)Stop
C)Security
D)Warning

Question 39

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

Question 40

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

Question 41

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

Question 42

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

Question 43

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

Question 44

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

Question 45

In VBA, macros are called _____ procedures.

A)body
B)sub
C)commented
D)modular

Question 46

After the comments, in VBA code the next item is the _____ of the macro.

A)module
B)body
C)procedure
D)command

Question 47

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

Question 48

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

Question 49

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. 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
D)Whether the macro will perform as expected

Question 50

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

Question 51

A digital _____ is like a seal of approval.

A)affidavit
B)clause
C)signature
D)salutation

Question 52

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

Question 53

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

A)Manager
B)Code Window
C)Reader
D)Editor

Question 54

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

Question 55

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?

A)Enable all trusted macros
B)Enable all macros
C)Disable all macros except digitally signed macros
D)Disable a macro with notification

Question 56

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

Question 57

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

Question 58

A(n)_____ certificate is another name for a digital ID.

A)analog
B)signature
C)digital
D)secure

Question 59

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

Question 60

To create a macro, you can enter a series of commands in the _____ programming language.

A)HTML
B)Java
C)VBA
D)Perl

Question 61

Input messages appear as ____________________ next to the active cell.

Question 62

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.

Question 63

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

Question 64

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

Question 65

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

Question 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.

Question 67

When you ____________________ a workbook, you control the ability users have to make changes to the file.

Question 68

A(n)____________________ is a text box that is attached to a specific cell in a worksheet.

Question 69

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

Question 70

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

Question 71

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 a true statement Juan can make about defined names as he is explaining the rules to you?

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

Question 72

A(n)____________________ is a series of stored commands that can be run whenever you need to perform a task.

Question 73

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

Question 74

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

Question 75

A digital ____________________ is often used to identify the author of a workbook that contains macros.