Question:

=SUM(B2B3) will give an error while using a spreadsheet. Identify the error and state the steps to correct it.

Show Hint

Always use a colon (:) to indicate a range in Excel.
Hide Solution
collegedunia
Verified By Collegedunia

Solution and Explanation

Error: The formula =SUM(B2B3) is syntactically incorrect. Excel doesn’t recognize 'B2B3' as a valid range.
Correct Format: Use =SUM(B2:B3) to add the values in cells B2 and B3.
Steps to correct:
1. Double-click the cell with the formula.
2. Replace B2B3 with B2:B3.
3. Press Enter to apply the correction.
% Quick tip
Was this answer helpful?
0
0