Spreadsheet to Select Suppliers$)$

Download the data file. $($See the attachment in $.$xIsx format$)$

Read and follow the instructions as listed below:

My expectation on this Business Software Assignment#$1$ are listed below:

for Q$1-$Identify the Suppliers who provide On$-$Time Delivery

a Pivot table named as On$-$Time Delivery in which contains Vendor Names and Average Delivery Days and is sorted ascending by Average Delivery Days. $($Hint: you must find out the "delivery days" from the data set provided before creating the pivot table to solve this problem$)$

Identify the best supplier who provides on$-$time delivery.

for Q$2-$ Identify suppliers who provide The Best Accounts Payable Terms