Stocks spreadsheet
In this assignment we created a spreadsheet to keep track of various stocks. We learned how to format numbers in a way that allows a negative to be shown in red and parentheses, as well as using the dollar sign to refer to a fixed cell. We needed to copy the data, place some formulas into the table, then format the columns for negative numbers, and autosum the totals. I learned that you can refer to a fixed cell in Excel. I think I did well, but would have shaded the columns more effectively.
Excel 22
In this assignment we used formulas to calculate grades in a gradebook. We used many different formulas, such as max/min, count, and average. We needed to copy the data, insert the proper formulas, shade cells, and answer learning questions. I learned that Excel will count things for you in this assignment. I feel that I did a good job, but the shading isn't logical.
excel charts project
This assignment called for us to create an instructional presentation for the class about how to create a certain type of chart in excel. We created a powerpoint on line graphs. To create the powerpoint we used the excel help menu and SNAP tutorials; we also needed to create an activity for the class to do. We did presentations to the class on our type of chart and then the class completed the activity the group fabricated. I did not learn any new information through this project on excel, however it helped me to work with people. I feel we did a great job working as a team and on the final product.
Excel 50
This assignment instructed us to fabricate a spreadsheet dictating loan payments on a Yacht using 5 different payment plans. We learned how to use the PMT (Payment) formula to calculate the loan payments. In order to complete the assignment, we needed to add the data to the chart, use the PMT formula, and Autofill the rest of the calculated data from the formula. After completing the assignment, we answered questions about which payment plan was the best deal, the lowest or highest monthly payment. I learned how to use the PMT function. I feel the project was done well, and i wouldn't change anything about it.