Selected MCQ

Current Question
Excel would evaluate the formula, =2010/58, and return answer as ____.
  • A. 34.655
  • B. 6.25
  • C. 320
  • D. 132
Correct Answer: A
Explanation:
2010 ÷ 58 equals approximately 34.655.
Related Question 1
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 2
Which of the following Excel features allows users to evaluate values and return a result?
  • A. Formulas
  • B. Formatting
  • C. Filters
  • D. Insertions
Correct Answer: A
Explanation:
Formulas and functions evaluate data and return results.
Related Question 3
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 4
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 5
Which function in Excel returns the remainder of a division?
  • A. Divide
  • B. MOD
  • C. ACOT
  • D. None of these
Correct Answer: B
Explanation:
MOD returns the remainder after division.