Selected MCQ

Current Question
In MS Excel, to create a formula, you can use ____.
  • A. Cell references, although not both at the same time
  • B. Cell references with values but not values
  • C. Values but not cell references
  • D. Both value and cell references
Correct Answer: D
Explanation:
Formulas can combine cell references and literal values.
Related Question 1
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 2
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 3
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.
Related Question 4
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 5
If a formula references a cell that contains text instead of a numerical value, what error does Excel display?
  • A. #NUM!
  • B. #VALUE!
  • C. #REF!
  • D. #DIV/0!
Correct Answer: B
Explanation:
#VALUE! An error appears when the formula expects numbers but receives text.