July 10, 2019
July 10, 2019

# For questions 1-7 you MUST leave your formula in the cell in column

For questions 1-7 you MUST leave your formula in the cell in column

Question
 BUS370 Extra Credit I For questions 1-7 you MUST leave your formula in the cell in column C to receive credit. Answers without the correct formula will not receive credit. Turn in your completed Excel file to the Extra Credit I Dropbox by the deadline. For problems 1-5, use the data set on the “Warehouse Data” tab Answer: 1 Use the SUM() formula to calculate the total number of cartons in the data set. 2 Use the AVERAGE() formula to calculate the average number of cartons per PO in the data set. 3 Use the COUNT() formula to calculate the number of POs in the data set. 4 Use the SUMIF() formula to calculate the total number of cartons for just the Vendor NIKE in the data set 5 Use the COUNTIF() formula to calculate the total number of POs where the Zone is SHOES in the data set 6 Use the LEN() formula to determine how many characters are in cell B20. Trailer DART 63200 has arrived 7 Use the MID() formula to get the data from cell B20 and then just display the trailer number 63200. 8 Use Excel’s Conditional Formatting functionality to make cell C24 turn green if a number greater than 50 is entered and red if a number 50 or lower is entered.

For questions 1-7 you MUST leave your formula in the cell in column

PLACE THIS ORDER OR A SIMILAR ORDER WITH homework handlers TODAY AND GET AN AMAZING DISCOUNT The post Use the COUNTIF() formula to calculate the total number of POs where the Zone is SHOES in the data set appeared first on homework handlers .

## “Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!” The post Use the COUNTIF() formula to calculate the total number of POs where the Zone is SHOES in the data set appeared first on Homework Handlers.

Use the COUNTIF() formula to calculate the total number of POs where the Zone is SHOES in the data set was first posted on July 10, 2019 at 2:59 am.  