Question 1

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

Accepted Answer

Cell and range references only indicate the location of the data, not the content of the cell or range.

Question 2

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

Accepted Answer

When Excel creates a macro button, the Assign Macro dialog box opens with the default name of "Button 1" showing.

Question 3

Validation rules come into play only during data entry.

Accepted Answer

True

Question 4

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

Accepted Answer

Running a macro means Excel performs all of the steps that were recorded, not just a portion.

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

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

This is true. Excel automatically replaces any blanks or parentheses in row or column labels with underscore characters when creating defined names.

Question 8

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

Accepted Answer

Data Validation

Question 9

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

Accepted Answer

The Name Manager dialog box displays all the names in the workbook. The Ranges dialog box allows users to group and manage ranges, the Definition dialog box provides information about a selected range or cell, and the Terms dialog box is not a feature in Excel.

Question 10

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

Accepted Answer

Name Manager

Question 11

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

Accepted Answer

This statement is true. Practical cell and range names are usually between 5 to 15 characters, but they can be up to 255 characters long if needed.

Question 12

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

Accepted Answer

The Stop alert feature in Excel prevents a user from entering invalid data in a cell and does not allow it to be saved in the worksheet.

Question 13

Which of the following is NOT a valid defined name? 
A) netincome
B) Net_Income 
C) Net-Income
D) NetIncome

Accepted Answer

Defined names cannot contain hyphens or special characters, only letters, numbers, and underscores. Therefore, options A, B, and D are all valid defined names.

Question 14

Range names must begin with _____.
A) a letter or an underscore
B) a number 
C) a hash tag
D) an asterisk

Accepted Answer

Range names must always begin with a letter or underscore. Starting with any other character will result in an error message.

Question 15

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

Accepted Answer

This is true. A macro can be assigned to a button on the worksheet by using the "Insert" tab and selecting "Shape" or "Button" and then linking the macro to the button using the "Assign Macro" option.

Question 16

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

Accepted Answer

signature

Question 17

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

Accepted Answer

This statement is true. Cells can be locked or unlocked to prevent or allow changes to be made to them.

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

Defined names must be manually inserted into formulas; Excel does not automatically substitute them for existing range references.

Question 20

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

Accepted Answer

The locked property only takes effect when the worksheet is protected; otherwise, all cells can be edited regardless of their locked status.

Quiz 7: Developing an Excel Application