Question 1

When you issue the Subtotal command, clicking the 2 outline symbol shows only subtotals and the ____________________ total.

Accepted Answer

The answer of When you issue the Subtotal command, clicking...

Question 2

Which Excel feature provides a quick and easy way to group and summarize a range of data?
A) Group
B) Subtotals
C) Summarize
D) Summary

Accepted Answer

Subtotals provide a quick and easy way to group and summarize a range of data by creating subtotals for each group. This feature allows for easy analysis of data and identifying patterns or trends based on the grouped data.

Question 3

To specify a long list of valid entries you can type them ____ and then type the list range in the Source text box.
A) on a new sheet
B) in the formula bar
C) in another workbook
D) elsewhere in the worksheet

Accepted Answer

The best choice is to type them elsewhere in the worksheet and then specify the list range in the Source text box. This could be in a separate column or row in the same worksheet.

Question 4

What happens if you insert invalid data in a cell?
A) ##Error appears in the cell.
B) A warning dialog box appears.
C) Invalid appears in the cell.
D) (???? )appears in the cell.

Accepted Answer

The answer of What happens if you insert invalid data...

Question 5

With the data validation feature, you can restrict data to all of the following EXCEPT ____.
A) whole numbers
B) decimal numbers
C) text
D) invalid entries

Accepted Answer

Data validation feature is used to restrict data and ensure data accuracy by allowing only specific types of data to be entered in cells. Therefore, the data validation feature cannot restrict invalid entries because it is designed to only allow specific types of data.

Question 6

The _____ function extracts a single record from a table that matches criteria.​
A)DGET
B)DMATCH
C)DEXTRACT
D)DSINGLE

Accepted Answer

The DGET function is used to extract a single record from a table that matches criteria by returning a single value from the intersection of a particular row and column in a specified range. The other options listed (DMATCH, DEXTRACT, DSINGLE) are not valid Excel functions.

Question 7

Use the ____________________ function when you want to find the position of an item in a range.

Accepted Answer

The answer of Use the ____________________ function when you want...

Question 8

You often create subtotals with the ____ function.
A) VALUE
B) ADD
C) MULTIPLY
D) SUM

Accepted Answer

The SUM function is specifically designed to add up a range of numbers, which is typically what is needed when creating subtotals. The other options (VALUE, ADD, and MULTIPLY) are not relevant to creating subtotals.

Question 9

The V in the VLOOKUP function stands for ____________________.

Accepted Answer

The answer of The V in the VLOOKUP function stands...

Question 10

Which of the following is NOT a common database function?​
A)DSUM
B)DCOUNT
C)DAVERAGE
D)DMATCH

Accepted Answer

DMATCH is not a common database function. DSUM, DCOUNT, and DAVERAGE are common functions used in database management systems.

Question 11

When specifying criteria in the Custom AutoFilter dialog box, use the ____________________ wildcard to specify a single character.

Accepted Answer

The answer of When specifying criteria in the Custom AutoFilter...

Question 12

The _____ function counts the cells that contain nonblank data in a given table column that match criteria.​
A)DCOUNT
B)DCOUNTIF
C)DCOUNTA
D)DCOUNTNON

Accepted Answer

The answer of The _____ function counts the cells that...

Question 13

If you want to find the closest possible match, what do you enter in the Range_lookup text box in the Function Arguments dialog box?
A) TRUE
B) CLOSEST
C) NEAR
D) FALSE

Accepted Answer

If you want to find the closest possible match, you should enter TRUE in the Range_lookup text box in the Function Arguments dialog box. Setting this to TRUE will allow Excel to find the closest match to the lookup value in the lookup array.

Question 14

All of the following are alert styles that appear if a user enters invalid data EXCEPT ____.​
A)Abort
B)Information
C)Warning
D)Stop

Accepted Answer

The answer of All of the following are alert styles...

Question 15

When you generate subtotals, all levels of detail show in a(n) ____.
A) outline
B) extracted table
C) list range
D) graph

Accepted Answer

The answer of When you generate subtotals, all levels of...

Question 16

Before you can add subtotals to table data, you must convert it to a(n) ____ and then sort it.
A) list
B) column
C) range
D) argument

Accepted Answer

The answer of Before you can add subtotals to table...

Question 17

The Advanced Filter command allows you to search for data using And and Or ____________________ conditions.

Accepted Answer

The answer of The Advanced Filter command allows you to...

Question 18

Which of the following is NOT a term used to describe the arrows that automatically appear next to each column in a table.​
A)filter column arrow
B)AutoFilter list arrow
C)filter list arrow
D)list arrow

Accepted Answer

The answer of Which of the following is NOT a...

Question 19

When performing an advanced filter, ____________________ conditions must be entered on the same row.

Accepted Answer

The answer of When performing an advanced filter, ____________________ conditions...

Question 20

To display records for customers with incomes that are above $40,000 and below $70,000, use the ____________________ logical condition.​

Accepted Answer

The answer of To display records for customers with incomes...

Quiz 8: Merging Word Documents Analyzing Table Dataanalyzing Data With Reportsusing Advanced Features

When you issue the Subtotal command, clicking the 2 outline symbol shows only subtotals and the ____________________ total.

Which Excel feature provides a quick and easy way to group and summarize a range of data?

To specify a long list of valid entries you can type them ____ and then type the list range in the Source text box.

What happens if you insert invalid data in a cell?

With the data validation feature, you can restrict data to all of the following EXCEPT ____.

The _____ function extracts a single record from a table that matches criteria.​

Use the ____________________ function when you want to find the position of an item in a range.

You often create subtotals with the ____ function.

The V in the VLOOKUP function stands for ____________________.

Which of the following is NOT a common database function?​

When specifying criteria in the Custom AutoFilter dialog box, use the ____________________ wildcard to specify a single character.

The _____ function counts the cells that contain nonblank data in a given table column that match criteria.​

If you want to find the closest possible match, what do you enter in the Range_lookup text box in the Function Arguments dialog box?

All of the following are alert styles that appear if a user enters invalid data EXCEPT ____.​

When you generate subtotals, all levels of detail show in a(n) ____.

Before you can add subtotals to table data, you must convert it to a(n) ____ and then sort it.

The Advanced Filter command allows you to search for data using And and Or ____________________ conditions.

Which of the following is NOT a term used to describe the arrows that automatically appear next to each column in a table.​

When performing an advanced filter, ____________________ conditions must be entered on the same row.

To display records for customers with incomes that are above $40,000 and below $70,000, use the ____________________ logical condition.​

The _____ function extracts a single record from a table that matches criteria.

Which of the following is NOT a common database function?

The _____ function counts the cells that contain nonblank data in a given table column that match criteria.

All of the following are alert styles that appear if a user enters invalid data EXCEPT ____.

Which of the following is NOT a term used to describe the arrows that automatically appear next to each column in a table.

To display records for customers with incomes that are above $40,000 and below $70,000, use the ____________________ logical condition.