Bird
0
0

Which MS Excel formula correctly subtracts the value in cell B2 from cell A2?

medium Q5 of 15
Computer Aptitude - Microsoft Office (Basics + Functions)
Which MS Excel formula correctly subtracts the value in cell B2 from cell A2?
A=A2-B2
B=SUB(A2,B2)
C=A2/B2
D=DIFF(A2,B2)
Step-by-Step Solution
  1. Step 1: Identify the arithmetic operation

    The task is subtraction.
  2. Step 2: Recall Excel arithmetic operators

    The minus (-) operator performs subtraction.
  3. Final Answer:

    =A2-B2 → Option A.
  4. Quick Check:

    Excel supports direct arithmetic using operators ✅
Quick Trick: Subtraction uses the minus (-) operator.
Common Mistakes:
  • Using non-existent functions like SUB or DIFF.
Master "Microsoft Office (Basics + Functions)" in Computer Aptitude

Start learning the concept with an interactive lesson.

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Computer Aptitude Quizzes