Deck 8: Developing an Excel Application

Question 1

Defined names are automatically substituted for the cell addresses in a formula.

Answer 1

False

Question 2

You drag the comment's border to resize a comment box like the one shown in the accompanying figure.

Answer 2

False

Question 3

Even if a sheet is protected,you can limit the user to selecting only unlocked cells,or allow the user to select any cell in the worksheet.

Answer 3

True

Question 4

When you open a file with macros,the response you see is based on the security level set on the computer.

Question 5

Data validation can verify data that was entered into a worksheet before the validation criteria were applied.

Question 6

You can keep users from deleting worksheets or inserting new ones.

Question 7

Each macro must have a unique name.

Question 8

The red triangle (that has an arrow pointing to it)in the accompanying figure indicates that a given cell does not have a comment.

Question 9

The frequency of error alert determines what choices the user is presented with when an invalid entry is attempted.

Question 10

You can allow users to insert new rows or columns into a sheet,even if the sheet is protected.

Question 11

Each cell can have at most three validation rules.

Question 12

To move the box,you would drag the selection handle of the comment in the accompanying figure.

Question 13

Once you protect a worksheet,the locked property is enabled and controls whether or not a cell can be edited.

Question 14

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

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

By default,a macro will select the same cells regardless of which cell is first selected because the macro records a selection using relative cell references.

Question 17

Clicking the Edit button in the accompanying figure opens the New Name dialog box in which you can modify the selected defined name.

Question 18

You cannot prevent users from changing all of the formulas in a worksheet.

Question 19

You can use the Name Manager dialog box,shown above,to create a defined name.

Question 20

When the Ribbon is minimized,only the Quick Access Toolbar and the tab names are displayed.

Question 21

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

Question 22

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

Question 23

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.Stop
g.defined name
b.Warning
h.input message
c.Information
i.validation rule
d.locked
j.digital certificate
e.macro
k.digital signature
f.Excel application
l.VBA
Appears when the cell becomes active and can be used to specify the type of data the user should enter in that cell

Question 24

You can delete or edit a macro by opening the Edit dialog box,selecting the macro from the list,and then clicking the appropriate button._________________________

Question 25

The default is to protect only the appearance of a workbook._________________________

Question 26

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

Question 27

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.Stop
g.defined name
b.Warning
h.input message
c.Information
i.validation rule
d.locked
j.digital certificate
e.macro
k.digital signature
f.Excel application
l.VBA
Series of stored commands

Question 28

If you select the Custom option in the Allow list box in the Data Validation dialog box,the validation rule will be based on an Excel logistical formula._________________________

Question 29

By default,the locked property is turned off for each cell when you protect a workbook._________________________

Question 30

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

Question 31

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

Question 32

A range name is more descriptive than a(n)cell reference._________________________

Question 33

You use the Rules tab in the Data Validation dialog box to enter the validation rules for an active cell._________________________

Question 34

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.Stop
g.defined name
b.Warning
h.input message
c.Information
i.validation rule
d.locked
j.digital certificate
e.macro
k.digital signature
f.Excel application
l.VBA
Spreadsheet written or tailored to meet the user's specific needs

Question 35

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

Question 36

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.Stop
g.defined name
b.Warning
h.input message
c.Information
i.validation rule
d.locked
j.digital certificate
e.macro
k.digital signature
f.Excel application
l.VBA
Needed before you can add a digital signature to a workbook

Question 37

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

Question 38

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

Question 39

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

Question 40

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.Stop
g.defined name
b.Warning
h.input message
c.Information
i.validation rule
d.locked
j.digital certificate
e.macro
k.digital signature
f.Excel application
l.VBA
Error alert that rejects invalid data but allows you to override the rejection

Question 41

Using defined names like the kind shown in the accompanying figure makes creating and understanding a(n)____ easier.

A) index
B) log
C) formula
D) all of the above

Question 42

The current data in the ParkingFee cell,according to the accompanying figure,is ____.

A) 25
B) 8
C) 2
D) 15

Question 43

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.Stop
g.defined name
b.Warning
h.input message
c.Information
i.validation rule
d.locked
j.digital certificate
e.macro
k.digital signature
f.Excel application
l.VBA
Confirms that a macro or document has not been altered

Question 44

If your data is organized in a tabular format,you can quickly create range names for each column or row in the list by using the ____ dialog box.

A) Make from Table
B) Name
C) Create from Selection
D) Assign

Question 45

Range names can be up to ____ characters.

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

Question 46

In the figure above,the column labeled "Refers to" is the name's ____.

A) link location
B) location in the worksheet
C) target location in the worksheet
D) none of the above

Question 47

Range names must begin with ____.

A) a letter
B) the underscore character
C) a number
D) either a.or b.

Question 48

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.Stop
g.defined name
b.Warning
h.input message
c.Information
i.validation rule
d.locked
j.digital certificate
e.macro
k.digital signature
f.Excel application
l.VBA
Error alert that accepts the invalid data but still allows you to cancel the data entry

Question 49

The ____ box displays all of the names in the workbook.

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

Question 50

The most direct way to create defined names like the kind shown in the accompanying figure is to use the ____ box on the formula bar.

A) Definition
B) Name
C) Term
D) Label

Question 51

In the City_State_Zip field name shown in the accompanying figure,the underscores replace ____ in the label name.

A) spaces
B) periods
C) commas
D) numbers

Question 52

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.Stop
g.defined name
b.Warning
h.input message
c.Information
i.validation rule
d.locked
j.digital certificate
e.macro
k.digital signature
f.Excel application
l.VBA
Error alert that prevents you from storing the data in the cell

Question 53

In the figure above,clicking the New button,opens the New Name dialog box.

A) Name
B) Macro
C) Label
D) Range

Question 54

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.Stop
g.defined name
b.Warning
h.input message
c.Information
i.validation rule
d.locked
j.digital certificate
e.macro
k.digital signature
f.Excel application
l.VBA
Word or string of characters associated with a single cell or a range

Question 55

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.Stop
g.defined name
b.Warning
h.input message
c.Information
i.validation rule
d.locked
j.digital certificate
e.macro
k.digital signature
f.Excel application
l.VBA
Property that determines whether or not changes can be made to a cell

Question 56

The following is a valid function name: ____.

A) FY2010
B) Print_Area
C) Net-Income
D) none of the above

Question 57

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.Stop
g.defined name
b.Warning
h.input message
c.Information
i.validation rule
d.locked
j.digital certificate
e.macro
k.digital signature
f.Excel application
l.VBA
Defines the criteria for storing data in a cell or range

Question 58

Applications typically include an interface to assist the user in using the system,ranging from special buttons that assist in existing specific tasks to changing the entire Excel interface with customized ____.

A) commands
B) menus
C) toolbars
D) all of the above

Question 59

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.Stop
g.defined name
b.Warning
h.input message
c.Information
i.validation rule
d.locked
j.digital certificate
e.macro
k.digital signature
f.Excel application
l.VBA
Programming language that allows you to create macros

Question 60

After the first character in a range name,the following is acceptable: ____.

A) hyphen
B) space
C) periods
D) either a.or b.

Question 61

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 62

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 63

You use the ____ tab in the Data Validation dialog box to enter the validation rules for the active cell.

A) Active Cell
B) Rules
C) Settings
D) Input Message

Question 64

In the Allow list box in the Data Validation dialog box,the ____ option means that the cell will accept only values from a list.

A) List
B) Index
C) Roster
D) Catalog

Question 65

In the Allow list box in the Data Validation dialog box,the ____ option means that the validation rule will be based on an Excel logical formula.

A) Rule
B) Logical
C) Custom
D) Validation

Question 66

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 67

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 68

Which of the following is a tab in the Data Validation dialog box?

A) Settings
B) Input Message
C) Error Alert
D) All of the above

Question 69

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

A) Calendar
B) Schedule
C) Date
D) Timeline

Question 70

Using the Excel data validation feature,you can specify a(n)____ of acceptable values.

A) roster
B) series
C) array
D) range

Question 71

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 72

____ messages appear as ScreenTips next to the active cell.

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

Question 73

One way of reducing the chance of data-entry error is to display a(n)____ message when a user clicks on the cell.

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

Question 74

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 75

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 76

A(n)____ message provides additional information about the type of data allowed for the cell.

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

Question 77

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

A) Data Validation
B) Data Entry
C) Data
D) Validation

Question 78

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 79

Sometimes when you build a worksheet for other users,you may decide to add a(n)____ message to a cell even if you don't validate the data in that cell.

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

Question 80

In the Allow list box in the Data Validation dialog box,the ____ option means that the cell will accept any type of numeric value.

A) Whole Number
B) Any Number
C) Decimal
D) Integer