Nicky posted an Question
December 04, 2021 • 19:16 pm 30 points
  • UGC NET
  • Human Resource Management

O andard cof slat read the following spreadsheet (ms-excel) a b edurncle.com c 12 5 0 the equation in cell b2 is a2 +$ b $1. the equation is then copied and pas

O andard COF Slat Read the following spreadsheet (MS-EXCEL) A B Edurncle.com C 12 5 0 The equation in cell B2 is A2 +$ B $1. The equation is then copied and pasted to cells B3, B4 and B5. What should be the value in B3 ? (2) 24 (1) 56 44 (4) 36 Ile 9829489592

1 Answer(s) Answer Now
  • 0 Likes
  • 2 Comments
  • 0 Shares
  • Rucha rajesh shingvekar

    Accept all the answer if all doubts are clear.

  • Rucha rajesh shingvekar best-answer

    $B$1 tells Excel you always want to refer to cell B1. So, B3=A3+B1 = 8+16 = 24 so option (2) is correct.

whatsapp-btn

Do You Want Better RANK in Your Exam?

Start Your Preparations with Eduncle’s FREE Study Material

  • Updated Syllabus, Paper Pattern & Full Exam Details
  • Sample Theory of Most Important Topic
  • Model Test Paper with Detailed Solutions
  • Last 5 Years Question Papers & Answers