Term 3 Microsoft Office
Teen Payroll To complete this assighnment many steps had to be accomplished. first we had to type all data shown. Next, we had to calculate the tax, pension, aned net pay and gross pay using different formulas. After that we had to answer a set of questions about the document such as who had the lowest hourly rate or who had the highest hourly rate. After that we had to use our knowledge on shading cells to color the total, net pay, and gross pay columns. To complete this assighnment i us Microsoft Office Excell. during the course of this assighnment i learned how to do different types of formulas. If i were to go back and re-do this assighnment i would make it more visually appealing.
|
Formula Functions During this assighnment we had to accomplish many steps. We had to calculate the average grade within a class, within each particular student, the lowest average within the class and particluar student, and lastly, we had to calculate the final average.To complete this assighnment,I used Microsoft Office Excell. during the course of this assighnment i learned how to use different formulas and functions to get the averages and totals. If i were to go back and re-do this assighnemnt i would make it more appealing and maybe use different formulas than i used.
|
Raises To complete this assighnment, I had to accomplish many steps. We had to make a spreadsheet for employees salarys in 2011 to 2012. We had to use formulas to figure out the percentage increase, the 2012 raise, and the 2012 Salary. We did this by using formulas and functions. Lastly, we had to answer 5 questions such as which employee had the lowest salary and which employee had the highest salary in 2011. To complete this assighnment, i used microsoft Office Excell. In this spreadsheet, i learned differnet finctions nad formulas to find the percentages and raises. If i were to go back and do this assighnment again, i would make it more appealing.
|