Which MS-EXCEL formulae are equivalent to each other?

A. = A3 + A4 + A5 + A6

B. = SUM(A3 : A6)

C. = SUM (A3, A6)

D. = SUM(A3, A4, A5, A6)

This question was previously asked in
UGC NET Official Paper 1: Held On 15 June 2023 Shift 2
View all UGC NET Papers >
  1. A, B and C only
  2. A, B and D only
  3. B and D only
  4. C and D only

Answer (Detailed Solution Below)

Option 2 : A, B and D only
Free
UGC NET Paper 1: Held on 21st August 2024 Shift 1
10.8 K Users
50 Questions 100 Marks 60 Mins

Detailed Solution

Download Solution PDF

The correct answer is: A, B and D only
Important Points

A. = A3 + A4 + A5 + A6

This formula adds together the values in cells A3, A4, A5, and A6.

B. = SUM(A3 : A6)

This formula also adds together the values in cells A3, A4, A5, and A6. The ":" indicates a range of cells, so this is equivalent to the formula above.

C. = SUM (A3, A6)

This formula only adds the values in cells A3 and A6. It does not include A4 or A5, so it's not equivalent to the other formulas.

D. = SUM(A3, A4, A5, A6)

SUM(A3, A4, A5, A6) adds the values in cells A3, A4, A5, and A6 using the SUM function with individual cell references.

All three formulas (A, B, and D) perform the same operation and produce the same result, summing the values in cells A3, A4, A5, and A6.

Latest UGC NET Updates

Last updated on Jun 6, 2025

-> The UGC NET Exam Schedule 2025 for June has been released on its official website.

-> The UGC NET Application Correction Window 2025 is available from 14th May to 15th May 2025.

-> The UGC NET 2025 online application form submission closed on 12th May 2025.

-> The June 2025 Exam will be conducted from 21st June to 30th 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.

More Types of ICT Based Instruction Questions

Get Free Access Now
Hot Links: teen patti game paisa wala teen patti master 2023 teen patti refer earn teen patti joy