$1.$ The third calculation Michael wants to make is to identify the number of replacement items, which are items in poor condition. Calculate the number of items in poor condition as follows:

a$.$ In cell L$4,$ begin to enter a formula using the DCOUNTA function.

b$.$ Use a structured reference to the Office table $($beginning in cell A$7)$ including the headers and the data as the formula database.

c$.$ Use a structured reference to the Condition field header as the field to count.

d$.$ Use the values Michael set up in the range L$1$:L$2$ as the criteria.