Question 1

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

Accepted Answer

Defined names must be manually inserted into formulas; Excel does not automatically substitute cell addresses with defined names in formulas.

Question 2

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

Accepted Answer

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.

Accepted Answer

When a sheet is protected, you can choose to restrict the user to selecting only unlocked cells or allow them to select any cell in the worksheet.

Question 4

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

Accepted Answer

The security level set on the computer determines how macros are handled when a file with macros is opened. Depending on the security level, the user may be prompted to enable or disable macros before the file can be fully opened, or macros may be disabled by default.

Question 5

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

Accepted Answer

Data validation can only verify data that meets the criteria set by the validation rules. It cannot verify data that was entered before the validation criteria were applied.

Question 6

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

Accepted Answer

You can protect a worksheet by disabling the "Delete" and "Insert" worksheet options in the "Protect Sheet" settings.

Question 7

Each macro must have a unique name.

Accepted Answer

Each macro must have a unique name to avoid confusion and ensure it can be called properly in the code.

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.

Accepted Answer

A red triangle in the corner of a cell in spreadsheet software like Excel indicates that the cell contains a comment.

Question 9

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

Accepted Answer

The frequency of error alerts does not determine the choices presented to the user; rather, it's the design and logic of the system or application that specifies what options or corrections are offered in response to an invalid entry.

Question 10

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

Accepted Answer

You can allow specific users to insert new rows or columns into a protected sheet by selecting "Insert Rows" or "Insert Columns" under the "Allow Users to" section in the Sheet Protection settings.

Question 11

Each cell can have at most three validation rules.

Accepted Answer

Excel does not limit the number of validation rules a cell can have; rather, it allows for a single validation rule per cell, but this rule can encompass multiple criteria if properly structured.

Question 12

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

Accepted Answer

The instruction in the question is incorrect or incomplete, as there is no accompanying figure for reference. The selection handle of a comment would not be used to move a box in a typical scenario, unless further context is provided.

Question 13

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

Accepted Answer

When you protect a worksheet, the cells that are not locked can still be edited, while the cells that are locked cannot be edited. By default, all cells in a worksheet are locked, but you can change this by selecting cells and then clicking the "Lock Cells" option in the "Format Cells" dialog box.

Question 14

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

Accepted Answer

The answer of For cell and range names,names of 25...

Question 15

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 modified regardless of their locked status.

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.

Accepted Answer

By default, a macro records using absolute references, meaning it will select the same cells regardless of which cell was first selected. Relative references must be explicitly enabled for a macro to adjust its cell selections based on the initially selected cell.

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.

Accepted Answer

The answer of 
-Clicking the Edit button in the accompanying...

Question 18

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

Accepted Answer

You can prevent users from changing all of the formulas in a worksheet by protecting the worksheet and locking the cells that contain formulas.

Question 19

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

Accepted Answer

The Name Manager dialog box can be used to create a defined name in Excel.

Question 20

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

Accepted Answer

When the Ribbon is minimized, only the Quick Access Toolbar and the tab names are displayed. This allows for more screen space and reduced distraction while still providing quick access to commonly used tools via the Quick Access Toolbar.

Quiz 8: Developing an Excel Application