Select the correct formula for addition in excel
Question
Select the correct formula for addition in excel:
Options
Option A
=max(A2:A5)
Option B
=add(A2+A3+A4+A5)
Option C
=sum(A2:A5)
Option D
A2+A3+A4+A5
Correct Option
Option C
Explanation
There is no SUBTRACT function in Excel. To subtract values by using a function, use the negative values with the SUM function. For example, the formula =SUM(30,A3,-15,-B6) adds 30 and the value in cell A3, subtracts 15, and also subtracts the value in cell B6.
Popular Tags: 7 Days
Upcoming MCQs
Computer Fundamental Multiple Choice Questions Exam Free
- 2024-06-12 03:15
- 15 Mins
- 12 Enrolled
- 25 Full Marks
- 10 Pass Makrs
- 25 Questions
