Taxation and Home Tab
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
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