show full work please, thank you!
Multiplication Table: You are to write one and only one formula in cell B2, and copy this formula to the entire cell range B2:T20 to realize the multiplication table as shown in the below picture. D c 3 1 2 4 5 0 15 10 1 2 3 20 10 20 12 24 38 16 32 40 15 24 32 40 S 1 9 TB 27 38 45 54 17 si 51 3 4 5 12 19 24 30 38 42 45 11 22 31 44 5 38 77 14 2 42 55 70 H 35 54 72 00 10 52 10 3 13 20 30 52 16 28 21 104 10 12 00 90 112 75 90 105 120 1 2 E 5 10 15 20 25 30 35 40 45 So 35 10 15 70 78 BO 15 18 21 24 27 30 33 38 20 50 64 2 20 14 102 12 16 20 34 20 22 30 40 44 48 52 50 00 BA E 72 18 SB 20 22 24 200 20 100 37 34 28 9 10 11 12 13 14 15 18 17 72 31 BO 90 100 10 11 17 13 14 15 16 a 7 14 21 20 35 42 49 80 53 70 77 54 91 00 105 112 119 120 330 140 54 50 50 72 78 150 115 50 EB 70 DO 30 1000 110 120 3:30 140 150 180 170 180 190 200 99 110 121 1:32 143 154 165 178 181 199 72 04 90 100 120 132 144 150 168 100 192 204 210 220 95 104 112 120 120 88 102 119 130 153 170 107 204 221 200 112 120 140 154 160 12 186 210 224 144 16 178 192 200 24 340 2010 100 120 140 160 180 200 220 200 200 200 300 114 10 152 11 190 200 22 20 20 20 304 130 13 15 150 182 105 200 221 2004 201 200 100 300 234 252 210 200 0 210 228 240 256 128 135 14 153 102 171 10 45 48 50 54 57 0 222 2 144 252 342 10 10 20 102 100 114 120 SO 95 100 19 340 300 780 00 2 904 20 205 200 24 343 0 23 340 40 160 200 220 300 This assignment emphasizes the impact on what happens to a formula when it is copied from one cell location to another, depending on whether RELATIVE, OR MIXED (or ABSOLUTE) cell reference is used. Using the appropriate cell references when we write formulas, we can save a lot time in not having to write many, many individual formulas but simply copy-and-paste. NOTE: You are to write ONE and ONLY ONE formula in a cell (e.g. B2) and copy the formula from that cell to all the cells in the range B2:T20. 1. Open a new Excel file. Use Auto Fill to enter numbers in A2:A20 and B1:T1 as shown in the above picture 2. Format the cells in the range A1:T20 to vertically and horizontally center the text. 3. In cell B2 enter the formula = A2 B1 (or = B1. A2). You should see 4 in the cell. 4. If you copy the formula in B2 across into C2 T2 you do not get 6, 8, 10, 12, etc. Try it. You did not get the right results. The relative) cell reference A2 was changed to B2, C2, D2, etc. as you copied the formula across. Should you use (Absolute) $A$2? (Mixed) $A2? (Mixed) A$2? 5. If you copy the formula in B2 down into B3:B20, you do not get 6, 8, 10, 12, etc. Try it. You did not get the right results. The (relative) cell reference B1 was changed to B2, B3, B4, etc. as you copied the formula down. Should you use (Absolute) $B$1? (Mixed) $B1? (Mixed) B$1? Once you find the correct cell references for A2 and B1, you can write this formula in B2 and copy it to the entire range B2:T20 and the multiplication results should be correct. Make sure you understand why these cell references are correct for the formulas. 6. Tum your sheet to "Show Formulas" view
