Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In this scenario, you own a small cheese shop. You're creating a spreadsheet that customers can use to order cheese by the pound. You've already

In this scenario, you own a small cheese shop. You're creating a spreadsheet that customers can use to order cheese by the pound. You've already built and formatted the general structure of the spreadsheet. Now you need to add formulas to make the spreadsheet functional. Perform the following tasks:
In D7, use arithmetic operators to find the cost of gouda ordered by multiplying C7 by cell I7(i7, not seventeen). Once this formula is created, use the fill handle to copy it to D8:D13.
Use AutoSum to calculate the total pounds of cheese ordered in C14 and the total cost of the order in D14.
Use the fill handle to complete the list of cheese numbers. Muenster should be number 7.
Use functions to calculate the average price of a pound of cheese in I14, the lowest price in I15, and the highest price in I16.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business and Administrative Communication

Authors: Kitty o. locker, Donna s. kienzler

10th edition

77830105, 978-0077830106, 978-0073403182

More Books

Students also viewed these General Management questions