Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How to create a mircrosoft excel sheet to include the folowing; Details: - Organization size: 30 - Award Ceremony Date: December 5th - Two Types

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

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

Step: 3

blur-text-image

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

Computer Accounting

Authors: Donna Kay

14th Edition

007762453X, 9780077624538

More Books

Students also viewed these Accounting questions

Question

2. To store it and

Answered: 1 week ago