8. The formula -B3 a B3-C4 is stored in cell D5. What will the formula be If a t

Question

8. The formula -B3 a B3-C4 is stored in cell D5. What will the formula be If a the second row in the w above (a) B3+C4 (b)-B4+C5 (c) -C3+D4 (d) -B2+C3 9. The cell contents of B3 and B4 are 4 and 5 respectively. What will be displayed in cell b5 if you enter the characters B3+B4 in cell B5 and then press the enter key? (a) B3+B4 (b) B3+B4 (c) 9 (d) It is not possible to determine from the information given 10. Which part of the formula -B9/4+(C6 D7) is considered a constant? (a) B9 (b) 4 (c) C6 (d) D7 11.A cell at the intersection of the first row and third column has the cell reference (a) A3 (b) 3A (c) C1 12. If cells A1, A2. and A3 contain the values 1, 2, and 5, respectively, what value will be displayed in a cell containing the formula =(A3-Al)/A2^2+1*A2? (a) 1 (b) 3 (c) .0625 (d) .4 13.The function AVERAGELA6 A8) is the equivalent of the formula (a) A6+A7+A8/3 (b) -(A6+A7+A8/3) (c)(A6+A7+A8)/3 (d) (A6+A8)/2 14. Which of the following formulas is in the correct format? (a) 4G G1 (b)-55H-3 (c) =A6 + Z35 (d) 52+43 15. What is the result of the formula -6l(2 3)/2)+42 (a) 17 (b) 22 (c) 42 (d) 20

Explanation / Answer

8. As row is inserted above 2nd row, formula will become =B4+C5 (incremented by 1 as one row is inserted)

9. 9 will be displayed which is sum of values stored in B3 and B4

10. b) 4 is only contant term

11. c) C1, column comes first then row, column name is alphabetical and row name is number

3rd column is C, (A=1, B=2, C=3 and so on) and row number is as it is.

12. = (5-1)/4+1*2

= 4/4 + 2

= 1 +2 = 3

b)

13. c) (A6+A7+A8)/3

average is sum of cells from A6 to A8 divided by number of cells i.e. 3

14. c) A6+Z35 all other are not mathematically correct formula, some of them have missing = sign other have missing * sign

15. b)

= 6 ((6)/2) +4

= 6 (3) + 4

= 18+4

= 22

a multiplication sign must be there, correct formula is

6*((2*3)/2)+4

Related Questions

Navigate

• Browse (All)
• Browse 8
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.