Scribd Logo
Upload

Welcome to Scribd!

  • 146 views

    Edt321 Excel Hilton

    Uploaded by

    api-352689330
    Here are the steps to apply to the employee information sheet: 1. I merged the cells for the spreadsheet title. 2. I changed the fill color of the title cells and added borders. 3. I formatted the expenses numbers as currency. 4. I froze the panes on the first two rows to keep the header visible when scrolling. 5. I used the AVERAGE formula to find the mean expenses for each item across the five months. 6. I used the SUM formula to find the total expenses for each month. 7. I used the SUM formula to calculate if the monthly expenses were over or under budget. 8. I used the SUM formula with PERCENT

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Edt321 Excel Hilton

    Uploaded by

    api-352689330
    146 views6 pages
    Here are the steps to apply to the employee information sheet: 1. I merged the cells for the spreadsheet title. 2. I changed the fill color of the title cells and added borders. 3. I formatted the expenses numbers as currency. 4. I froze the panes on the first two rows to keep the header visible when scrolling. 5. I used the AVERAGE formula to find the mean expenses for each item across the five months. 6. I used the SUM formula to find the total expenses for each month. 7. I used the SUM formula to calculate if the monthly expenses were over or under budget. 8. I used the SUM formula with PERCENT

    Original Title

    edt321 excel hilton

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Here are the steps to apply to the employee information sheet: 1. I merged the cells for the spreadsheet title. 2. I changed the fill color of the title cells and added borders. 3. I formatted the expenses numbers as currency. 4. I froze the panes on the first two rows to keep the header visible when scrolling. 5. I used the AVERAGE formula to find the mean expenses for each item across the five months. 6. I used the SUM formula to find the total expenses for each month. 7. I used the SUM formula to calculate if the monthly expenses were over or under budget. 8. I used the SUM formula with PERCENT

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    146 views6 pages

    Edt321 Excel Hilton

    Uploaded by

    api-352689330
    Here are the steps to apply to the employee information sheet: 1. I merged the cells for the spreadsheet title. 2. I changed the fill color of the title cells and added borders. 3. I formatted the expenses numbers as currency. 4. I froze the panes on the first two rows to keep the header visible when scrolling. 5. I used the AVERAGE formula to find the mean expenses for each item across the five months. 6. I used the SUM formula to find the total expenses for each month. 7. I used the SUM formula to calculate if the monthly expenses were over or under budget. 8. I used the SUM formula with PERCENT

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 6

    Monthly Expenses

    Item August September October


    Rent $500.00 $500.00 $500.00
    Car payment $225.32 $225.32 $225.32
    Car insurance $57.59 $57.59 $57.59
    Gas $27.54 $19.58 $18.74
    Groceries $174.21 $151.54 $91.85
    Spending $201.65 $90.57 $140.63
    Total $1,186.31 $1,044.60 $1,034.13
    Over/Under Budget -$78.10 $63.61 $74.08

    Budget
    Averag
    Percentage of
    Monthly
    Item Cost Expenses $500.00
    $450.00
    Rent $500.00 45.12% $400.00
    Car payment $225.32 20.33% $350.00
    $300.00
    Car insurance $57.89 5.22% $250.00
    $200.00
    Gas $25.00 2.26% $150.00
    Groceries $150.00 13.54% $100.00
    $50.00
    Spending $150.00 13.54% $0.00
    Total $1,108.21
    xpenses
    November December Average
    $500.00 $500.00 $500.00
    $225.32 $225.32 $225.32
    $57.59 $57.59 $57.59
    $26.87 $40.99 $26.74
    $142.01 $167.20 $145.36
    $204.56 $109.56 $149.39
    $1,156.35 $1,100.66 $1,104.41
    -$48.14 $7.55 $3.80

    Average

    00
    00
    00
    00
    00
    00
    00
    00
    00
    00
    00
    Be sure to apply the following requirements to this sheet
    1. Merge cells of the spreadsheet title
    2. Change the fill color and/or borders (different than conditional formatting #7)
    3. Change the expenses numbers to CURRENCY
    4. FREEZE PANES of the first two rows in the spreadsheet
    5. Use the AVERAGE formula to find the mean of all five months
    6. Use the SUM formula to find the total of each month
    7. Use the SUM formula to determine if you are over or under budget
    8. Use the SUM formula and PERCENTAGE format to find the percentage budgeted for each ex
    9. Use conditional formatting to determine which months were over budget
    10. Add a bar graph with labels to share the average amount spent each month
    Employee Information
    First Last SSN Work email
    Sarah Allen 017-52-9014 @ gmail.com [email protected]
    Lisa Dennis 234-75-2014 @ gmail.com [email protected]
    John Doe 123-45-6789 @ gmail.com [email protected]
    Tom Jones 987-65-4321 @ gmail.com [email protected]
    Jimmy Miller 789-56-4321 @ gmail.com [email protected]
    Jen Mullen 587-52-9641 @ gmail.com [email protected]
    Be sure to apply the following requirements to this sheet
    11. Sort LAST names by ascending alphabetical order
    12. Use the CONCATENATE formula to create an email address for each employee

    You might also like