Assignment: Teen U.S.A Payroll
You will need Microsoft Excel to open this file
This assignment was recording the data from the worksheet and then adding in formulas to fill in the assignment to find out the gross pay, net pay, and other payments. I used Microsoft Excel to put the information from a worksheet into an Excel file and finishing it up. I learned in the assignment how to add up multiple numbers and add them all up using the SUM function. I did all of what the worksheet asked of me to do for the assignment. I added in shading and colors to the cells to make the inportant things stand out from the information that doesnt matter. I dont think I could add anything else to the file to make it any better.
Assignment: Formula Functions for Grade Book
You will need Microsoft Excel to open this file
In this assignment I had to also make more formulas for calculating this time grades. I used the formula's: MIN, MAX, COUNT, AVERAGE, ando other common formula's. I used Microsoft Excel and also clip art within Excel to spruce up the worksheet. I learned how to use the COUNT formula to see how many items are in the selected amount of cells. I did the whole assignment to the standards of the instructions. I dont think I could do anything to improve the assignment, I also added in Clip Art and other extra things to give the worksheet some color.
Assignment: Raises for Pay Employees
You will need Microsoft Excel to open this file
In this assignment I also used the COUNT formula, but also with the IF function. I had to find out how many of a certain number is in a selected number of cells. I used Microsoft Excel to create the assignment. I learned how to use the COUNTIF function so I can find out how many items are in a selected number of cells. I did all of the assignment to what the insructions said and added in some colors and bolding to show the important information. I think there is nothing to add to the assignment to make it better.