Teen Payroll Spreadsheet
A.) In the assignment I had to use formula functions to calculate the Net Pay and Gross Pay of all workers based on hours worked and their hourly rate.
B.) I had to input formulas to calculate gross and net pay. Also I had to organize the workers by their hourly rate.
C.) I learned how to use the SUM function.
D.) I feel as though I did pretty much everything well, I had the correct formulas, I used the proper shading, and I organized the workers correctly by hourly wage.
E.) Like before when I stated that I feel as though I did everything well I don't really know what I could've done to to improve.
B.) I had to input formulas to calculate gross and net pay. Also I had to organize the workers by their hourly rate.
C.) I learned how to use the SUM function.
D.) I feel as though I did pretty much everything well, I had the correct formulas, I used the proper shading, and I organized the workers correctly by hourly wage.
E.) Like before when I stated that I feel as though I did everything well I don't really know what I could've done to to improve.
Formula Functions Spreadsheet
A.) I had to calculate exam the number of exams, high, low, and overall average of a class of students.
B.) I had to use formula functions to calculate the averages as well as the SUM function.
C.) I learned how to insert clip art into an excel document as well as calculate averages through the use of a formula.
D.) Acurate calculations.
E.) I would have propably made it more visually appeaing maybe added some shading but beyond that I can't see much else that could be improved upon.
B.) I had to use formula functions to calculate the averages as well as the SUM function.
C.) I learned how to insert clip art into an excel document as well as calculate averages through the use of a formula.
D.) Acurate calculations.
E.) I would have propably made it more visually appeaing maybe added some shading but beyond that I can't see much else that could be improved upon.
Raises Spreadsheet
A.) I had to organize the 2010 salary of some of the workers at a company from highest to lowest.
B.) I had to know how to use the sort function in order to organize the worker's salaries from highest to lowest.
C.) How to sort data.
D.) Accurate typing (no misspellings) and good organization.
E.) No improvment needed.
B.) I had to know how to use the sort function in order to organize the worker's salaries from highest to lowest.
C.) How to sort data.
D.) Accurate typing (no misspellings) and good organization.
E.) No improvment needed.
Conditional Formatting Presentation
A.) In this powerpoint I had to demonstrate to the class 3 examples of Conditional Formatting, the picture to the left demonstrates color scales in conditional formatting.
B.) I had to know how to format and utilize the conditional formatting tool color scales in excel.
C.) How to use color scales
D.) Good use and demonstration of the tools.
E.) put more time into the project as you can see, in this slide alone, there is an error with the highlighting of the cells.
B.) I had to know how to format and utilize the conditional formatting tool color scales in excel.
C.) How to use color scales
D.) Good use and demonstration of the tools.
E.) put more time into the project as you can see, in this slide alone, there is an error with the highlighting of the cells.