Question 1

The DCOUNTA function counts the cells that contain numbers in a given table column that match criteria. ____________________

Accepted Answer

The DCOUNTA function counts cells that are not empty and meet the specified criteria, including cells with text or logical values. It does not only count cells with numbers.

Question 2

When specifying criteria in the Custom AutoFilter dialog box, use the   * (asterisk) wildcard to represent any single character. _________________________

Accepted Answer

In the Custom AutoFilter dialog box, the * (asterisk) wildcard is used to represent any sequence of characters, not just a single character.

Question 3

One advantage of the Advanced Filter is that you can move filtered table data to a new worksheet.​

Accepted Answer

This is true. After applying the advanced filter and selecting "Copy to another location" option, you can choose to move the filtered data to a new worksheet.

Question 4

​If you leave a blank row in the criteria range, Excel filters nothing and shows all records.

Accepted Answer

When a blank row is present in the criteria range, Excel interprets it as having no filter criteria and thus shows all records.

Question 5

Excel's VLOOKUP function searches vertically down the far left column of a table, then reads across the row to find the value in the column you specify. _________________________

Accepted Answer

This is an accurate description of how the VLOOKUP function works in Excel.

Question 6

Icon sets let you visually communicate relative cell values by adding icons to cells based on the values they contain. _________________________

Accepted Answer

Icon sets are a great way to visually communicate relative cell values in Excel by adding icons to cells based on the values they contain.

Question 7

And and Or are logical conditions.

Accepted Answer

And and Or are indeed logical conditions used in programming and other areas.

Question 8

You cannot use a function to conditionally format cells.​ ____________________

Accepted Answer

In Google Sheets and Excel, you can use functions like IF, AND, OR, etc. to create custom formulas for conditional formatting.

Question 9

The Transpose function is a TEXT fun​ction that can be used to rearrange a range of cells. ____________________

Accepted Answer

The Transpose function is not a TEXT function, rather it is a built-in function in Microsoft Excel that can be used to rearrange the orientation of a range of cells.

Question 10

​You can filter a table by the color of the cells if conditional formatting has been applied.

Accepted Answer

If conditional formatting has been applied to a table, you can filter it by the color of the cells.

Question 11

When using the Advanced Filter command, a criteria range is not entered into a dialog box.

Accepted Answer

When using the Advanced Filter command, the criteria range is entered directly into the worksheet as a separate range of cells. It is not entered into a dialog box.

Question 12

A(n) column range is a cell range containing one row of labels and at least one additional row underneath the row of labels that contains the criteria you want to match. _________________________

Accepted Answer

A column range typically refers to a vertical selection of cells in a single column, not a specific arrangement involving a row of labels and a row of criteria. The description given more closely aligns with a criteria range in the context of database functions or filtering data, which can span multiple columns and rows.

Question 13

When specifying criteria in the Custom AutoFilter dialog box, use the ? (question mark) wildcard to specify a series of characters. _________________________

Accepted Answer

The asterisk (*) is used as the wildcard for a series of characters in the Custom AutoFilter dialog box, not the question mark (?), which represents a single character.

Question 14

A data scale uses a set of two, three, or four fill colors to convey relative values.​ ____________________

Accepted Answer

The answer of A data scale uses a set of...

Question 15

The transpose function allows you to arrange a vertical range of cells horizontally.​

Accepted Answer

The answer of The transpose function allows you to arrange...

Question 16

Subtotals can be used in an Excel table.

Accepted Answer

The answer of Subtotals can be used in an Excel...

Question 17

Greater than and less than are logical conditions.

Accepted Answer

The answer of Greater than and less than are logical...

Question 18

When you specify a complicated set of search criteria, it is a good idea to filter it in place rather than extract it.

Accepted Answer

The answer of When you specify a complicated set of...

Question 19

​You can restrict data in a table to whole numbers, decimal numbers, or text.

Accepted Answer

The answer of ​You can restrict data in a table...

Question 20

When you filter a table, you temporarily delete the records that do not meet your criteria.​

Accepted Answer

The answer of When you filter a table, you temporarily...

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

The DCOUNTA function counts the cells that contain numbers in a given table column that match criteria. ____________________

When specifying criteria in the Custom AutoFilter dialog box, use the * (asterisk) wildcard to represent any single character. _________________________

One advantage of the Advanced Filter is that you can move filtered table data to a new worksheet.

If you leave a blank row in the criteria range, Excel filters nothing and shows all records.

Excel's VLOOKUP function searches vertically down the far left column of a table, then reads across the row to find the value in the column you specify. _________________________

Icon sets let you visually communicate relative cell values by adding icons to cells based on the values they contain. _________________________

And and Or are logical conditions.

You cannot use a function to conditionally format cells. ____________________

The Transpose function is a TEXT function that can be used to rearrange a range of cells. ____________________

You can filter a table by the color of the cells if conditional formatting has been applied.

When using the Advanced Filter command, a criteria range is not entered into a dialog box.

A(n) column range is a cell range containing one row of labels and at least one additional row underneath the row of labels that contains the criteria you want to match. _________________________

When specifying criteria in the Custom AutoFilter dialog box, use the ? (question mark) wildcard to specify a series of characters. _________________________

A data scale uses a set of two, three, or four fill colors to convey relative values. ____________________

The transpose function allows you to arrange a vertical range of cells horizontally.

Subtotals can be used in an Excel table.

Greater than and less than are logical conditions.

When you specify a complicated set of search criteria, it is a good idea to filter it in place rather than extract it.

You can restrict data in a table to whole numbers, decimal numbers, or text.

When you filter a table, you temporarily delete the records that do not meet your criteria.

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

The DCOUNTA function counts the cells that contain numbers in a given table column that match criteria. ____________________

When specifying criteria in the Custom AutoFilter dialog box, use the * (asterisk) wildcard to represent any single character. _________________________

One advantage of the Advanced Filter is that you can move filtered table data to a new worksheet.​

​If you leave a blank row in the criteria range, Excel filters nothing and shows all records.

Excel's VLOOKUP function searches vertically down the far left column of a table, then reads across the row to find the value in the column you specify. _________________________

Icon sets let you visually communicate relative cell values by adding icons to cells based on the values they contain. _________________________

And and Or are logical conditions.

You cannot use a function to conditionally format cells.​ ____________________

The Transpose function is a TEXT fun​ction that can be used to rearrange a range of cells. ____________________

​You can filter a table by the color of the cells if conditional formatting has been applied.

When using the Advanced Filter command, a criteria range is not entered into a dialog box.

A(n) column range is a cell range containing one row of labels and at least one additional row underneath the row of labels that contains the criteria you want to match. _________________________

When specifying criteria in the Custom AutoFilter dialog box, use the ? (question mark) wildcard to specify a series of characters. _________________________

A data scale uses a set of two, three, or four fill colors to convey relative values.​ ____________________

The transpose function allows you to arrange a vertical range of cells horizontally.​

Subtotals can be used in an Excel table.

Greater than and less than are logical conditions.

When you specify a complicated set of search criteria, it is a good idea to filter it in place rather than extract it.

​You can restrict data in a table to whole numbers, decimal numbers, or text.

When you filter a table, you temporarily delete the records that do not meet your criteria.​

One advantage of the Advanced Filter is that you can move filtered table data to a new worksheet.

If you leave a blank row in the criteria range, Excel filters nothing and shows all records.

You cannot use a function to conditionally format cells. ____________________

The Transpose function is a TEXT function that can be used to rearrange a range of cells. ____________________

You can filter a table by the color of the cells if conditional formatting has been applied.

A data scale uses a set of two, three, or four fill colors to convey relative values. ____________________

The transpose function allows you to arrange a vertical range of cells horizontally.

You can restrict data in a table to whole numbers, decimal numbers, or text.

When you filter a table, you temporarily delete the records that do not meet your criteria.