Excel
p5costan12512teenusapayroll.xlsx | |
File Size: | 14 kb |
File Type: | xlsx |
In this assignment, I created an hourly payroll register for "Teen U.S.A." In this assignment, I had to fill in the hourly pay for each employee, as well as their pension and different taxes, then calculate their gross and net pays. This assignment taught me to use basic formulas, autosum, and shading. I did well with inserting and double checking my formulas to make sure the numbers were accurate. I should have removed some of the totals from columns that didn't require them.
p5costa31212formulafeatures.xlsx | |
File Size: | 14 kb |
File Type: | xlsx |
In this assignment, I created a chart to find the exam average and final average for eleven students in Mr. Pelagio's MS Office class. In this assignment, I had to use formulas to calculate averages, format cells, and insert an image. I formatted each cell properly with it's category and number of decimal places. To make the project more interesting, I could have picked a different clip art that was more colorful and played with the font size and color.
p5costa41012raise.xlsx | |
File Size: | 16 kb |
File Type: | xlsx |
I made this chart to track employee salaries. This required that I sort the data in the "salary" column from highest to lowest. I had to sort and analyze each piece of data, including the number of years of service, salary, and position of each employee.