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