Selected MCQ

Current Question
If you want to add the contents of cells A1 and A2 together in Excel, which formula would you use?
  • A. =SUM(A1, A2)
  • B. #NAME?
  • C. =A1 + A2
  • D. None of these
Correct Answer: C
Explanation:
The simple addition formula =A1+A2 directly adds the two cells.
Related Question 1
The contents of two or more consecutive cells could be put together using ____.
  • A. Shrink to fit
  • B. Wrap Text
  • C. Merge Cells
  • D. Center Alignment
Correct Answer: C
Explanation:
Merge Cells combines multiple cells into a single cell.
Related Question 2
What is the main purpose of the formula palette in MS Excel?
  • A. Create and edit formulas containing functions
  • B. Edit existing formulas
  • C. Format cells
  • D. Perform complex calculations
Correct Answer: A
Explanation:
The Formula Palette (Function Arguments dialog) helps build and edit formulas.
Related Question 3
What formula is used to calculate monthly mortgage payments in Excel?
  • A. PMT
  • B. GMT
  • C. PST
  • D. None of these
Correct Answer: A
Explanation:
PMT is a financial function that calculates the periodic payment amount.
Related Question 4
Which of the following functions in Microsoft Excel counts the number of cells with numerical data in the argument?
  • A. COUNT
  • B. AVERAGE
  • C. SUM
  • D. MAX
Correct Answer: A
Explanation:
COUNT tallies only numeric cells.
Related Question 5
In MS Excel evaluate the formulae (7-3) (6+1)/4 result will be ____.
  • A. 5
  • B. 3
  • C. 7
  • D. 8
Correct Answer: C
Explanation:
(7-3) × (6+1) ÷ 4 = 4 × 7 ÷ 4 = 7.