EXCEL Help

Gone through problems 1-2 and need some help and explanation for problem 3

Problem 1 Go to the "Income Survey" sheet. Make a column of data called "Wage" that follows the same formula we used as in the previous exercise: wages = annual income/[hours worked per week weeks worked per year) If there is an error message in a cell leave it in. You will need to use them later. Also, use the Comma format to ensure there are two decimal places. 1 Point Problem 2 Make a duplicate column called "Wage (Copy)." Then, if a cell within "Wage (Copy)" is equal to zero or an error, manually delete that cell so it is blank instead. Use the Comma format to ensure these values have two decimal places. 1 Point Problem 3 Context: sometimes, it takes a long time to manually delete cells by hand. If we can get the same result using autofill and IF, it may save time on large data sets. Make a column of data called "Wage (IF)." Use the IF function and relative references to logically test if the denominator from your wage calculation (hours worked times weeks worked) is equal to zero. If it is equal to zero, return a blank string, otherwise return the relative value from "Wage." Use the Comma format to ensure these values have two decimal places. Note: You return a blank string by setting the function IF's input to a pair of quotation marks with nothing inbetween them. If you leave the value if true> input empty, it will be wrong because IF will use zero as a default, and zeros will bias our averages later, so we want to avoid zeros by using a blank string instead. If you do this correctly, the cells in "Wage (Copy)" and "Wage (1F)" should look similar in terms of output, but their input formulas will be different. 1 Point A H 2 Individual 1 2 3 F G Wage (Copy) Wage (LF) 13.49 40.62 20.76 20.24 15.40 34.82 41.62 4 4 mino 000 0 00 00 13.54 22.97 25.65 19.69 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 & GOOGA 8 88 B C D E Annual Hours Weeks Income Worked Worked Wage 28,068.00 40 52 13.49 42,652.00 35 30 40.62 29,900.25 30 48 20.76 36,829.67 35 52 20.24 24,025.00 40 39 15.40 47,350.00 40 34 34.82 42,664.00 25 41 41.62 0 #DIV/0! 28,170.00 40 52 13.54 44,450.00 45 43 22.97 25,650.00 25 40 25.65 45,190.00 45 51 19.69 0 #DIV/0! o #DIV/0! 52,125.00 45 52 22.28 41,350.00 40 51 20.27 11,886.25 20 41 14.50 19,750.00 40 25 19.75 29,800.00 25 42 28.38 21,750.00 32 35 19.42 38,500.00 35 49 22.45 0 0 #DIV/0! 22,546.00 40 35 16.10 65,100.00 45 45 32.15 21,500.00 35 40 15.36 65,628.00 40 52 31.55 62,562.35 30 51 40.89 62,179.20 40 52 29.89 33,051.00 35 52 18.16 0 o #DIV/0! 25,462.00 40 35 18.19 29,563.00 40 29 25.49 44,820.60 42 46 23.20 41,520.00 40 52 19.96 W8 coa un 22.28 20.27 14.50 19.75 28.38 19.42 22.45 22 23 24 25 26 27 28 29 30 31 32 33 34 16.10 32.15 15.36 31.55 40.89 29.89 18.16 18.19 25.49 23.20 19.96