Taxation and Home Tab

Only available on StudyMode
  • Download(s) : 30
  • Published : September 27, 2012
Open Document
Text Preview
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.Hint: With the range selected, on the Home tab, in the Alignment group, click the Merge & Center button.| 1| 3| In cell J3, type Annual. In cell J4, type Federal Taxes. Center the text in each cell. Hint: To center the text, on the Home tab, in the Alignment group, click the Center button.| 2| 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.Hint: To insert the formula, in cell J5, type =F5+G5+H5+I5 and then press ENTER. To copy the formula, use the fill handle in the bottom right corner of the cell.| 2| 5| In cell D2, apply the cell style Heading 1.Hint: With the cell selected, on the Home tab, in the Styles group, use the Cell Styles button.| 1.5| 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.Hint: With the cell selected, on the Home tab, in the Editing group, click the Sum button.| 1.5| 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. | 2| 8| In cell K5, use an absolute cell reference to construct a formula that subtracts the rebate from...
tracking img