Question 1

The Match case option in the Find and Replace dialog box is used to search for duplicate records.

Accepted Answer

The Match case option is used to search for matches that have the same capitalization as the search text. It is not used to search for duplicate records.

Question 2

You can create a table from any contiguous range of cells in your worksheet.​

Accepted Answer

Yes, you can create a table from any contiguous range of cells in your worksheet.

Question 3

As you point to each table style, Style Preview shows you what your table will look like with the style applied. ____________________​

Accepted Answer

The answer of As you point to each table style,...

Question 4

You can add new rows and columns to a data table by dragging the sizing handle in the table's lower-right corner.

Accepted Answer

Dragging the sizing handle in the lower-right corner of a data table allows you to add new rows and columns to the table.

Question 5

Banding is a feature that creates different formatting for adjacent rows and columns.​

Accepted Answer

Banding is a feature in Microsoft Excel that creates different formatting for adjacent rows and columns to make data easier to read and understand.

Question 6

You can also create a table using the shortcut key combination [Ctrl][T].​

Accepted Answer

This shortcut key combination is used to create a table in Microsoft Word.

Question 7

Tables in Excel must have a header row.​

Accepted Answer

The answer of Tables in Excel must have a header...

Question 8

To delete a table row, place the cursor in any cell in the row you wish to delete, then click Delete Table Rows from the Delete list arrow in the Cells group.

Accepted Answer

This statement is correct. To delete a table row, you need to place the cursor in any cell in that row and then click on "Delete Table Rows" from the Delete list arrow in the Cells group.

Question 9

The table total row adapts to any changes in the table size.​

Accepted Answer

The total row in a table dynamically updates based on any changes made to the table, including adding or removing rows or changing values in the existing rows.

Question 10

The Wildcard dialog box helps you find records in a table.

Accepted Answer

The answer of The Wildcard dialog box helps you find...

Question 11

To find only capitalized instances of a letter, click the Advanced button in the Find &​ Replace dialog box, then click the Match case check box.

Accepted Answer

The answer of To find only capitalized instances of a...

Question 12

The question mark (?) wildcard stands for any single character.

Accepted Answer

The question mark (?) wildcard represents any single character, whereas the asterisk (*) represents any number of characters, including none.

Question 13

The wildcard asterisk (*) always represents one single character.

Accepted Answer

The wildcard asterisk (*) represents zero or more characters. The wildcard for representing one single character is the question mark (?).

Question 14

You can add a header or a footer by clicking the Page Layout button in the task bar and clicking in the header and footer area.​ ____________________

Accepted Answer

Headers and footers are typically added through the "Insert" tab or "View" tab in most software applications, not the "Page Layout" button.

Question 15

You can delete a table row using the Resize Table button in the Arrange group of the Table Tools Design tab. ____________________​

Accepted Answer

The Resize Table button is used to adjust the size of the table, not to delete rows. To delete a table row, you typically use options in the Table Tools Layout tab, not the Design tab.

Question 16

​If cells are conditionally formatted with color, you can sort a field on Cell Color.

Accepted Answer

Sorting on cell color is possible when cells are conditionally formatted with color.

Question 17

You can add new rows to a table by typing data directly below the last row, and then pressing [Tab].

Accepted Answer

The answer of You can add new rows to a...

Question 18

When you create a table, Excel automatically applies a default table style.

Accepted Answer

The answer of When you create a table, Excel automatically...

Question 19

The Find and Replace dialog box can be opened by clicking the Find & Select button in the Editing group.

Accepted Answer

The answer of The Find and Replace dialog box can...

Question 20

Youcan select the table data by clicking the upper- right corner of the first table cell. ____________________

Accepted Answer

The answer of Youcan select the table data by clicking...

Quiz 7: Working With Themes and Building Blocksusing Tablesenhancing Formsinserting Graphics, Media, and Objects

The Match case option in the Find and Replace dialog box is used to search for duplicate records.

You can create a table from any contiguous range of cells in your worksheet.

As you point to each table style, Style Preview shows you what your table will look like with the style applied. ____________________

You can add new rows and columns to a data table by dragging the sizing handle in the table's lower-right corner.

Banding is a feature that creates different formatting for adjacent rows and columns.

You can also create a table using the shortcut key combination [Ctrl][T].

Tables in Excel must have a header row.

To delete a table row, place the cursor in any cell in the row you wish to delete, then click Delete Table Rows from the Delete list arrow in the Cells group.

The table total row adapts to any changes in the table size.

The Wildcard dialog box helps you find records in a table.

To find only capitalized instances of a letter, click the Advanced button in the Find & Replace dialog box, then click the Match case check box.

The question mark (?) wildcard stands for any single character.

The wildcard asterisk (*) always represents one single character.

You can add a header or a footer by clicking the Page Layout button in the task bar and clicking in the header and footer area. ____________________

You can delete a table row using the Resize Table button in the Arrange group of the Table Tools Design tab. ____________________

If cells are conditionally formatted with color, you can sort a field on Cell Color.

You can add new rows to a table by typing data directly below the last row, and then pressing [Tab].

When you create a table, Excel automatically applies a default table style.

The Find and Replace dialog box can be opened by clicking the Find & Select button in the Editing group.

Youcan select the table data by clicking the upper- right corner of the first table cell. ____________________

Quiz 7: Working With Themes and Building Blocksusing Tablesenhancing Formsinserting Graphics, Media, and Objects

The Match case option in the Find and Replace dialog box is used to search for duplicate records.

You can create a table from any contiguous range of cells in your worksheet.​

As you point to each table style, Style Preview shows you what your table will look like with the style applied. ____________________​

You can add new rows and columns to a data table by dragging the sizing handle in the table's lower-right corner.

Banding is a feature that creates different formatting for adjacent rows and columns.​

You can also create a table using the shortcut key combination [Ctrl][T].​

Tables in Excel must have a header row.​

To delete a table row, place the cursor in any cell in the row you wish to delete, then click Delete Table Rows from the Delete list arrow in the Cells group.

The table total row adapts to any changes in the table size.​

The Wildcard dialog box helps you find records in a table.

To find only capitalized instances of a letter, click the Advanced button in the Find &​ Replace dialog box, then click the Match case check box.

The question mark (?) wildcard stands for any single character.

The wildcard asterisk (*) always represents one single character.

You can add a header or a footer by clicking the Page Layout button in the task bar and clicking in the header and footer area.​ ____________________

You can delete a table row using the Resize Table button in the Arrange group of the Table Tools Design tab. ____________________​

​If cells are conditionally formatted with color, you can sort a field on Cell Color.

You can add new rows to a table by typing data directly below the last row, and then pressing [Tab].

When you create a table, Excel automatically applies a default table style.

The Find and Replace dialog box can be opened by clicking the Find & Select button in the Editing group.

Youcan select the table data by clicking the upper- right corner of the first table cell. ____________________

You can create a table from any contiguous range of cells in your worksheet.

As you point to each table style, Style Preview shows you what your table will look like with the style applied. ____________________

Banding is a feature that creates different formatting for adjacent rows and columns.

You can also create a table using the shortcut key combination [Ctrl][T].

Tables in Excel must have a header row.

The table total row adapts to any changes in the table size.

To find only capitalized instances of a letter, click the Advanced button in the Find & Replace dialog box, then click the Match case check box.

You can add a header or a footer by clicking the Page Layout button in the task bar and clicking in the header and footer area. ____________________

You can delete a table row using the Resize Table button in the Arrange group of the Table Tools Design tab. ____________________

If cells are conditionally formatted with color, you can sort a field on Cell Color.