Question 1

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

Accepted Answer

Input messages are used to provide guidance or instructions to users when entering data into a cell. It is not related to validating data, but rather to offer a helpful hint to the user.

Question 2

Usually, you will want to protect a worksheet but leave some cells _____.
A)open
B)empty
C)clear
D)unlocked

Accepted Answer

If you protect a worksheet and leave some cells unlocked, those cells can be edited while the rest of the sheet remains protected. Therefore, the answer is D, unlocked cells.

Question 3

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

Accepted Answer

Macro viruses are capable of modifying or deleting files and can cause significant damage to computer systems. Digital signatures are used for authentication and verifying the origin of electronic documents, while comment viruses and micro viruses are not commonly used terms in the field of computer viruses.

Question 4

To remove workbook protection, click the Unprotect Workbook button in the _____ group on the Review tab.
A)Format
B)Changes
C)Sheet
D)Options

Accepted Answer

The Unprotect Workbook button is located in the Changes group on the Review tab in Excel, which is used to remove workbook protection.

Question 5

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

Accepted Answer

Underscore characters are commonly used in defined names in Excel to replace blanks or parentheses in row or column labels. They are a valid character to use in a defined name and do not cause any issues when referencing the named range in formulas.

Question 6

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

Accepted Answer

The Excel-supported error alert types are Stop, Warning, and Information. Security and Alert are not valid types of error alerts in Excel.

Question 7

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

Accepted Answer

The property referred to in the question is the "locked" property, which determines whether or not changes can be made to a cell. By default, all cells in a workbook are "unlocked" and can be changed. However, if a cell is "locked", it cannot be edited unless the sheet has been protected and the user has entered the correct password or the cell is unlocked by the person who set the protection. Therefore, the correct choice is B)locked.

Question 8

The Excel data _____ feature restricts data entry to follow a defined set of rules.
A)error-checking
B)rule-based
C)validation
D)contingent

Accepted Answer

Validation feature in Excel restricts data entry to follow a defined set of rules such as specifying a range of permitted values or ensuring that the input meets a certain requirement. It helps to ensure data accuracy and consistency.

Question 9

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

Accepted Answer

The answer of You use the _____ tab in the...

Question 10

Protecting the _____ prohibits users from renaming, deleting, hiding, or inserting worksheets.
A)skeleton
B)structure
C)format
D)location

Accepted Answer

Protecting the structure of a workbook prevents users from changing the layout and organization of the sheets. The other options (skeleton, format, location) are not relevant in this context.

Question 11

_____ messages appear as ScreenTips next to the active cell.
A)Value
B)Input
C)Key
D)User

Accepted Answer

Input messages appear as ScreenTips next to the active cell to provide guidance or suggestions for data entry. Value messages appear when the user enters a value that is not valid according to the data validation rules. Key messages appear when the user enters a keystroke that is not valid according to the data validation rules. User messages are custom messages created by the user.

Question 12

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

Accepted Answer

An input message in Excel can be used to specify the type of data the user should enter in a cell. For example, the message can prompt the user to enter a date, a number, or specific text. The other options (aspect, format, cast) do not accurately describe the purpose of an input message in Excel.

Question 13

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

Accepted Answer

The "Time" option in the Allow list box means that the cell will accept only times.

Question 14

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

Accepted Answer

The answer of Which of the following tabs in the...

Question 15

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

Accepted Answer

The Excel data validation feature allows the user to set rules or criteria for what can be entered into a cell or range, ensuring that only correct data is entered. This can include setting limits on the type of data (such as dates, whole numbers, or text), setting a range of acceptable values, or creating a drop-down list of options for the user to choose from. This helps to prevent errors and ensure the accuracy of data entered into the spreadsheet.

Question 16

The _____ Center is a central location for all the security settings in Office.
A)Secure
B)Security
C)Trust
D)Protection

Accepted Answer

The Trust Center in Office is the central location for all the security settings, including those related to macros, add-ins, digital certificates, and more.

Question 17

When you _____ a workbook, you control the ability users have to make changes to the file.
A)ensure
B)protect
C)secure
D)seal

Accepted Answer

When you protect a workbook, you can set various options for what users can and cannot do, such as editing cells, formatting, inserting and deleting sheets, and more. This helps to ensure the integrity of the data in the file.

Question 18

The _____ alert accepts the invalid data but still allows you to cancel the data entry.
A)Information
B)Stop
C)Security
D)Warning

Accepted Answer

The answer of The _____ alert accepts the invalid data...

Question 19

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

Accepted Answer

The Text Length option allows you to specify the number of characters that the cell will accept. This is useful when you want to limit the input to a specific number of characters, such as when entering a phone number or postal code. The Custom option allows you to create your own validation rules, but it does not specifically address text length. The Any Value option allows any value to be entered, which is not helpful if you are trying to limit the input to a specific number of characters. The Specified Text option allows you to specify a specific text string that can be entered into the cell, but it does not address text length.

Question 20

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

Accepted Answer

The "Whole Number" option in the Allow list box means that the cell will accept only integers (i.e., non-decimal numbers).

Quiz 7: Excel 3: Developing an Excel Application

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.

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

A _____ can be destructive and can modify or delete files that may not be recoverable.

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

Any blanks or parentheses in a row or column label will be changed to _____ in defined names.

The following are Excel-supported error alert types: _____.

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

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

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

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

_____ messages appear as ScreenTips next to the active cell.

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.

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

Which of the following tabs in the Data Validation dialog box allows you to set validation criteria?

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

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

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

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

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.

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