Capstone

The top two rows will be spreadsheet title information: add the text: Project Expenditures at the top, and add Star Mountain College in the row below that.
Below the title rows, leave two rows blank, then add each of the following data headings (one per column) from left to right: Area, Description, Estimated Budget, Expenditures, Surplus/Deficit, and % of Total Expenditures.
The Areas sheet tab includes a list of all of the areas with current improvement projects. Copy this list below the “Area” heading in your own spreadsheet. Be sure your spreadsheet does not include the styling/formatting from the data spreadsheet.
The Descriptions tab has the text for the “Description” column of your spreadsheet. Copy this list to your own spreadsheet without any of the original styling or formatting.
The data file includes two hidden sheet tabs. Unhide the Data tab and leave the Unused tab hidden.
The Data tab includes two columns of calculated data. Copy the values in column A into the “Estimated Budget” column of your own spreadsheet, taking care not to copy the formulas used to calculate the data.
Column C of the Data tab should likewise be pasted into your “Expenditures” column–again getting just the values without any associated formulas.The Surplus/Deficit column should indicate how much money remains for the project (a surplus) OR how much the project has gone over budget (a deficit). For example, the Star Hall project is budgeted for about $123,500k but has only spent about $118k, so it has a surplus of around $5,500. The Butterfly Hall updates have gone over budget, so it should show around -$250.
Calculate the surplus or budget for each project. Format the results as currency.
Below your data, calculate totals for each of the three columns so far.
The % of Total Expenditures for a project is calculated by dividing the project’s expenditures (copied from the data file) by the total of all expenditures (calculated in the previous step). For example, the Star Hall project accounts for around .15 of the total expenditures or about 15%. You can verify your calculation by checking the sum of all percentages in the column, which should add up to 1.
Merge and center the top row text (“Project Expenditures“) so that it spans across all of your data.
Style that row as Title.
Merge and center the next row (“Star Mountain College”) similarly, and style it as Heading 1.
Style the data headings (“Area” through “% of Total Expenditures”) as Heading 3. Then, Wrap Text for this entire row and resize the columns to best suit your desired appearance.
Style the three calculated sums below your data as Total.
Format all values in “Estimated Budget”, “Expenditures”, and “Surplus/Deficit” as Currency.
Format “% of Total Expenditures” as Percentage, displayed to two decimal places.
Add a 3-D Column Chart showing the data from your “Description” and “Estimated Budget” columns, not including the total budget calculation.
Place the chart below all of your data so it is not blocking anything. Stretch the chart so that all text is visible.
Change the chart title to Project Budgets.

WRITE MY PAPER

Comments

Leave a Reply Cancel reply