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 |