last Do not open your exam until it is time to begin. You will have 20 minutes t

Question

last Do not open your exam until it is time to begin. You will have 20 minutes to complete this quiz. . Put away all books, papers, and calculators. Read each question carefully and fill in the answer in the space provided. Answers must be legible or they will be marked incorrect. Your neighbor won't be taking the . Do your own work. These questions are representative of those on an exam. exam for you. All questions are 3 points except as noted Logical Functions AND(logicall, Jogical2...) IF(logical test,value if true, value if false) NOT(logical) ORlogicall, logical2...) COUNT(valuel,value2,...) COUNTIF(range, criteria) MAX(numberl, mumber2, ...) MIN(numberl, number?,...) SUM(numberl, mumber2,...) SUMIF(range, criteria, sum range) ROUND(number.num_digits) Other Functions AVERAGE(numberl, mumber2 .. You are treasurer for the OSU Excel Users Group and are charged with the job of ordering punch for your first meeting of the quarter. You need to calculate the costs for a series of group sizes ranging 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 Price worksheet to summarize the costs for each group size. You have put the following information . You will use the 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 poundunits!B6 The price of a 5 gallon jug of punch is $2.50-units!B7 Quiz 2

Explanation / Answer

1. cost of 5 gallons of punch is $2.50 , so the formula should be used to find the cost pet gallon of punch is: =B7/5

2. As the question says 3 cups per person and total 10 people for case 1, the formula for calculating Gallons of punch required is: =B2*3/16

3. As the price per gallon of punch is $0.50, So the formula for purchase Price of punch in dollars is: =C2*($0.50)

4. As there are 8.22 pounds per gallon, The formula for total cost of shipping punch will be: =(C2*8.22)*($0.95)

5. The formula for Total cost of punch is: =SUM(D2,E2)

6. The formula for displaying the punch cost as percentage is: =(D2/F2)*100

7. The total cost of the cup is: =F2/(B2*3)

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.