Use the COUNTIF() formula to calculate the total number of POs where the Zone is SHOES in the data set

/in /by

Contents hide
1 For questions 1-7 you MUST leave your formula in the cell in column
1.1 Save your time - order a paper!

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

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

 

PLACE THIS ORDER OR A SIMILAR ORDER WITH homework handlers TODAY AND GET AN AMAZING DISCOUNT

get-your-custom-paper

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 .