#3 E Question 8: Which cell shown here displays an absolute cell reference? A FL Answer: A OF1 B. OSF$1 C. OSF1 D. OFS1 B SFS1 SF1 F$1 D 21 40 25 54 58 % 16 R T Y Copyright 2022-Labyrinth Leaming-A N ab IT 87 Prison Question 9: What would be the result in cell F8 if the formula were copied to cell FB? E F 8 =D$4+12 Answer: A. O-ES4+12 B. O=D$5+12 C. O-E$5+12 D. O=CS3+12 3 40 94 FA DII 15 % 85 Copyright 2022-Labyrinth Learning - All Rights R N ab 16 11 Prisca 27 11 8 Question 10: What would be the result in cell A2 if the formula were copied to cell A2? A 1-$C19+$019 2 Answer: A. O=$C20+$020 B. O=SC19+SD19 C. O-SC20+$D19 D. O-SC19+SD20 4 #3 40 FA 4 94 114 F5 Copyright 2022- Labyrinth Learning - All Rights Rem % 85 ab 16 7 PrtSc 18 25 8