Question: a- Using MS Excel Find the largest quantity of items ordered from ABTech b- Using MS Excel Find the number of orders with A/P terms
a- Using MS Excel Find the largest quantity of items ordered from ABTech b- Using MS Excel Find the number of orders with A/P terms less than 25 months c- If purchase quantities of 25 units or higher are found to be large orders, and orders less than 25 are considered to be small, what IF function should be entered in H4 to be copied to H5:H10 to calculate each order's size? Write the function in the excel sheet. d- Which Database functions calculates the count of purchase orders made by ABTech? Write the function in the excel sheet. e- Which Database functions calculates the count of purchase orders made by ABTech for large size orders? Write the function in the excel sheet. f- Which Database functions calculates the total quantity ordered in large size? Write the function in the excel sheet. g- Which Database functions calculates the total cost charged to ABTech for large size orders? Write the function in the excel sheet. h- Which Database functions calculates the average item cost ordered by ABTech
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
