Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
144 views
in Computer by (106k points)
closed by

What is the result of the following MS-Excel formula?

=SUM(2−3^2, 9) 


1. 2
2. 10
3. 7
4. 11

1 Answer

0 votes
by (106k points)
selected by
 
Best answer
Correct Answer - Option 1 : 2

The correct answer is 2.

  • The result of the MS-Excel formula-SUM(2−3^2, 9) is 2.
    • Firstly 3^2 will be solved and it is equal to 9------SUM(2-9,9)
    • Then 9 is subtracted from 2 which equals -7 -----SUM(-7,9)
    • Then lastly both -7 and 9 will be added and it is equal to 2.

 

  • The Excel SUM function returns the sum of values supplied.
    • These values can be numbers, cell references, ranges, arrays, and constants, in any combination.
    • SUM can handle up to 255 individual arguments.
  • Purpose 
    • Add numbers together
  • Return value 
    • The sum of values supplied.
  • Syntax 
    • =SUM (number1, [number2], [number3], ...)
  • Arguments 
    • number1 - The first value to sum.
    • number2 - [optional] The second value to sum.
    • number3 - [optional] The third value to sum.

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

...