Question 1

The ____ feature can be used to ensure that data is entered as accurately as possible in a worksheet.
A) Data Validation
B) CheckList
C) Reporting
D) Data Structure

Accepted Answer

Data Validation feature can be used to set rules and restrictions on the type, format, and values of data that can be entered in a particular cell or range of cells. This helps to reduce errors and improve data accuracy.

Question 2

Adding a ____ allows you to set parameters for worksheet cells where values will be entered.
A) guideline
B) validation rule
C) validation text
D) check list

Accepted Answer

A validation rule allows you to set parameters for worksheet cells where values will be entered. The rule specifies what type of data can be entered (numbers, text, dates, etc.) and can set conditions for the data (such as requiring a value within a certain range). The other choices, guidelines, validation text, and checklists, do not have this functionality.

Question 3

Case EX 11-1 Venecia is using a worksheet to track her spending each month. So far the worksheet has the information for January up to August. Venecia wants to quickly view the totals for the worksheet but does not want to store that information permanently in the worksheet. She needs to use the ____ feature.
A) Grand totals
B) Formulas
C) Temp Formulas
D) Subtotal

Accepted Answer

Venecia should use the Subtotal feature, which calculates and displays subtotals and grand totals for selected data. This information is not stored permanently in the worksheet, but can be easily viewed or hidden as needed.

Question 4

Case EX 11-1 Venecia is using a worksheet to track her spending each month. So far the worksheet has the information for January up to August. Finding the ____ would give Venecia the total for all the data in the worksheet.
A) column total
B) grand total
C) subtotal
D) final total

Accepted Answer

The grand total would give Venecia the total for all the data in the worksheet, including information from January through August. The column total would give the total for a specific column, the subtotal would give the total for a subset of the data, and the final total implies that there is a specific final amount being calculated, which may not be the case in this scenario. Therefore, the best choice is the grand total.

Question 5

FIGURE EX 11-1  Figure EX 11-1 above shows the ____ feature applied to the worksheet.
A) Table Format
B) Subtotal
C) Watch Window
D) Data Validation

Accepted Answer

The image shows a data set with subtotals applied to it.

Question 6

The Data Validation button is found on the ____ tab on the Ribbon.
A) Home
B) Data
C) Review
D) View

Accepted Answer

The Data Validation button is located on the Data tab on the Ribbon in Microsoft Excel.

Question 7

A ____ is a character, such as a comma, space, or a tab, used to separate data.
A) ruler
B) delimiter
C) subtotal
D) spreader

Accepted Answer

A delimiter is a character used to separate data, such as a comma separating two values in a spreadsheet or a tab separating fields in a text file. A ruler is a measuring tool, a subtotal is a sum of values, and a spreader is not a term commonly used in data formatting or organization.

Question 8

Case EX 11-2 Sharon has a large collection of books at her home and she has catalogued them and stored that information in a worksheet titled Books in a workbook that also contains other worksheets. If Sharon decides to go to another worksheet in the workbook, she can still view data from the Books worksheet by using a(n) ____.
A) Sub Window
B) Watch Window
C) Message Window
D) Add Window

Accepted Answer

A Watch Window allows users to keep an eye on specific cells from different worksheets while working in another worksheet within the same workbook.

Question 9

Excel places circles around any invalid data using the ____________________ feature.

Accepted Answer

The answer of Excel places circles around any invalid data...

Question 10

Choosing the ____ style in the Error Alert tab of the Data Validation dialog box displays a warning dialog box but allows the data to be entered.
A) Warning
B) Information
C) Stop
D) Strict

Accepted Answer

Choosing the Warning style displays a warning dialog box but allows the data to be entered, which is suitable if the validation is not critical but still needs to draw the user's attention to it.

Question 11

You can use the ____ feature to have circles drawn around data that does not meet the data validation requirements.
A) Circle Invalid Data
B) Data Checking
C) Circle Problems
D) Format Checking

Accepted Answer

The "Circle Invalid Data" feature is specifically designed for this purpose - to highlight or circle data that does not meet the validation requirements. The other options listed are not accurate or relevant to this feature.

Question 12

The ____ is the total for all the data.
A) row total
B) grand total
C) subtotal
D) pre-total

Accepted Answer

The term "grand total" is commonly used to indicate the total for all the data. The other options (A, C, and D) refer to different types of subtotals within the data.

Question 13

The ____ feature quickly calculates subtotals and grand totals, but they can be removed when you're finished viewing or printing the data.
A) Reporting
B) Formulas
C) Temp View
D) Subtotal

Accepted Answer

The feature being described is the Subtotal feature in Microsoft Excel.

Question 14

The ____ is the location in the worksheet where data separated by Excel will be placed.
A) delimiter
B) keyhole range
C) separated range
D) destination range

Accepted Answer

The destination range is the location where data separated by Excel will be placed. A delimiter is a character that separates values in a string, a keyhole range and separated range are not recognized Excel terms.

Question 15

If the ____ style is selected in the Error Alert tab of the Data Validation dialog box, you will not be allowed to enter any value that does not meet the criteria.
A) Warning
B) Information
C) Stop
D) Strict

Accepted Answer

The "Stop" style is the best choice because it completely prohibits any value that does not meet the specified criteria from being entered in the cell. The other options allow the user to input invalid data, but display a warning or information message.

Question 16

The ____ feature is a great method for separating data in a worksheet, such as first and last names.
A) Data Validation
B) Convert Text to Columns
C) Watch Window
D) Concatenation

Accepted Answer

The Convert Text to Columns feature allows you to separate data in a worksheet based on a chosen delimiter, such as a comma or space. This is helpful when you have information in one cell that needs to be split into multiple columns, such as first and last names.

Question 17

You can add cells of data into a ____ if you want to be able to view the data while working in another worksheet.
A) Delimiter
B) Cell Watch
C) Watch Window
D) Concatenation Window

Accepted Answer

The Watch Window allows you to monitor cells of data while working in another worksheet. Delimiter and Concatenation Window are unrelated concepts, and Cell Watch is not a valid feature in Microsoft Excel.

Question 18

FIGURE EX 11-1  In Figure EX 11-1 above, click ____ to display the greatest amount of detail.
A) item 1
B) item 2
C) item 3
D) item 4

Accepted Answer

Item 4 is the only item marked with a magnifying glass icon, indicating the option to zoom in and display the greatest amount of detail.

Question 19

Case EX 11-2 Sharon has a large collection of books at her home and she has catalogued them and stored that information in a worksheet titled Books in a workbook that also contains other worksheets. Sharon wants to make sure that whenever she enters the information for a new book in her worksheet, it is entered in the correct format and as accurately as possible. She needs to use the ____ feature.
A) Subtotal
B) Data Validation
C) Watch Window
D) Data Checking

Accepted Answer

Sharon needs to use the Data Validation feature, which allows her to set rules and conditions for the data entry in her worksheet to ensure that the information is entered in the correct format and as accurately as possible.

Question 20

To join the values of cells together, you use the ____ function.
A) Concatenate
B) Convert Text to Columns
C) Watch Window
D) Join

Accepted Answer

The CONCATENATE function, also known as "&" operator, is used to join the values or text in different cells into a single cell.

Quiz 2: Microsoft Excel Basics

The ____ feature can be used to ensure that data is entered as accurately as possible in a worksheet.

Adding a ____ allows you to set parameters for worksheet cells where values will be entered.

Case EX 11-1 Venecia is using a worksheet to track her spending each month. So far the worksheet has the information for January up to August. Finding the ____ would give Venecia the total for all the data in the worksheet.

FIGURE EX 11-1 Figure EX 11-1 above shows the ____ feature applied to the worksheet.

The Data Validation button is found on the ____ tab on the Ribbon.

A ____ is a character, such as a comma, space, or a tab, used to separate data.

Excel places circles around any invalid data using the ____________________ feature.

Choosing the ____ style in the Error Alert tab of the Data Validation dialog box displays a warning dialog box but allows the data to be entered.

You can use the ____ feature to have circles drawn around data that does not meet the data validation requirements.

The ____ is the total for all the data.

The ____ feature quickly calculates subtotals and grand totals, but they can be removed when you're finished viewing or printing the data.

The ____ is the location in the worksheet where data separated by Excel will be placed.

If the ____ style is selected in the Error Alert tab of the Data Validation dialog box, you will not be allowed to enter any value that does not meet the criteria.

The ____ feature is a great method for separating data in a worksheet, such as first and last names.

You can add cells of data into a ____ if you want to be able to view the data while working in another worksheet.

FIGURE EX 11-1 In Figure EX 11-1 above, click ____ to display the greatest amount of detail.

To join the values of cells together, you use the ____ function.