Workbook Quiz - Module 6

To expand data views using the Outline feature, select the rows with similar data by clicking and dragging on the rows numbers to the left of your data. Then click on Data tab > Group > - sign.

• True

• False

Cedric has a table listing customer data, including the date of their purchase. He can sort the Date data in descending order to quickly find customers with recent purchases.

• True

• False

To outline data, select the rows or columns you want to group, and then click the Group button on the Data tab.

• True

• False

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.

Which of the following buttons on the Home tab can you use to insert a row in a table?

• Format as Table

• Insert & Merge

• Insert

• Add Row

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 menu.

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

• Outline

• Summary

• Table

• Dashboard

Kylie created a table with a Skill Number column that contains values from 400 to 500. What type of filter can she use to select records with skill numbers less than 450?

• Text filter

• Top Values filter

• Number filter

• Form filter

Shelley creates a table containing the marks of Language Arts students in her class with these columns: Names of Students and Marks. She now wants to see the names of students who scored exactly 60 marks. What will Shelley do after selecting the column header arrow for the column with heading Marks?

• Check the box beside Select All and the number 60 and click OK.

• Uncheck (Select All), select the box beside the number 60 and click OK.

• Select Number Filters > Between > (Enter value 0 in dialog box on top) > (Enter value 60 in dialog box below it) > OK.

• Select Number Filters > Less Than or Equal To > (Enter value 0 in dialog box on top) > (Enter value 60 in dialog box below it) > OK.

Adele wants to filter a Customers table to show customers in Denver or customers with invoices over $2500. What type of filter should she use?

• Number AutoFilter

• Advanced filter

• Text with wildcard filter

• Date AutoFilter