$7.$ Apply the Orange, Table Style Medium $9$ table style to the Toledo table to use a format similar to other tables in the

workbook.

$8.$

Remove the record for Item ID B$428$ froma the table because the record is incomplete.

$9.$ Suong wants to calculate the total value of a specific type of tool. She has already entered the tool type in cell A$4.$ In cella

A$6,$ enter a formula using the DSUM function that specifies a structured reference to the entire Toledo table including the headers and the data $($Toledo$[$#All$])$ as the formula database. Use the Value field headera

$($Toledo$[[$#Headers$],[$Value$]])$ as the field to summarize. Use the values in the range A$3$:A$4$ as the criteria.

$10.$ Suong also wants to identify the number of items that need to be reordered. In cella B$6,$ enter a formula using the DCOUNTA function that specifies a structureda reference to the entire Toledo tablea $($Toledo$[$#All$])$ as the formula database.

Use the Reorder? field header a $($Toledo$[[$#Headers$],[$Reorder$?]])$ as