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