Question 1

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 Subtotal feature in Excel quickly calculates subtotals and grand totals, but they can be removed when you're finished viewing or printing the data. This feature is commonly used in financial and accounting spreadsheets to summarize data and analyze trends.

Question 2

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, which includes all the months from January to August. The options A, C, and D would only give her partial totals.

Question 3

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 in Excel can be used to visually highlight any data that does not meet the designated validation requirements. This makes it easy to identify and correct any errors or discrepancies in the data.

Question 4

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 is specifically designed for combining text in multiple cells into one cell. The other options listed do not perform this task.

Question 5

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 is a tool in Microsoft Excel that allows you to watch the values of cells in different worksheets and workbooks in one convenient location. This can be useful when you are working on a complex workbook and need to monitor specific cell values while working in another worksheet. The other options listed (Delimiter, Cell Watch, and Concatenation Window) do not relate to this particular function in Excel.

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 can be found on the Data tab of the Ribbon.

Question 7

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 will display a warning dialog box but still allow the user to enter data, which is useful when the user may want to proceed despite the warning message.

Question 8

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 cells, such as only allowing certain types of data or a specific range of values. This helps ensure accurate and consistent data entry. Guidelines, validation text, and checklists do not have the same functionality as a validation rule.

Question 9

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

Accepted Answer

The grand total is the total for all the data, including all rows and columns. The other options listed (row total, subtotal, pre-total) refer to specific groups or sections of the data.

Question 10

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 is a feature in Excel that allows users to control the type of data entered in each cell, reducing the risk of errors and inconsistencies. This feature can be used to set rules for data entry, such as limiting values to a specific range, ensuring that only whole numbers or dates are entered, or requiring unique values in a range.

Question 11

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 answer of FIGURE EX 11-1  Figure EX 11-1...

Question 12

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

Accepted Answer

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

Question 13

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 can separate data in a worksheet by specifying a delimiter, such as a space or comma, and dividing the text into separate columns. This is useful for separating first and last names, for example. Data Validation is used to control what data can be entered into a cell, the Watch Window is a tool for monitoring specific cells or formulas, and Concatenation is used to combine text from multiple cells into one.

Question 14

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. In database management systems, delimiters are used to separate fields in a table, and in programming languages, delimiters are used to separate code statements. A ruler is a tool used for measuring, a subtotal is the sum of a subset of data, and a spreader is not a term used in this context.

Question 15

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, which appears to be a magnifying glass or zoom feature, is typically used to display the greatest amount of detail in images like this.

Question 16

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 where data separated by Excel will be placed when using a delimiter. The other choices (A, B, and C) are not commonly used terms in Excel for this function.

Question 17

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

The answer of Case EX 11-2 Sharon has a large...

Question 18

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 to quickly view the totals for the worksheet without storing the information permanently. The Subtotal feature can calculate the sum, count, average, minimum, maximum, and other functions on a set of data. It can also be easily removed without affecting the original data.

Question 19

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 will prevent any value that does not meet the specified criteria from being entered, while the Warning and Information styles may allow the user to enter the value but display a message to warn or inform them about the criteria. There is no option for a Strict style in the Error Alert tab.

Question 20

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

The Data Validation feature allows Sharon to set rules and restrictions for the information entered in specific cells or ranges, ensuring that data is entered in the correct format and accuracy is improved.

Quiz 17: Improving Data Accuracy

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

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.

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

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

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

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

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.

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

The ____ is the total for all the data.

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

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

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

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

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

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

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.