Deneck. 2016 cho grade 3 Formas Data View Inet CU Car Dr Page Layout Ciarlight A- A ated O 2rQ Wys Cordon Del w AL Day of Orange Bloom Beach 1 1 City of Orange Blossom Beach Investment Portfolio he heart he CY www 1 18.00 3,596.00 14,50 2011, 4002336 . ww terre The prinde 11 Start Excel. Download and open the file named go16_xl_ch03_grader_3e_as.xlsx In cells B10 and C10, enter formulas to calculate totals for each column. In cell D5, construct a formula to calculate the % of Total Projected Investments for Pooled Investments by dividing the Projected Investments for Next Fiscal Year for Pooled Investments by the Total Projected Investments for Next Fiscal Year. Use absolute celi references as necessary, format the result in Percent Style, and Center the percentage. Fill the formula down through cell D9. Select the nonadjacent ranges A5:A9 and C5:09 as the data for a pie chart, and then insert a 3-D Pie chart. Move the chart to a New sheet named Projected Investments. For the Chart Title, type Projected Revenue. Format the Chart Title using the WordArt Style Fill: Orange, Accent color 1; Shadow and a Font Size of 32. Note, depending upon the version of Office being used, the style name may be Fill: Orange, accent color 1: Shadow Remove the Legend chart element, and then add the Data Labels chart element formatted so that only the Category Name and Percentage display positioned in the Center. Change the Font Size of the data labels to 12, and then apply Bold. Format the Data Series using a 3-D Format effect. Change the Top bevel and Bottom bevel to the last bevel style in the last row. Set the Top bevel Width and Height to 350 pt and then set the Bottom bevel Width and Height to 0. Change the Material to the third Standard Effect, Plastic. Display the Series Options, and then set the Angle of first slice to 100 so that the Pooled Investments slice is in the front of the pie. Select the Pooled Investments slice, and then explode the slice 10%. Change the Fili Color of the Pooled Investments slice to a Solid fill using Orange, Accent 6. Lighter 40%. Format the Chart Area by applying a Gradient fill using any Preset gradient style. Note, depending upon the version of Office being used the Gradient fill may be named Light Vanation - Linear Down. Format the Border of the Chart Area by adding a Solid line border using Orange. Accent 1 and a 5 at Width Display the Page Setup dialog box, and then for this chart sheet, Insert a custom footer in the left section with the file name, Display Sheet1 and rename the sheet as Investment Sources. Click in any blank cell to cancel any selections. In cell A12. type Goal: Increase Endowment Fund from 8% to 10% and then Merge & Center the text across the range A12:012. Apply the Heading 3 cell style. cell A13. type Goal Amount. Copy the range C6D6 to cell B13 Click cell C13, and then use Goal Seek to determine the projected amount of Endowment investments in cell B13 if the value in C13 is 10% Select the range A13:C13, and then apply the 20% - Accent4 cell style. In B13, from the Ceil Styles gallery, apply the Currency of cell style. From the Page Fetup dialog box, center the worksheet Horizontally, and then insert a custom footer in the left section with the file name. Ensure that the worksheets are correctly named and placed in the following order in the workbook: Projected Investments, Investment Sources. Save and close the document. Exit Excel. Submit the file as directed. - Hen Draw Page Layout Formulas Data Review View Home Insert X Cut Copy Paste Format Calibri Light 18 A- A Wrap Text B + Merge & Cer A1 fx City of Orange Blossom Beach A D Xof Total Projected Investments $ 5 Pooled Investments 6 Endowment 7 Investment Reserves 8 Special 9 Fiscal Apent Funds 10 Total Current Year Projected Investments for Next Investments Fiscal Year 28,809.8005 32,956,740 8,120,500 6,754,950 13,786,400 22,712,600 4,007,520 6,874,325 11,694,500 13,987.550 16 17 16 19 20 21 24 25 26 29 00 22 36 as 32 39 40 41 44 15 Sheet1 Start Excel. Download and open the file named go16_xl_ch03_grader_3e_as.xlsx In cells 810 and C10, enter formulas to calculate totals for each column. In cell D5, construct a formula to calculate the % of Total Projected Investments for Pooled Investments by dividing the Projected Investments for Next Fiscal Year for Pooled Investments by the Total Projected Investments for Next Fiscal Year. Use absolute cell references as necessary, format the result in Percent Style, and Center the percentage. Fill the formula down through cell 09. Select the nonadjacent ranges AS:A9 and C5:09 as the data for a pie chart, and then insert a 3-D Pie chart. Move the chart to a New sheet named Projected Investments. For the Chart Title, type Projected Revenue. Format the Chart Title using the WordArt Style Fill: Orange, Accent color 1: Shadow and a Font Size of 32. Note, depending upon the version of Office being used, the style name may be Fill: Orange. accent color 1: Shadow. Remove the Legend chart element, and then add the Data Labels chart element formatted so that only the Category Name and Percentage display positioned in the Center. * Change the Font Size of the data labels to 12, and then apply Bold. Format the Data Series using a 3-D Format effect. Change the Top bevel and Bottom bevel to the last bevel style in the last row. Set the Top bevel Width and height to 350 pt and then set the Bottom bevel Width and Height to 0. Change the Material to the third Standard Effect, Plastic. Display the Series Options, and then set the Angle of first slice to 100 so that the Pooled Investments slice is in the front of the pie. Select the Pooled Investments slice, and then explode the slice 10%. Change the Fill Color of the Pooled Investments slice to a Solid fill using Orange, Accent 6, Lighter 40%. Format the Chart Area by applying a Gradient fill using any Preset gradient style. Note, depending upon the version of Office being used the Gradient fill may be named Light Variation - Linear Down. Format the Border of the Chart Aroa by adding a Solid line border using Orange, Accent 1 and a 5 nt Width Display the Page Setup dialog box, and then for this chart sheet, insert a custom footer in the left section with the file name. Display Sheet1 and rename the sheet as Investment Sources. Click in any blank cell to cancel any selections. In cell A12, type Goal: Increase Endowment Fund from 8% to 10% and then Merge & Center the text across the range A12:012. Apply the Heading 3 cell style. In cell A13, type Goal Amount. Copy the range C6:06 to cell 13. Click cell C13, and then use Goal Seek to determine the projected amount of Endowment Investments in cell B13 if the value in C13 is 10% 13 Select the range A13:C13, and then apply the 20% - Accent4 cell style. In B13, from the Cell Styles gallery, apply the Currency [0] cell style. 14 From the Page Setup dialog box, center the worksheet Horizontally, and then insert a custom footer in the left section with the file name. 15 Ensure that the worksheets are correctly named and placed in the following order in the workboyK: Projected Investments, Investment Sources. Save and close the document. Exit Excel. Submit the file as directed. 2 3 4 5 6 7 1 Start Excel. Download and open the file named gol6_xl_ch03_grader_3e_as.xlsx In cells B10 and C10, enter formulas to calculate totals for each column. In cell D5, construct a formula to calculate the % of Total Projected Investments for Pooled Investments by dividing the Projected Investments for Next Fiscal Year for Pooled Investments by the Total Projected Investments for Next Fiscal Year. Use absolute cell references as necessary, format the result in Percent Style, and Center the percentage. Fill the formula down through cell 09. Select the nonadjacent ranges A5:A9 and C5:09 as the data for a pie chart, and then insert a 3-D Pic chart. Move the chart to a New sheet named Projected Investments. For the Chart Title, type Projected Revenue. Format the Chart Title using the WordArt Style Fill: Orange, Accent color 1: Shadow and a Font Size of 32. Note, depending upon the version of Office being used, the style name may be Fill: Orange, accent color 1; Shadow. Remove the Legend chart element, and then add the Data Labels chart element formatted so that only the Category Name and Percentage display positioned in the Center Change the Font Size of the data labels to 12, and then apply Bold. Format the Data Series using a 3-D Format effect. Change the Top bevel and Bottom bevel to the last bevel style in the last row. Set the Top bevel Width and Height to 350 pt and then set the Bottom bevel Width and Height to 0. Change the Material to the third Standard Effect, Plastic. 8 Display the Series Options, and then set the Angle of first slice to 100 so that the Pooled Investments slice is in the front of the pie. Select the Pooled Investments slice, and then explode the slice 10%. Change the Fill Color of the Pooled Investments slice to a Solid fill using Orange, Accent 6, Lighter 40%. Format the Chart Area by applying a Gradient fill using any Preset gradient style. Note, depending upon the version of Office being used the Gradient fill may be named Light Variation - Linear Down. Format the Border of the Chart Area by adding a Solid line border using Orange, Accent 1 and a 5 pt Width. 10 Display the Page Setup dialog box, and then for this chart sheet, insert a custom footer in the left section with the file name. 11 Display Sheet! and rename the sheet as Investment Sources. Click in any blank cell to cancel any selections. In cell A12, type Goal: Increase Endowment Fund from 8% to 10% and then Merge & Center the text across the range A12:012. Apply the Heading 3 cell style. In cell A13, type Goal Amount. 12 Copy the range C6:D6 to cell B13. Click cell C13, and then use Goal Seek to determine the projected amount of Endowment Investments in cell B13 if the value in C13 is 10%. 13 Select the range A13:C13, and then apply the 20% - Accent4 cell style. In B13. from the Cell Styles gallery, apply the Currency [0] cell style. 14 From the Page Setup dialog box, center the worksheet Horizontally, and then insert a custom footer in the left section with the file name. 15 Ensure that the worksheets are correctly named and placed in the following order in the workbook: Projected Investments, Investment Sources. Save and close the document. Exit Excel. Submit the file as directed. 9 Deneck. 2016 cho grade 3 Formas Data View Inet CU Car Dr Page Layout Ciarlight A- A ated O 2rQ Wys Cordon Del w AL Day of Orange Bloom Beach 1 1 City of Orange Blossom Beach Investment Portfolio he heart he CY www 1 18.00 3,596.00 14,50 2011, 4002336 . ww terre The prinde 11 Start Excel. Download and open the file named go16_xl_ch03_grader_3e_as.xlsx In cells B10 and C10, enter formulas to calculate totals for each column. In cell D5, construct a formula to calculate the % of Total Projected Investments for Pooled Investments by dividing the Projected Investments for Next Fiscal Year for Pooled Investments by the Total Projected Investments for Next Fiscal Year. Use absolute celi references as necessary, format the result in Percent Style, and Center the percentage. Fill the formula down through cell D9. Select the nonadjacent ranges A5:A9 and C5:09 as the data for a pie chart, and then insert a 3-D Pie chart. Move the chart to a New sheet named Projected Investments. For the Chart Title, type Projected Revenue. Format the Chart Title using the WordArt Style Fill: Orange, Accent color 1; Shadow and a Font Size of 32. Note, depending upon the version of Office being used, the style name may be Fill: Orange, accent color 1: Shadow Remove the Legend chart element, and then add the Data Labels chart element formatted so that only the Category Name and Percentage display positioned in the Center. Change the Font Size of the data labels to 12, and then apply Bold. Format the Data Series using a 3-D Format effect. Change the Top bevel and Bottom bevel to the last bevel style in the last row. Set the Top bevel Width and Height to 350 pt and then set the Bottom bevel Width and Height to 0. Change the Material to the third Standard Effect, Plastic. Display the Series Options, and then set the Angle of first slice to 100 so that the Pooled Investments slice is in the front of the pie. Select the Pooled Investments slice, and then explode the slice 10%. Change the Fili Color of the Pooled Investments slice to a Solid fill using Orange, Accent 6. Lighter 40%. Format the Chart Area by applying a Gradient fill using any Preset gradient style. Note, depending upon the version of Office being used the Gradient fill may be named Light Vanation - Linear Down. Format the Border of the Chart Area by adding a Solid line border using Orange. Accent 1 and a 5 at Width Display the Page Setup dialog box, and then for this chart sheet, Insert a custom footer in the left section with the file name, Display Sheet1 and rename the sheet as Investment Sources. Click in any blank cell to cancel any selections. In cell A12. type Goal: Increase Endowment Fund from 8% to 10% and then Merge & Center the text across the range A12:012. Apply the Heading 3 cell style. cell A13. type Goal Amount. Copy the range C6D6 to cell B13 Click cell C13, and then use Goal Seek to determine the projected amount of Endowment investments in cell B13 if the value in C13 is 10% Select the range A13:C13, and then apply the 20% - Accent4 cell style. In B13, from the Ceil Styles gallery, apply the Currency of cell style. From the Page Fetup dialog box, center the worksheet Horizontally, and then insert a custom footer in the left section with the file name. Ensure that the worksheets are correctly named and placed in the following order in the workbook: Projected Investments, Investment Sources. Save and close the document. Exit Excel. Submit the file as directed. - Hen Draw Page Layout Formulas Data Review View Home Insert X Cut Copy Paste Format Calibri Light 18 A- A Wrap Text B + Merge & Cer A1 fx City of Orange Blossom Beach A D Xof Total Projected Investments $ 5 Pooled Investments 6 Endowment 7 Investment Reserves 8 Special 9 Fiscal Apent Funds 10 Total Current Year Projected Investments for Next Investments Fiscal Year 28,809.8005 32,956,740 8,120,500 6,754,950 13,786,400 22,712,600 4,007,520 6,874,325 11,694,500 13,987.550 16 17 16 19 20 21 24 25 26 29 00 22 36 as 32 39 40 41 44 15 Sheet1 Start Excel. Download and open the file named go16_xl_ch03_grader_3e_as.xlsx In cells 810 and C10, enter formulas to calculate totals for each column. In cell D5, construct a formula to calculate the % of Total Projected Investments for Pooled Investments by dividing the Projected Investments for Next Fiscal Year for Pooled Investments by the Total Projected Investments for Next Fiscal Year. Use absolute cell references as necessary, format the result in Percent Style, and Center the percentage. Fill the formula down through cell 09. Select the nonadjacent ranges AS:A9 and C5:09 as the data for a pie chart, and then insert a 3-D Pie chart. Move the chart to a New sheet named Projected Investments. For the Chart Title, type Projected Revenue. Format the Chart Title using the WordArt Style Fill: Orange, Accent color 1: Shadow and a Font Size of 32. Note, depending upon the version of Office being used, the style name may be Fill: Orange. accent color 1: Shadow. Remove the Legend chart element, and then add the Data Labels chart element formatted so that only the Category Name and Percentage display positioned in the Center. * Change the Font Size of the data labels to 12, and then apply Bold. Format the Data Series using a 3-D Format effect. Change the Top bevel and Bottom bevel to the last bevel style in the last row. Set the Top bevel Width and height to 350 pt and then set the Bottom bevel Width and Height to 0. Change the Material to the third Standard Effect, Plastic. Display the Series Options, and then set the Angle of first slice to 100 so that the Pooled Investments slice is in the front of the pie. Select the Pooled Investments slice, and then explode the slice 10%. Change the Fill Color of the Pooled Investments slice to a Solid fill using Orange, Accent 6, Lighter 40%. Format the Chart Area by applying a Gradient fill using any Preset gradient style. Note, depending upon the version of Office being used the Gradient fill may be named Light Variation - Linear Down. Format the Border of the Chart Aroa by adding a Solid line border using Orange, Accent 1 and a 5 nt Width Display the Page Setup dialog box, and then for this chart sheet, insert a custom footer in the left section with the file name. Display Sheet1 and rename the sheet as Investment Sources. Click in any blank cell to cancel any selections. In cell A12, type Goal: Increase Endowment Fund from 8% to 10% and then Merge & Center the text across the range A12:012. Apply the Heading 3 cell style. In cell A13, type Goal Amount. Copy the range C6:06 to cell 13. Click cell C13, and then use Goal Seek to determine the projected amount of Endowment Investments in cell B13 if the value in C13 is 10% 13 Select the range A13:C13, and then apply the 20% - Accent4 cell style. In B13, from the Cell Styles gallery, apply the Currency [0] cell style. 14 From the Page Setup dialog box, center the worksheet Horizontally, and then insert a custom footer in the left section with the file name. 15 Ensure that the worksheets are correctly named and placed in the following order in the workboyK: Projected Investments, Investment Sources. Save and close the document. Exit Excel. Submit the file as directed. 2 3 4 5 6 7 1 Start Excel. Download and open the file named gol6_xl_ch03_grader_3e_as.xlsx In cells B10 and C10, enter formulas to calculate totals for each column. In cell D5, construct a formula to calculate the % of Total Projected Investments for Pooled Investments by dividing the Projected Investments for Next Fiscal Year for Pooled Investments by the Total Projected Investments for Next Fiscal Year. Use absolute cell references as necessary, format the result in Percent Style, and Center the percentage. Fill the formula down through cell 09. Select the nonadjacent ranges A5:A9 and C5:09 as the data for a pie chart, and then insert a 3-D Pic chart. Move the chart to a New sheet named Projected Investments. For the Chart Title, type Projected Revenue. Format the Chart Title using the WordArt Style Fill: Orange, Accent color 1: Shadow and a Font Size of 32. Note, depending upon the version of Office being used, the style name may be Fill: Orange, accent color 1; Shadow. Remove the Legend chart element, and then add the Data Labels chart element formatted so that only the Category Name and Percentage display positioned in the Center Change the Font Size of the data labels to 12, and then apply Bold. Format the Data Series using a 3-D Format effect. Change the Top bevel and Bottom bevel to the last bevel style in the last row. Set the Top bevel Width and Height to 350 pt and then set the Bottom bevel Width and Height to 0. Change the Material to the third Standard Effect, Plastic. 8 Display the Series Options, and then set the Angle of first slice to 100 so that the Pooled Investments slice is in the front of the pie. Select the Pooled Investments slice, and then explode the slice 10%. Change the Fill Color of the Pooled Investments slice to a Solid fill using Orange, Accent 6, Lighter 40%. Format the Chart Area by applying a Gradient fill using any Preset gradient style. Note, depending upon the version of Office being used the Gradient fill may be named Light Variation - Linear Down. Format the Border of the Chart Area by adding a Solid line border using Orange, Accent 1 and a 5 pt Width. 10 Display the Page Setup dialog box, and then for this chart sheet, insert a custom footer in the left section with the file name. 11 Display Sheet! and rename the sheet as Investment Sources. Click in any blank cell to cancel any selections. In cell A12, type Goal: Increase Endowment Fund from 8% to 10% and then Merge & Center the text across the range A12:012. Apply the Heading 3 cell style. In cell A13, type Goal Amount. 12 Copy the range C6:D6 to cell B13. Click cell C13, and then use Goal Seek to determine the projected amount of Endowment Investments in cell B13 if the value in C13 is 10%. 13 Select the range A13:C13, and then apply the 20% - Accent4 cell style. In B13. from the Cell Styles gallery, apply the Currency [0] cell style. 14 From the Page Setup dialog box, center the worksheet Horizontally, and then insert a custom footer in the left section with the file name. 15 Ensure that the worksheets are correctly named and placed in the following order in the workbook: Projected Investments, Investment Sources. Save and close the document. Exit Excel. Submit the file as directed. 9