8: Which cell shown here displays an absolute cell reference? A FL Answer: B $F$1 SF1 F$1 D A OF1 B. OSF$1) C. O SF1 D. OFS1 2 3 4 E R 25 % 85 Copyright 2022-Labyrinth Leaming-A N ab O 96 T Y ST 7 88 Prison U Question 9: What would be the result in cell F8 if the formula were copied to cell F8? E F 8 =D$4+12 Answer: A. O-E$4+12 B. O=D$5+12 C. O -E$5+12 D. O=C$3+12 3 40 94 FA DII 45 % 85 Copyright 2022 Labyrinth Learning - All Rights R N 6 17 Prison 116 27 8 Question 10: What would be the result in cell A2 if the formula were copied to cell A2? 1-$C19+$019 2 Answer: A. O=$C20+$020 B. O=SC19+SD19 C. O-SC20+SD19 D. O-SC19+SD20 Copyright 2022- Labyrinth Learning- All Rights Res 40 FA Pill 15 E2 54 #3 % 25 96 FT PrtScn 28 36 8