Question: -Each instrument will either be sold, donated, or thrown away based on the slling price. In cell A12, enter the label What To Do Table

-Each instrument will either be sold, donated, or thrown away based

-Each instrument will either be sold, donated, or thrown away based on the slling price. In cell A12, enter the label What To Do Table and format it as as bold. Starting in cell A13, create a VLOOKUP table based on the following criteria

Sale Price What To Do

under $100 Throw Away

$100 - $499 Donate

$500 and above Sell

-In Column E, enter the label What To Do and format the label as bold. Enter formulas that use the VLOOKUP function to display what to to do with each instrument

MUSIC SALE- Saved to OneDrive Autosave Formulas Data Review View Help Tell me what you want to do File Home Insert Draw Page Layout Define Name Use in Formula Create from Selection Trace Precedent Trace Dependen Remove Arrows Name Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Used Time* Reference* Trig Functions Manager Function Defined Names Function Library A13 1Used Equipment Inventory 3 Instrument 4 Piano 5 Saxophone 6 Drums 7 Electric Guitar 8 Flute 9 Violin 10 Original Price $2,500 $275 $789 Condition Selling Price $1,500 $110 20% $157.80 30% $136.80 $245 $345 12 13 16 18 19

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!

Amalgamated Fenderdenter's sales are $10 million. The company spends $3.5 million for purchase of direct materials and $15 million for direct Labor, overhead is $3.5 million and profit is $500,000....

INTRODUCTION The information below will allow you to prepare the 2012 federal tax return for Bill and Joyce Schnappauf. The information is provided in three phases, which correspond to the three...

Tax Return #3Schedule A John and Susie Ryan are married and file a joint return. John's social security number is 412-34-5670 and his date of birth is May 12, 1976. Susie's social security number is...

I attached my assignment. can someone please help me Joyce writes childrens books for a variety of publishers. She has been selfemployed since 2007. As a freelance writer, Joyce incurs costs...

Please solve this Excel spreadsheet using the directions! Thank you so much! Directions: Excel Spreadsheet: The manager of Paco's Dog Treats, Inc. imported inventory data. This data must be cleansed....

Joe Jay purchased a new home with a $260,000 loan. He decided touse Loyal Bank for his mortgage and the bank required him to putdown 20%. The monthly payment for the 6.50% 25- year mortgage...

In our capital budgeting examples, we assumed that a firm would recover all of the working capital it invested in a project. Is this a reasonable assumption? When might it not be valid?

Payroll accounting positions typically have a higher pay range than other accounting clerk positions because the payroll clerk must come to work early every day the payroll clerk has a greater work...

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

The debate over convergence and divergence in human resource applications internationally.

The nature and importance of the global marketplace.

The role of human resources in providing services to support internationalisation.