(Answered) How to create a mircrosoft excel sheet to include the

Accounting

How to create a mircrosoft excel sheet to include the folowing;

Details:

- Organization size: 30
- Award Ceremony Date: December 5th
- Two Types of Awards: Performance Award and Special Commendation Award
- Performance Awards can be given in the range of $500 - $5000
- Special Commendation Awards can be given in the range of $500 - $2000

Data to include:

- List of all employees receiving awards (should be at least 50% of employees)
- Type of award each employee will receive
- Amount of award each employee will receive
- Percentage of overall budget that each employee's award will represent
- Percentage of overall budget that each type of award will represent
- Column totals using formulas

Features of Excel to Include:

- Use of formulas for adding and computing percentages
- Changes to font size and style, as appropriate for impact
- Label on worksheet tab at bottom
- Use Headings/Titles for each category listed
- Format currency to zero decimal places
- Adjust width of columns or wrapping the text within cells to avoid overlap of adjacent cells by long text entries
- Use color to emphasize important aspects of the sheet
- Use borders to separate sheet into appropriate sections
- Charts to show data

View complete question

Accounting Basics, Accounting

Category:- Accounting Basics
Reference No.:- M92567945
Price:- $10

Verified Expert

Priced at $20 Now at $10, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Accounting Basics

Question purpose of assignmentthis assignment is critical

Question: Purpose of Assignment This assignment is critical for students to gain a fundamental understanding of management's and auditor's responsibility for detecting errors, material fraud, and illegal acts. This assig ...

Question please discuss the validation or failure of the

Question: Please discuss the validation or failure of the theory of efficient markets and behavioral finance given the "Credit Crunch" or global financial crisis of 2007-2009. Your initial post must be in your own words, ...

Question - ross company had the following inventory at the

Question - Ross Company had the following inventory at the end of the year: Quantity Unit Price Cost Market Valves: Model Q 180 $11 $9 Model R 150 10 12 Model S 120 7 9 Gaskets: Model Alpha 60 100 105 Model ...

Question - hardcastle ltd had sales of 3 000 000 and net

Question - Hardcastle Ltd. had sales of $3 000 000 and net operating income of $900 000. Operating assets during the year averaged $1 500 000. The manager of Hardcastle is considering the purchase of a new machine which ...

Question - effective financial reporting depends on sound

Question - Effective financial reporting depends on sound ethical behavior. Financial scandals in accounting and the businesses world have resulted in legislation to ensure adequate disclosures and honesty and integrity ...

Question one typically thinks of c corporations as large

Question: One typically thinks of C corporations as large companies. These corporations are publicly traded and are required to be structured as C corporations. However, not all C corporations are large; many are small, ...

Exercise - evaluation of purchase options sosa excavating

Exercise - Evaluation of Purchase Options Sosa Excavating Inc. is purchasing a bulldozer. The equipment has a price of $00,000. The manufacturer has offered a payment plan that would allow Amos to make 10 equal annual pa ...

Question - phil goode will receive 112000 in 19 years his

Question - Phil Goode will receive $112,000 in 19 years. His friends are very jealous of him. If the funds are discounted back at a rate of 14 percent, what is the present value of his future "pot of gold"?

Question - owen companys unadjusted book balance at june 30

Question - Owen Company's unadjusted book balance at June 30, 2016 is $12,160. The company's bank statement reveals bank service charges of $90. Two credit memos are included in the bank statement: one for $1,250, which ...

Question - crane company had 590000 shares of common stock

Question - Crane Company had 590000 shares of common stock outstanding on January 1, issued 890000 shares on July 1, and had income applicable to common stock of $2930000 for the year ending December 31, 2018. Earnings p ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Accounting Basics Expert