Question
Download Solution PDFConsider the following spreadsheet:
| A | B | C | |
| 1 | 4 | 3 | |
| 2 | 5 | 2 | |
| 3 | 7 | ||
| 4 | 8 | 9 | |
| 5 | 9 | ||
| 6 |
If the formula = $A$3 + B2 in cell C4 is copied to cell C5, then what is the value in cell C5?
Answer (Detailed Solution Below)
Detailed Solution
Download Solution PDFThe correct option is 9.
Key Points
- The $ symbol creates an absolute cell reference that won't change before the row and column coordinates. It can be written in different ways A1, $A$1, $A1, and A$1
- + sing symbolized Plus.
- So, $A$3 = 7
= $A$3 + B2 is equal to 9
= $A$3 + B2 = 7+2 = 9
Last updated on Jul 7, 2025
-> The UGC NET Answer Key 2025 June was released on the official website ugcnet.nta.ac.in on 06th July 2025.
-> The UGC NET June 2025 exam will be conducted from 25th to 29th June 2025.
-> The UGC-NET exam takes place for 85 subjects, to determine the eligibility for 'Junior Research Fellowship’ and ‘Assistant Professor’ posts, as well as for PhD. admissions.
-> The exam is conducted bi-annually - in June and December cycles.
-> The exam comprises two papers - Paper I and Paper II. Paper I consists of 50 questions and Paper II consists of 100 questions.
-> The candidates who are preparing for the exam can check the UGC NET Previous Year Papers and UGC NET Test Series to boost their preparations.