Question: Instructions are on the left ACCT 201 Ch 5 Excel Activity Instructions M16 X B D G date of sa item Account Mana list_price cost

Instructions are on the left

ACCT 201 Ch 5 Excel Activity Instructions M16 X B D G date of sa item Account Mana list_price cost quantity sold 3. Calculate totals in the new columns, H, 1, J 10/1/2020 885-305SN Erik Lensherr 57.99 37.55 30 10/1/2020 885-96SN > Go to the end of the data: Ctri+! curl+ Erik Lensherr 13.83 8.18 186 10/1/2020 2115-128SN Jean Gray 12.98 8.08 161 >In A38 type Total 10/2/2020 2115-960BAC Jean Gray 4.87 3.1 629 Using the sum function, total column H, 16 10/3/2020 885-96SN Erik Lensherr 13.83 8.18 101 >Copy the formula to columns | and ) 10/3/2020 885-305PC Erik Lensherr 57.99 36.1 653 >Check figures 10/3/2020 2115BNBOL |Jean Gray 4.15 2.52 169 Sales revenue 286,273.83 10/4/2020 885-96SN Erik Lensherr 13.83 8.18 191 Total cost 181,866.9 10 10/4/2020 885-96SN Erik Lensherr 13.83 8.18 207 Gross profit 106,405.93 11 10/5/2020 885-305PC Erik Lensherr 57.99 36.1 132 Because this is a table, note that the drop-down error provides options to view other types of formulas. 12 1075/2020 885-224PC Erik Lensherr 24.4 15.68 246 13 10/5/2020 2115-1280BAl Jean Gray 12.98 8.29 685 14 10/8/2020 885-96NI Erik Lensherr 13.83 8.95 216 . Filter by Account Manager 15 10/8/2020 885-224SN Jean Gray 24.4 14.22 698 > Navigate to A1 Account Manager 16 10/9/2020 885-305SN Erik Lensherr 57.99 37.55 315 Select the drop-down arrow 17 10/9/2020 885-96PC. Erik Lensherr 13.83 8.89 759 Sort A to Z 18 10/10/2020 885-96PC Erik Lensherr 13.83 8.89 374 19 10/10/2020 2115-128PC Jean Gray 12.98 8.46 268 5. Create a new sheet for Charles Xavier 20 10/11/2020 2115-128PC Jean Gray 12.98 8.46 333 In the sheets bar at the bottom right click on Sales Data sheet 21 10/12/2020 2115-96BNBC Charles Xavier 4.87 3:16 826 131 Select Move or Copy 22 10712/2020 885-224MI Erik Lensherr 24.4 15.67 23 10/15/2020 878AE Charles Xavier 3.29 2.27 846 Select (move to end) 24 10/15/2020 2115-128SN Jean Gray 12.98 8.08 301 Check the box Create a copy 25 10/16/2020 2115-960BAC Charles Xavier 4.87 3.1 387 Rename the new sheet (idea: Sales Data Xavier) 26 10716/2020 2115-128BNBI Jean Gray 12.98 8.2 307 27 10/17/2020 885-305PC Charles Xavier 57.99 36.1 846 3.29 892 6. Delete rows in the new sheet for Erik and Jean 28 10/17/2020 2115-96SN Jean Gray 4.87 57.99 470 Highlight rows 2:37 23 10/18/2020 885-305PC Jean Gray 36.1 30 10/18/2020 2115-128PC Jean Gray 12.98 8.46 943 Delete - Make sure you delete the entire row and not just the data 31 10/22/2020 2115-128PC Charles Xavier 8.46 623 by selection the row numbers, the entire row will be grayed. 32 10/23/2020 87SAE Charles Xavier 3.29 2.27 487 The total row will move to row 12 and the amounts will change. 33 10/25/2020 878AE Charles Xavier 3.29 2.27 501 54 10/25/2020 2115-1280BAI Charles Xavier 12.98 8.29 999 12.98 561 . Calculate Charles' sales commission at 6% of total sales 35 10/29/2020 2115-1280BAI Charles Xavier 8.29 36 10/30/2020 Z115-96DBAC Jean Gray 4.87 3.1 566 In A13 type Commission Rate 37 10/31/2020 878AE Charles Xavier 3.29 2.27 612 In A14 type Commission 38 In H13 enter 69% 39 In H14 calculate Charles Xavier's commission for the month. 40 Format the numbers with % and $ Sales Data

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

(10pt) Suppose that you know a MAC value X and the key K that was used to compute the MAC, but you do not know the original message. (a) (8pt) Show that you can construct a message M that also has...

Instructions are on the left ACCT 201 Ch 5 Excel Activity Instructions M16 X B D G date of sa item Account Mana list_price cost quantity sold 3. Calculate totals in the new columns, H, 1, J 10/1/2020...

Tax return information You own a t-shirt screen printing company called Back the Pack. Back the Pack operates as a regular Corporation under Subchapter C of the Internal Revenue Code. Back the Pack...

Beg TB cycie Path, Inc. went into business as a corporation in early 2017 For the first few years, the corrany provided bicycle rental and repair services only (no merchandise Dung 2020, the company...

Instructions Beg TB Events Grid Inventory J-Es Adj TB Fin St Beg TB 3 Cycle Path, Inc. went into business as a corporation in early 2017. For the first few years, the company provided bicycle rental...

I really need an answer for module 3 entries (June 17-30) and midterm evaluation and final evaluation. I need them asap please help. Zacks Bike Hut Level II 1st Web-Based Edition Introduction Page 1...

June 1 Signed a 3 year 7.1% , $210000 note payable with First Bank. June 1 Purchased 3100 GPS units on credit from Navistar for $35.5 per unit. June 1 Issued 5,000 shares of common stock for $10 per...

Need help with the transaction set. Journal & ledgers ASAP OPERATING INSTRUCTIONS Introduction After you register for Seaside Marina, you will receive an email from Ivy Software containing three...

Do the following scenarios correctly describe income limitations on credits for the year tax 2020? Scenario 1- * Ahead of the household taxpayer has 3 qualifying dependents, ages 6, 9, and 19. *...

Dailey Company at December 31 has cash $40,000, noncash assets $200,000, liabilities $110,000, and the following capital balances: Dickinson $90,000 and Meierhoff $40,000. The firm is liquidated, and...

Depository institutions, non - depository institutions, and commercial banks? Group of answer choices are all financial intermediaries. offer the same kinds of financial services to the public. have...

What is a dominant strategy equilibrium in the game theory under microeconomics? Can you explain how to find the dominant strategy equilibrium by providing an example? How do you know if there is no...