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

We Write Essays for Students

Tell us about your assignment and we will find the best writer for your paper

Get Help Now!

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 AMAZON PAPERS 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 Wise Papers.

Welcome to originalessaywriters.com, our friendly and experienced essay writers are available 24/7 to complete all your assignments. We offer high-quality academic essays written from scratch to guarantee top grades to all students. All our papers are 100% plagiarism-free and come with a plagiarism report, upon request

Tell Us “Write My Essay for Me” and Relax! You will get an original essay well before your submission deadline.