Develop an Excel spreadsheet from scratch that incorporates the key features that you have learned.

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:

- 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.

Solution PreviewSolution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

    By purchasing this solution you'll be able to access the following files:

    50% discount

    $50.00 $25.00
    for this solution

    or FREE if you
    register a new account!

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available Computer Science - Other Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Upload a file
    Continue without uploading

    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats