LIVE Course for free

Rated by 1 million+ students
Get app now
JEE MAIN 2023
JEE MAIN 2023 TEST SERIES
NEET 2023 TEST SERIES
NEET 2023
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
575 views
in General by (30.0k points)
closed by

In an Excel spreadsheet, the contents of cells are as follows:

a) A1 contains the value 2

b) A2 contains the value 3

c) A3 contains the formula: =$A$1+A2

Contents of cell A3 are copied to Cell A4. The value displayed in Cell A4 will be:


1. 3
2. 8
3. 5
4. 7

1 Answer

0 votes
by (46.1k points)
selected by
 
Best answer
Correct Answer - Option 4 : 7

The correct answer is 7.

  • If the cell value of A1 is 2.
  • If the dell value of A2 is 3.
  • And if  A3 contains the formula: =$A$1+A2
  • that is the value of A3 will be 5.
  • But if contents of cell A3 are copied to cell A4 =$A$1+A3
  • So the values at A4 cell will be 2+5 i.e. 7

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...