Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help me set up this worksheet in excel Plan and Prepare an Orders Summary Workbook Plan and prepare a worksheet with the information shown

please help me set up this worksheet in excel image text in transcribed
Plan and Prepare an Orders Summary Workbook Plan and prepare a worksheet with the information shown in Figure U1.3. Apply formatting of your choosing. Save the completed worksheet and name it U1-OrdersSumm. Print and then close U1-OrdersSumm. Figure U1.3 Activity 1 Prepare a weekly summary of orders taken that itemizes the products coming into the company and the average order size. The products, order amounts, and average order sizes are as follows: Black and gold wall clock: $2,450 worth of orders, average order size of 125 units Traveling alarm clock: $1,358 worth of orders, average order size of 195 units Waterproof watch: $890 worth of orders, average order size of 90 units Dashboard clock: $2,135 worth of orders, average order size of 230 units Pyramid clock: $3,050 worth of orders, average order size of 375 units Gold chain watch: $755 worth of orders, average order size of 80 units In the worksheet, calculate the price per unit for each item and total the amount of the orders. Sort the data in the worksheet by the order amount in descending order

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_2

Step: 3

blur-text-image_3

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

Accounting The Ultimate Guide To Accounting Principles

Authors: Greg Shields

1st Edition

1722964839, 978-1722964832

More Books

Students also viewed these Accounting questions

Question

Who do you know that is a member of a microcultural group?

Answered: 1 week ago