b$.$ Add a new sheet to the worksheet titled Accts$-$Payable$-1$erms

c$.$ Add a title starting in Al called Best Accounts Payable Terms

d$.$ Add column titles to A$3$ through C$3$ that are Vendor No$.,$ Vendor Name, and Best $\frac{A}{P}$ terms

e$.$ Starting in A$4$ in the Vendor No$.$ column key $1$ and then in A$5$ key Vendor No$.$ Alternate down the column in numerical order with Vendor No$.$ A$18$ should have an $8$ entered in it$.$

f$.$ Starting in B$4,$ add the Vendor Name for Vendor No$.1($Hulkey Fasteners$).$ Add the rest of the vendor names in column $B$ parallel to the numbers in column $A.$

g$.$ Make cell C$4$ active and go to the formula button $($fx$)$ next to the formula bar and search for DMAX function. Make sure it is highlighted and select OK$.$ The DMAX function returns the largest number in the field $($column$)$ of records in the database that match the conditions you specify. You are going to figure out the best $\frac{A}{P}$ term which would be the highest.

h$.$ Database: is A$4$ to L$98$ on the Data sheet. Field: $9$ which comes from counting the cells to column heading of the cells you are trying to figure in the AcctsPayable$\_$Terms sheet. Criteria: the range of cells that contains the conditions you specify. The range includes a column label and one call below the label for a