Question 1

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

Accepted Answer

Defined names in formulas make it easier to understand and work with the formula, but they do not directly relate to an index or log.

Question 2

The current data in the ParkingFee cell,according to the accompanying figure,is ____.
A) 25
B) 8
C) 2
D) 15

Accepted Answer

The ParkingFee cell is located in row 3, column 4, which intersects with the $15 cell. Therefore, the current data in the ParkingFee cell is 15.

Question 3

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Confirms that a macro or document has not been altered
A)Stop
B)Warning
C)Information
D)locked
E)macro
F)Excel application
G)defined name
H)input message
I)validation rule
J)digital certificate
K)digital signature
L)VBA

Accepted Answer

A digital signature is used to confirm that a macro or document has not been altered, ensuring its authenticity and integrity.

Question 4

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

Accepted Answer

The "Create from Selection" dialog box allows you to quickly create range names for each column or row in a table by selecting the table, going to the "Formulas" tab, and clicking "Create from Selection." This option automatically names each column or row based on the header or leftmost column in the table.

Question 5

Range names can be up to ____ characters.
A) 15
B) 27
C) 56
D) 255

Accepted Answer

Range names can be up to 255 characters in length, which allows for very descriptive and specific naming conventions. This also helps to avoid naming conflicts and confusion when working with larger datasets.

Question 6

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

Accepted Answer

The answer of In the figure above,the column labeled "Refers...

Question 7

Range names must begin with ____.
A) a letter
B) the underscore character
C) a number
D) either a.or b.

Accepted Answer

The answer of Range names must begin with ____.
A) a...

Question 8

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Error alert that accepts the invalid data but still allows you to cancel the data entry
A)Stop
B)Warning
C)Information
D)locked
E)macro
F)Excel application
G)defined name
H)input message
I)validation rule
J)digital certificate
K)digital signature
L)VBA

Accepted Answer

The answer of MATCHING
Identify the letter of the choice that...

Question 9

The ____ box displays all of the names in the workbook.
A) Name
B) Ranges
C) Definition
D) Terms

Accepted Answer

The "Name" box in Excel displays all of the names (such as cell names, range names, or table names) that have been defined in the workbook.

Question 10

-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

Accepted Answer

The Name box on the formula bar is used to create and define names for cells or ranges in Excel.

Question 11

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

Accepted Answer

Underscores are often used in place of spaces in field names because spaces can cause issues in programming languages and databases.

Question 12

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Error alert that prevents you from storing the data in the cell
A)Stop
B)Warning
C)Information
D)locked
E)macro
F)Excel application
G)defined name
H)input message
I)validation rule
J)digital certificate
K)digital signature
L)VBA

Accepted Answer

The answer of MATCHING
Identify the letter of the choice that...

Question 13

In the figure above,clicking the New button,opens the New Name dialog box.
A) Name
B) Macro
C) Label
D) Range

Accepted Answer

In the context of the given sentence, the best choice is A because the New Name dialog box is used to create or give a name to a cell or range of cells, hence the user needs to input a name in this dialog box. B (Macro) would be used for creating a macro, C (Label) is used to give a name to a chart or axis, and D (Range) is used to define a certain area of cells.

Question 14

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Word or string of characters associated with a single cell or a range
A)Stop
B)Warning
C)Information
D)locked
E)macro
F)Excel application
G)defined name
H)input message
I)validation rule
J)digital certificate
K)digital signature
L)VBA

Accepted Answer

A defined name in Excel refers to a word or string of characters associated with a single cell or a range.

Answer: I
 A validation rule is used in Excel to limit the type of data that can be entered into a cell or range.

(Note: Some may argue that E could also be a possible answer, as a macro can also be associated with a cell or range. However, the phrase "word or string of characters" may be more commonly associated with a defined name in this context.)

Question 15

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Property that determines whether or not changes can be made to a cell
A)Stop
B)Warning
C)Information
D)locked
E)macro
F)Excel application
G)defined name
H)input message
I)validation rule
J)digital certificate
K)digital signature
L)VBA

Accepted Answer

The property that determines whether or not changes can be made to a cell is called "locked" and can be toggled on or off in the cell's formatting options.

Question 16

The following is a valid function name: ____.
A) FY2010
B) Print_Area
C) Net-Income
D) none of the above

Accepted Answer

The answer of The following is a valid function name:...

Question 17

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Defines the criteria for storing data in a cell or range
A)Stop
B)Warning
C)Information
D)locked
E)macro
F)Excel application
G)defined name
H)input message
I)validation rule
J)digital certificate
K)digital signature
L)VBA

Accepted Answer

The criteria for storing data in a cell or range is defined through a validation rule.

Question 18

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

Accepted Answer

The statement mentions "special buttons", "changing the entire Excel interface", and "customized" which are all features that can be facilitated through commands, menus, and toolbars. Therefore, the correct answer is D, all of the above.

Question 19

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Programming language that allows you to create macros
A)Stop
B)Warning
C)Information
D)locked
E)macro
F)Excel application
G)defined name
H)input message
I)validation rule
J)digital certificate
K)digital signature
L)VBA

Accepted Answer

VBA (Visual Basic for Applications) is a programming language that allows you to create macros.

Question 20

After the first character in a range name,the following is acceptable: ____.
A) hyphen
B) space
C) periods
D) either a.or b.

Accepted Answer

Periods are acceptable in range names after the first character, while hyphens and spaces are not allowed.

Quiz 8: Developing an Excel Application

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Confirms that a macro or document has not been altered

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.

Range names can be up to ____ characters.

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

Range names must begin with ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Error alert that accepts the invalid data but still allows you to cancel the data entry

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

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Error alert that prevents you from storing the data in the cell

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Word or string of characters associated with a single cell or a range

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Property that determines whether or not changes can be made to a cell

The following is a valid function name: ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Defines the criteria for storing data in a cell or range

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Programming language that allows you to create macros

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