Move the Pie chart in the Income Statement worksheet to cell D3 on the Income Sources worksheet

10. Create a formula using arithmeticWithout using parentheses, enter a formula incell F4 that determines the Annual Net CashFlow for the grant by taking the value in cellB4, subtr

Move the Pie chart in the Income Statement worksheet to cell D3 on the Income Sources worksheet

10. Create a formula using arithmeticWithout using parentheses, enter a formula incell F4 that determines the Annual Net CashFlow for the grant by taking the value in cellB4, subtracting the product of cell B4multiplied by cell D4, and then subtractingthe value in cell E4.11. Create a formula using the SUMIn cell B10, create a formula using the SUMfunction to total the values in the range12. Merge and center cell contents.EX4858Merge and center the contents of cells A2:F2.13. Rename a worksheet.EX4859Rename the Sheet1 worksheet with the newnameBoard.14. Change the color of a worksheettab.EX4967Change the color of the Current Grants sheettab to Dark Red (Standard Colors section,column 1).15. Apply a chart style.EX4969Apply chart Style 13 to the chart.16. Move a chart to differentworksheet.EX4980Move the Pie chart in the Income Statementworksheet to cell D3 on the Income Sourcesworksheet.17. Create a formula using relativecell references.EX4984In cell B11, enter a formula using relativecell references that adds the values in rangeB4:B10.18. Use the Fill handle to copy aformula.EX4985Use the fill handle to copy the formula in cellB11 to cells C11 and D11.19. Insert a 3-D Pie chart.EX5055Insert a 3-D Pie chart into the worksheet,based on range A4:B7.20. Move a chart to a chart sheet.EX5311Move the Clustered Bar chart to a chartsheet; accept the default chart sheet name.21. Enter a number into a cell.EX5331Enter the number5000in cell D7.

Video liên quan