Cyber Class 5 MS Excel Basics

Asked by AKSHAY GURU VARADHARAJAN · SRI CHAITANYA TECHNO SCHOOL, JAYANTI NAGAR.

Which of the following is the correct way to write a formula in Excel to add the values of cells A1 and B1?

Answer as guest — Start Free Practice Test to earn Practice PointsHow to earn pointsAsk a question+3Answer a question+1Someone answers yours+1Your Q gets upvoted+1Pioneer bonus (first 5)+5, ask questions & climb the leaderboard!

A A1 + B1 =
B =SUM(A1:B1)
C SUM(A1+B1)
D Add(A1,B1)

Show answer and explanation

Answer: B. =SUM(A1:B1)

Answer: (B) =SUM(A1:B1)
Explanation: Every Excel formula must start with an equal sign (=). The SUM function uses a colon (:) to define a range of cells.

Answering after opening this box earns no Practice Points.

Rules for asking and answering

Which of the following is the correct way to write a formula in Excel to add the values of cells A1 and B1?

More questions like this