You must create a nicely formatted Excel spreadsheet from scratch. When turning in the Excel problem, you need to hand in two hard copies -one with the results/values and the other with the formulas. To alternate between formulas and results you simultaneously hit the “Ctrl” and “” keys. Whichever screen is showing will be the one that prints. I also want the columns and rows printed as well as grid lines. To do this go to “File” above the toolbar, select “page setup” then “sheet”. Select “gridlines” and “row and column headings” then click on “OK”. It should then print the column labels and row labels with the gridlines.
This assignment will be graded for presentation clarity and the use of formulas where formulas would allow another user to change appropriate numbers in a what-if scenario.