Question 1

The Table Styles gallery includes an option for creating a custom table style.

Accepted Answer

The Table Styles gallery in Microsoft Word includes an option for creating a custom table style.

Question 2

You can change a table back to a range by clicking the Change to Range button on the Table Tools Design tab.

Accepted Answer

- Convert
 - convert
 - CONVERT

Question 3

Ned has a table with an Expenses column listing monthly expenses. To total numbers in the Expenses column that are greater than 100, he can use the DSUM function.

Accepted Answer

DSUM can be used to sum values that meet certain criteria, such as being greater than 100 in this case.

Question 4

Mila wants to specify what data users can enter in a table column. What Excel feature should she use?
A) Table filters
B) VLOOKUP function
C) Multilevel sort
D) Data validation

Accepted Answer

Data validation allows users to restrict what data can be entered into a cell or column. Mila can use data validation to set specific rules for the type of data that can be entered into each cell in a specific column. This ensures data consistency and accuracy in the table. Table filters, VLOOKUP function, and multilevel sort do not restrict what data can be entered into a table column.

Question 5

When you want to know the position of an item in a range, you can use the LOOKUP function.

Accepted Answer

- MATCH
 - match
 - Match

Question 6

After creating a table, you can add preset formatting combinations of fill color, borders, type style, and type color by apply a table format .

Accepted Answer

- style
 - Style
 - STYLE

Question 7

When you set a Stop error alert style in a cell, users have the option of entering data or cancelling.

Accepted Answer

When a Stop error alert style is set in a cell, users are prevented from entering data that does not meet the validation criteria; they must either enter acceptable data or cancel the entry.

Question 8

A table formula can use a table reference to refer to column names instead of cell addresses.

Accepted Answer

- structured
- Structured
- STRUCTURED

Question 9

Which of the following Excel features applies a design using theme colors to a table?
A) table style
B) cell style
C) font style
D) number format

Accepted Answer

Table style applies a design using theme colors to a table, while cell style applies a design to individual cells, font style changes the font of the cell content, and number format changes how cell data is displayed.

Question 10

Use the DGET function to count the numeric values in a column for cells that match the criteria.

Accepted Answer

- DCOUNT
- dcount
- Dcount

Question 11

Reggie created a data validation rule for cell B3, which contains a unit price. He wants to use the only the data validation in cell D3. Which of the following should he do?
A) Use the Format Painter to copy the formats from cell B3 to cell D3.
B) Copy cell B3 to cell D3.
C) Copy cell B3 then paste values in cell D3.
D) Copy cell B3 and the paste validation in cell D3.

Accepted Answer

Copying the validation rule from cell B3 and pasting it in cell D3 ensures that only the validation rule is applied to the data entered in cell D3 and not any formatting or values from cell B3. Using the Format Painter or copying the entire cell would carry over unnecessary formatting and data that may not be needed in cell D3. Pasting only values would remove the validation rule from cell D3.

Question 12

Soledad is working with a worksheet that groups data by quarter. The Quarter 4 details are hidden. She can click the Auto Outline button to display the hidden data.

Accepted Answer

The answer of Soledad is working with a worksheet that...

Question 13

When you remove duplicate records from a table, Excel can examine only one column for duplicate data.

Accepted Answer

The answer of When you remove duplicate records from a...

Question 14

A(n) highlighting scale is a formatting scheme that uses colors to convey relative values of data, such as using red for cells with high values and green for cells with low values.

Accepted Answer

- color
 - Color
 - COLOR

Question 15

You can change a table to a worksheet range by click the Change to Range button.

Accepted Answer

- Convert
 - convert
 - CONVERT

Question 16

You can copy and paste only the cell validation by copying a cell with data validation, right-clicking the destination cell, clicking Paste Special, then clicking the Rules button in the Paste Special dialog box.

Accepted Answer

- Validation
 - validation
 - VALIDATION

Question 17

Mitchel wants to remove a row of unnecessary data in a table created in MS Excel. What should he do after selecting the row?
A) Right-click and select Insert from the drop-down menu, and pick Table Rows Above.
B) Right-click and select Insert from the drop-down menu, and pick Table Rows Below.
C) Click on the Design tab in the Tools group, and then click Remove Duplicates.
D) Click the arrow next to Delete on the Home tab, in the Cells group, and then click Delete Table Rows.

Accepted Answer

After selecting the row, clicking the arrow next to Delete on the Home tab, in the Cells group, and then clicking Delete Table Rows is the best choice to remove it. This option specifically allows for the deletion of a row in a table while leaving the rest of the table intact. Options A and B involve inserting rows, which is not what Mitchel wants to do in this case. Option C is used to remove duplicate rows, not unnecessary ones.

Question 18

To ungroup a range of cells in a row in a worksheet, select the rows or columns you wish to ungroup, then click the Group command in the Outline group on the Data tab. In the Group dialog box, select Rows and click OK .

Accepted Answer

To ungroup a range of cells in a row or column, you should select the rows or columns you wish to ungroup, then click the Ungroup command in the Outline group on the Data tab, not the Group command.

Question 19

Dante uses a worksheet to list sales data from five stores he manages. The worksheet includes a column named Product Type, and Dante wants to calculate subtotals for each product type. What must he do before using the Subtotal feature?
A) Sort the data in the Product Type column.,
B) Convert the range to a table.
C) Outline the data.
D) Remove calculated columns.

Accepted Answer

Dante must first sort the data in the Product Type column before using the Subtotal feature. This will ensure that all items of the same product type are grouped together for calculating the subtotals.

Question 20

Martha created a table where employees can enter customer data. She wants to display a reminder when an employee clicks a cell in the Contact Type column Which of the following should she use?
A) Header row
B) Table alert
C) Input message
D) Insert message

Accepted Answer

Input messages in Excel are used to display a message to the user when a cell is selected. Martha can use this feature to show a reminder when an employee clicks a cell in the Contact Type column.

Quiz 2: Excel 2019