Excel Assignments
p7nardellal1-12-12teenu.s.a.payroll.xlsx | |
File Size: | 13 kb |
File Type: | xlsx |
Teen U.S.A. Payroll
This assignment is called Teen U.S.A Payroll. In this assignment, I used formulas to calculate gross and net pay of employee workers. The hours worked and the hourly rate was given and I had to figure out the gross pay. I then had to calculate the federal tax, social security tax, medicare tax, state tax, and the pension in order to get the end results of the net pay. The technology skills I had to use to complete this assignment were the calculations. I had to know how to highlight the backgrounds of each gross pay and each net pay. I needed to know how to calculate each of the taxes in order to figure out the net pay. I learned how to use certain formulas to calculate the numbers and end with the net pay. I believe that what I did well in this assignment was the calculations and the organization of the information. I finished what I was supposed to do and I completed the final net pay of the employees. In order to go beyond the requirements asked of me, I could've added more shading to show the important data. As I learn more skills about Microsoft, I can further enhance the appearance of this assignment.
p7nardellal31412formula_features.xlsx | |
File Size: | 19 kb |
File Type: | xlsx |
Formula Features
This assignment is called Formula Features. In this assignment, I created a grade book to calculate the students grades. From all the exams the students took, I figured out the class average, the highest average and the lowest average. I then continued to answer a few questions about the assignment. The technology skills I had to use to complete this assignment included using "all borders" selection to create a chart. I also needed to know how to calculate each of the grades by putting in formulas. I learned how to use formulas to calculate certain grade averages and figure out who had the highest average and the lowest average. The part I did well in this assignment was the completion of the average grades and the highlighting of the highest and lowest averages to show who did the best job on their exams. I worked extremely hard on this assignment and completed all of the directions given. If I was to change or enhance anything in this assignment I would change the font styles of the titles and shade more of the important information.
p7nardellal41012raise.xlsx | |
File Size: | 15 kb |
File Type: | xlsx |
Raise
This assignment is called Raise. In this assignment, I used the IF function to calculate employee pay raises. From the list of employee names, the salary of 2010, and the % increase, I was able to figure out the employee pay raises. The technology skills I had to use to complete this assignment were the IF function to calculate the pay raises. The formula I entered began with "IF" and then I was able to calculate the raises for each employee. I then created a chart with the new 2011 salary and the position the employee has. There were a few questions I answered about the information. I learned how to create a chart with information I calculated and also formatted the chart with a color background and slanted headings for the positions. I believe what I did well in this assignment was the calculations and creating the chart. I believe I created a well-organized chart with a lot of formatting. Although I followed all of the directions I could in this assignment, I could change the chart style and possibly the heading fonts. Since I have learned more information about the chart styles, I could've gone further with playing around with different chart styles.