Name: Swapnika Suthrave By checking the Declaration box to the right, I am declaring that the work I am submitting is my own

submitting is my own and that I

1 Declaration
Student #: 4369491 understand it is an offence to submit another student's work.
1. Format the data below appropriately so it can all be read and so it looks presentable. This should be a unique format to you. Status
0
- Make sure all data can be read clearly so the reader does not have to struggle to interpret the data.
2. Select the appropriate data type for each cell (Number, Text, Currency, etc.).
FALSE
- Money should be Accounting or Currency.
Continue working
Instructions: 3. Insert a formula that will calculate the number of regular hours (anything up to and including 37.5 hours). FALSE through this
4. Insert a formula that will calculate the number of overtime hours (anything over 37.5 hours). FALSE worksheet.
5. Calculate the total pay to 2 decimal places. Overtime hours will be paid at time and a half (1.5 times the regular pay rate).
FALSE
- Make sure to use the ROUND function instead of just shifting the decimal place.
6. Calculate the grand total for all employees using an appropriate tool or formula. FALSE

Last Name First Name Employee Number Pay Rate Number of Hours WorkedNumber of Regular HoursNumber of OT Hours Total Pay
Smith John 40062 $24.27 28 28 0 $679.56
Smith Logan 40029 $22.80 28 28 0 $638.40
Horner Dewey 40007 $22.38 30 30 0 $671.40
Islington Walter 40113 $24.81 30 30 0 $744.30
Paulson Mark 40087 $24.44 32.5 32.5 0 $794.30
Christoff Sven 40036 $29.06 33.5 33.5 0 $973.51
Baldwin Larry 40012 $30.67 35 35 0 $1,073.45
Benjamin Stewart 40119 $17.92 35 35 0 $627.20
Dinklage Rita 40081 $22.34 35 35 0 $781.90
Freeman Ian 40072 $21.44 35 35 0 $750.40
Harris Natalie 40155 $28.03 35 35 0 $981.05
Orlando Martha 40141 $21.66 35 35 0 $758.10
Peters Carrie 40132 $27.16 35 35 0 $950.60
Porter Mona 40001 $24.83 35 35 0 $869.05
Powell Alexis 40166 $25.17 35 35 0 $880.95
Stevenson Violet 40127 $24.96 35 35 0 $873.60
Tomlinson Chris 40013 $26.11 35 35 0 $913.85
Carson Owen 40159 $27.12 37.5 37.5 0 $1,017.00
Grant Thomas 40138 $19.45 37.5 37.5 0 $729.38
Johnson Henrietta 40021 $27.06 37.5 37.5 0 $1,014.75
Newman Alison 40079 $26.53 37.5 37.5 0 $994.88
Norman Tricia 40112 $21.51 37.5 37.5 0 $806.63
Pattinson Marnie 40000 $25.69 37.5 37.5 0 $963.38
Sherman Nick 40106 $26.53 37.5 37.5 0 $994.88
Thompson Gwen 40167 $22.03 37.5 37.5 0 $826.13
Thompson Samantha 40086 $26.32 37.5 37.5 0 $987.00
Ellis Fred 40091 $23.83 40 37.5 2.5 $982.99
Lewis Brenda 40125 $24.88 40 37.5 2.5 $1,026.30
Rankford Grant 40128 $17.01 40 37.5 2.5 $701.66
Ryan Felix 40092 $33.71 40 37.5 2.5 $1,390.54
Williams Kit 40008 $26.48 40 37.5 2.5 $1,092.30
Gerison Veronica 40110 $19.10 41 37.5 3.5 $816.53
Wallis Paulie 40004 $22.91 41 37.5 3.5 $979.40
Franklin Heidi 40100 $27.22 42 37.5 4.5 $1,204.49
Myers Julie 40019 $18.07 44 37.5 6.5 $853.81
Grand Total $ 31,343.67
 Name: By checking the Declaration bo
Student #: and that I understand it is an o
1. Insert the last 3 digits of your student number into the car paym
2. Input the sum of each expense in N13:N22, then the sum of eac
3. Input the grand total of either all Expense Totals or Monthly Tot
Instructions: 4. Fill in the average, max, and min monthly totals in B25:B27 usin
5. Use a calculation in I26 to calculate the yearly income.
6. Insert a cell reference into I27 that displays the yearly expenses
7. Use an IF statement to state if there is a Net Income or Net Loss
- Include conditional formatting to colour the cell green if th
Monthly Income $ 4,554.00 777 ← Insert a random 3 digit number

Expenses Jan. Feb. Mar. Apr.

Car Payment $ 491.00 $ 491.00 $ 491.00 $ 491.00
Work Supplies $ 80.00 ₹ 48.00 $ 54.00 $ 49.00
Credit Card $ 125.00 $ 101.00 $ 106.00 $ 90.00
Electric $ 42.00 $ 55.00 $ 62.00 $ 85.00
Entertainment $ 172.00 $ 75.00 $ 70.00 $ 118.00
Food $ 150.00 $ 175.00 $ 195.00 $ 180.00
Taxes $ 675.00 $ 675.00 $ 675.00 $ 675.00
Insurance $ 140.00 $ 140.00 $ 140.00 $ 140.00
Rent $ 800.00 $ 800.00 $ 800.00 $ 800.00
Water $ 50.00 $ 50.00 $ 50.00 $ 50.00
Monthly Total $ 2,725.00 $ 2,610.00 $ 2,643.00 $ 2,678.00

Ave. Monthly Total $ 2,680.33

Max. Monthly Total $ 2,733.00
Min. Monthly Total $ 2,610.00
checking the Declaration box to the right, I am declaring that the work I am submitting is my own
that I understand it is an offence to submit another student's work.
udent number into the car payment for each month (cells B13:M13) and input a random 3-digit number in D10.
n N13:N22, then the sum of each month in B23:M23.
Expense Totals or Monthly Totals (they will be the same) in N23.
n monthly totals in B25:B27 using the appropriate formula.
ate the yearly income.
at displays the yearly expenses.
here is a Net Income or Net Loss. Include the amount difference in I28.
ing to colour the cell green if there's a Net Income and red if a Net Loss.
Insert a random 3 digit number here. This will change your monthly income in B10.

May June July Aug. Sept. Oct.

$ 491.00 $ 491.00 $ 491.00 $ 491.00 $ 491.00 $ 491.00
$ 66.00 $ 28.00 $ 79.00 $ 32.00 $ 54.00 $ 83.00
$ 88.00 $ 90.00 $ 95.00 $ 95.00 $ 84.00 $ 89.00
$ 94.00 $ 102.00 $ 130.00 $ 115.00 $ 103.00 $ 81.00
$ 134.00 $ 102.00 $ 138.00 $ 142.00 $ 165.00 $ 60.00
$ 160.00 $ 200.00 $ 135.00 $ 130.00 $ 140.00 $ 158.00
$ 675.00 $ 675.00 $ 675.00 $ 675.00 $ 675.00 $ 675.00
$ 140.00 $ 140.00 $ 140.00 $ 140.00 $ 140.00 $ 140.00
$ 800.00 $ 800.00 $ 800.00 $ 800.00 $ 800.00 $ 800.00
$ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00
$ 2,698.00 $ 2,678.00 $ 2,733.00 $ 2,670.00 $ 2,702.00 $ 2,627.00

Member's Yearly Income $ 54,648.00 ← This should be a formula

Member's Yearly Expenses $ 32,164.00 ← Use proper cell referencin
Net Income/Loss Net Income ← Conditionally state "Net In
Income/Loss Amount $ 22,484.00 ← Calculate the amount of In
submitting is my own
0 Declaration
m 3-digit number in D10. 0 Status
0
FALSE
Continue
FALSE
working
FALSE
through this
FALSE worksheet.
FALSE

Nov. Dec. Expense Total

$ 491.00 $ 491.00 $ 5,892.00
$ 39.00 $ 28.00 $ 640.00
$ 99.00 $ 130.00 $ 1,192.00
$ 61.00 $ 42.00 $ 972.00
$ 154.00 $ 159.00 $ 1,489.00
$ 190.00 $ 186.00 $ 1,999.00
$ 675.00 $ 675.00 $ 8,100.00
$ 140.00 $ 140.00 $ 1,680.00
$ 800.00 $ 800.00 $ 9,600.00
$ 50.00 $ 50.00 $ 600.00
$ 2,699.00 $ 2,701.00 $ 32,164.00

This should be a formula

Use proper cell referencing here
Conditionally state "Net Income" or "Net Loss"
Calculate the amount of Income/Loss