You Are Eligible For 15% Discount This Month!
Topic: Management assigned you the task of organizing an award ceremony for your organization. They have asked you to organize data into a spreadsheet so they can easily view and manipulate the award types and amounts before decisions are made. All of this information should be fictitious. You are required to create a spreadsheet to track all of the following items: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 – $2000Data 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 formulasFeatures 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