Nicky Asked a Question
December 4, 2021 1:46 pmpts 30 pts
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)
  • 0 Likes
  • 2 Comments
  • Shares
  • Rucha rajesh shingvekar
    Accept all the answer if all doubts are clear.
    Likes(0) Reply(0)
  • Rucha rajesh shingvekar thankyou
    $B$1 tells Excel you always want to refer to cell B1. So, B3=A3+B1 = 8+16 = 24 so option (2) is correct.
    Likes(0) Reply(0)
Head Office :
MPA 44, 2nd floor, Rangbari Main Road,
Mahaveer Nagar II, Kota (Raj.) – 324005

Corporate Office:
212, F-1, 2nd Floor, Evershine Tower,
Amrapali Marg,
Vaishali Nagar, Jaipur (Raj.) – 302021

Mail: info@eduncle.com
All Rights Reserved © Eduncle.com