1. a. In this assignment, Teen Payroll, we had to use formulas to calculate the gross and net pay. b. We had to enter data into an excel spreadsheet, calculate proper formulas all multiplication, answer a few basic questions based on the table we made, as well as shading columns in the chart. c. In this assignment I learned how to shade columns in a table as well as how to calculate the tax of something. d. In this assignment I really understood how to compute and calculate the proper formulas to get the information that I needed. e. I did everything that was asked of me in this assignment.
2. a. In this assignment, Problem #22, we had to create a grade book to calculate students grades. b. In this assignment we had to use the microsoft excel software to complete it. Also, we used the avg formula to calculate the averages of students test grades for themselves and the entire class. We also learned how to insert a picture and resize it in excel. c. By completing this assignment I learned how to easily calculate the average of numbers by using the avg formula button. I also learned how to insert a picture into excel, which will definitely come in handy in the future. d. In this assignment I did very well incomputing the averages of each person for their final grades. e. I could have gone above and beyond and maybe shaded the columns and made it more appealing.
3. a. In this assignment, Activity #48, we had to use the IF function to calcu;ate employee pay raises. b. In this assignment we had to use the microsft excel software to properly complete it. We had to use the IF function to figure out which employees would get a higher raise. We had to plug in the original information first; the more years of service the higher the raise would be and vice versa. We also used the SUM function to come up with the accurate sums of each column. c. In this assignment I learned how and why the IF function is used and how to properly use it to find out the information that is needed. d. In this assignment I did very well at plugging in the accurate information inorder to get the proper outcome of who would get the higher raise. e. I did everything that was asked of me in this assignment.