Access over 20 million homework & study documents
search

ECornell Preparing Your Data for Analysis Spreadsheet

Content type

User Generated

Subject

Accounting

School

eCornell

Type

Worksheet

Rating

Showing Page:
1/5

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/5

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/5

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 5 pages?
Access Now

Unformatted Attachment Preview

DYS541: Getting Started with Spreadsheet Modeling and Business Analytics Dyson, Cornell SC Johnson College of Business Course Project Part One: Preparing Your Data for Analysis Instructions: We have just opened a bakery, Cornell Cupcakes, that produces cupcakes that customers can customize to their preference. After collecting data from our first successful month, we need to clean up the following worksheets so we can analyze our performance. Please look at the following instructions and use them as a guide to clean up and organize the data. Good luck! On the "July Orders" worksheet, insert a row at the top of the worksheet and add the title "July Cornell Cupcake Orders" in bold by merging Columns A:E. Adjust the column widths, use borders, format prices, and fill in the order numbers in ascending numerical order. Add a custom header by typing your name and company name in the top right corner. Then use the function buttons to insert the date and page number underneath your name and the company name. Using the pricing scheme table on the right, calculate the total cost per order. The cost of topping is calculated per cupcake (e.g. there is a toppings fee of $0.50 per topping per cupcake). Insert formulas to calculate the total amount of cupcakes ordered in Cell B15 and the total cost of all orders in Cell D15. Be sure to use relative references. Italicize B15 and D15. Cornell Cupcakes is piloting a delivery service. In Cell E15, display how many orders used the delivery serv ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Great content here. Definitely a returning customer.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4