i$.$

Format the results to show zero decimal places.

j$.$

Type Smyrna in cell B$21$

Use DSUM to summarize mailing data.

a$.$

Select the Mailings sheet and note that number mailed is located in the third column and response data is in

the fourth column.

b$.$

Click the Criteria sheet tab. Select cell B$2$ and type lan$*$ to select data for the Landscape Design

department.

c$.$

Type law$*$ in cell B$5$ for the Lawn & Maintenance department.

d$.$

Type pat$*$ in cell B$8$ for the Patio & Furniture department.

e$.$

Click the Mailing Stats sheet tab and select cell B$7.$

f$.$

Use DSUM with the range name Responses as the Database argument. Type $3$ for the Field argument $($#

Mailed column$),$ and enter an absolute reference to cells $B1$:$B2$ on the Criteria sheet as the critoria

argument.

g$.$

Copy the formula to cell C$7$ and edit the Field argument to use the fourth column $($# Responses$)$

h$.$

Use DSUM in cells B$8$:C$9$ to calculate results for the two remaining departments.