Preview

Aspen Falls Restaurant Essay Example

Good Essays
Open Document
Open Document
788 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Aspen Falls Restaurant Essay Example
Aspen Falls Restaurants

Project Description:
In this project, you will modify a workbook to track taxes generated by restaurants in the Aspen Falls area. To complete the project, you will enter and format data, create formulas and functions, create and format a pie chart and a clustered column chart, apply conditional formatting, use Find and Replace to edit data, and finally create page footers.

Instructions:
For the purpose of grading the project you are required to perform the following tasks: Step | Instructions | Points Possible | 1 | Start Excel. Download, save, and open the Excel file named Skills_eV1_Grader_CAP. | 0 | 2 | On the Taxes worksheet, center the title, Aspen Falls Restaurants, across cells D2:F2. | 2 | 3 | In cell J3, type Annual. In cell J4, type Federal Taxes. Center the text in each cell. | 4 | 4 | In cell J5, insert a formula that will add the numbers in cells F5:I5. Use the fill handle to copy the formula into cells J6 through J8. | 5 | 5 | In cell D2, apply the cell style Heading 1. | 3 | 6 | In cell J9, insert the SUM Function to total the values in the range J5:J8. Apply the Total cell style to the cell. | 3 | 7 | In cell C5, type Cafe after Giorno’s. In cell J2, type Tax Rebate and in cell K2, enter the value 3000 as the rebate amount. In cell K4, type After Rebate. | 4 | 8 | In cell K5, use an absolute cell reference to construct a formula that subtracts the rebate from the Annual Federal Taxes. Copy the formula down through cell K8. | 5 | 9 | Apply the accounting number format to the range F5:K9. | 3 | 10 | Select the nonadjacent ranges C5:C8 and J5:J8, and create a clustered column chart. | 4 | 11 | Change the fill color of the data series to Red, Accent 2. | 3 | 12 | Remove the legend and insert the title Annual Federal Taxes above the chart. | 5 | 13 | Reposition the clustered column chart so that the top left corner of the chart area aligns with the top left corner of cell E11. | 3 | 14 |

You May Also Find These Documents Helpful

  • Powerful Essays

    Nt1310 Unit 1 Assignment 1

    • 4963 Words
    • 20 Pages

    Tax = [(assessable income – deductions) x rate] – offsets ( note there is a order for these) –payg(w) (at the very end +- any levies)…

    • 4963 Words
    • 20 Pages
    Powerful Essays
  • Good Essays

    CGS 2531 Notes Ch. 1-5

    • 2861 Words
    • 11 Pages

    Right click the letter or row number for which you want to insert a new column to the left or a new row above……

    • 2861 Words
    • 11 Pages
    Good Essays
  • Powerful Essays

    POW 9 IMP3

    • 1192 Words
    • 5 Pages

    Create 2 formulas, one that will calculate the last number in terms of the first number and a constant increase in rate as well as the total amount of numbers. The second formula will add ass of the resulting numbers from the first formula together after the last number is calculated.…

    • 1192 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    For the purpose of grading the project you are required to perform the following tasks:…

    • 639 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    It210-Appendix G

    • 436 Words
    • 2 Pages

    Write “The purpose of this program is to calculate tax for a given salary range”…

    • 436 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Com Prob 3

    • 226 Words
    • 5 Pages

    Copyright © 2015 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of…

    • 226 Words
    • 5 Pages
    Satisfactory Essays
  • Good Essays

    Type the PLUS sign (+) into cell C1 after the cell reference A1 (e.g. =A1+).…

    • 2823 Words
    • 12 Pages
    Good Essays
  • Satisfactory Essays

    Chapter 6 Template

    • 378 Words
    • 2 Pages

    (b) tax rate ¼ 5.5% 5–17a. Form 940, line 8, ¼ $632.80 Chapter 6 Problems 6–1a. federal tax levy, $583.46 6–3a. (a) payroll tax debit, $650.25 6–5a. (a) cash credit, $50,748.80 6–7a.…

    • 378 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    range B9:F9 and calculate the apartment complex totals in the range G5:G8. In cell G9, enter a grand…

    • 369 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    Ap Calculus

    • 2722 Words
    • 11 Pages

    | An Excel feature that generates and extends values into adjacent cells based on the values of selected cells…

    • 2722 Words
    • 11 Pages
    Powerful Essays
  • Good Essays

    the popurse of the IRS

    • 305 Words
    • 2 Pages

    How is an individual's tax liability calculated? First obtain a Form 1040 or 1040ez with instruc-tion. Two separate documents that can be downloaded from the IRS website. Total income in-cludes wages, salary and tips. Calculate gross income, allow deductions. Then look up your standard deduction on Form 1040. Choose whichever of these two figures is largest and subtract it from your adjusted gross income. Calculate your taxable income. Multiply $3,800 by the number of exemptions. Calculate total tax this is done by multiplying your tax rate by your taxa-ble income. Your tax rate is determined by your taxable income and can be found in your In-structions book.…

    • 305 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Lab Report

    • 316 Words
    • 2 Pages

    Create a data table containing a tally of the number of cells observed in each of the following stages:…

    • 316 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    FEDERAL INCOME TAX FORMULA Gross Income - Above the Line Deductions____ Adjusted Gross Income - Itemized or Standard Deduction - Exemptions_________________ Taxable Income x Applicable Marginal Tax Rates for Each Bracket Tax Liability - Tax Credits_________________ = TAX OWED ABRIDGED INCOME TAX ACCOUNTING I. Gross Income [§ 61] — A. Wages, Salaries, and Tips B. Interest Income C. Dividend Income D. Other (Net) Income—Reduced by Deductible Expenses 1.…

    • 257 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    6. In the “Cum Sum” column, calculate the cumulative sum (running total) of the subtotal count. You need to write a nested formula that combines IF, Sum, and ISNUMBER functions.…

    • 432 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Both documentaries hugely diverge in their purposes and intent as Expedia Travel: New York clearly aims to inform and persuade their audience to travel to New York City evidenced through its filming of famous landmarks to sell the city. This contrasts to Lonely Planet: New York whose purpose is to entertain through its storytelling components as it is intended for viewing as part of a series. Despite this, they both present New York City to the audience, no matter how different the…

    • 83 Words
    • 1 Page
    Satisfactory Essays