ons COUNT(valuel,value2.,...) COUNTIF(range, criteria) MAX(numberl, mumber2,...)
ID: 2816543 • Letter: O
Question
ons COUNT(valuel,value2.,...) COUNTIF(range, criteria) MAX(numberl, mumber2,...) MIN(number 1, mimber2. ) SUM(numberl, nmber2,...) SUMIF(range, criteria, sum range) ROUND(number.num_digits) o logical)i OR(logicall, logical2,... AND(logicall, logicaiz..) IF(logical test,value if true, value if false) NOT(logical) AVERAGE(number1, mamber2.... You are treasurer for the Os0 Excel Users Group and are charged with the job of ordering vour first meeting of the quarter. You need to calcul from 10 people to 1000 people. Punch costs are made up of the cost of purchasing the punch and the cost of having the punch delivered (shipping costs). Shipping costs vary based on the total weight of a shipment. You have developed a workbook with two worksheets Units and Price. You will use the Price worksheet to summarize the costs for each group size. You have put the following information ate the costs for a series of group sizes ranging in the Units worksheets: Each person drinks an average of 3 cups of punch-units!B2 There are 16 cups per gallon-units!B3 .A gallon of punch weighs 8.22 pounds- units!B4 Shipping costs of shipments less than 1000 pounds are $2.00 per pound. - units!B5 Shipping costs of shipments of 1000 pounds or more are $1.25 per pound-units!B6 The price of a 5 gallon jug of punch is $2.50- units!B7 . Quiz 2Explanation / Answer
1.
=Units!B7/5
2.
=Price!B2*Units!$B$2/Units!$B$3
3.
=Price!C2*Units!$B$8
4.
=Price!C2/Units!$B$4*0.95
5.
=Price!D2+Price!E2
6.
Price!D2/Price!F2
7.
=Price!F2/(Price!C2*Units!$B$3)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.