W6 18/04

Mia inserted a plain table in a worksheet. She wants to change the black borders and white fill to make the table more attractive and easier to use. What is the quickest way for her to change the appearance of the table?

• Change the shading and border colors of the cells

• Filter the table

• Change the table style

• Convert the table to a range

A(n) ___ is a range of data Excel treats as a single object that can be managed independently from other data in the workbook.

• Table

• Outline

• Summary

• Dashboard

Josh wants to insert a column in an Excel table to add the values from two other columns. Which of the following methods can he use to insert a table column?

• Click a column header and then click the Insert button on the Home tab

• Right-click a column header, click Format Cells on the shortcut menu, and then click Add New Column

• Click a column header, click the filter arrow, and then click Insert

• Double-click a column header and then click Insert on the shortcut

How can you hide the filter buttons in a table?

• Click the Filter Button check box in the Table Styles Options group

• Clear the filters from the table

• Right-click a filter button and then click Remove

• Click a filter button and then click Hide

Tracy created a table where the odd and even-numbered columns are formatted differently. She wants to remove this formatting. What setting should she change?

• Banded columns

• Calculated columns

• Odd/Even columns

• First column

Helen wants to resize slicer buttons to exact dimensions. What can she use to do so?

• Slicer Settings button in the Slicer group

• Height and Width boxes in the Buttons group

• Slicer Styles gallery

• Slicer Size box in the Slicer group

Leigh-Ann used a slicer to filter a table on the Department field. Which of the following buttons should she click on the slicer to redisplay data for all the departments?

• Multi-Select button

• Clear Filter button

• Slicer Settings button

• Slicer Styles button

Will has a table that includes a field with four product types. What kind of filter would be best to apply to the table?

• Date filter

• Custom number filter

• Slicer

• Advanced filter

In the formula =[SalesPrice]*.05, what do you call [SalesPrice]?

• 3-D reference

• external reference

• structural reference

• absolute reference

In the formula = SUBTOTAL(1, Customers_Table(ID]), what does the 1 refer to?

• the first field to analyze

• the number of the column to analyze

• the number of values to analyze

• the number of the function to use