Selected MCQ

Current Question
What are the items inside the parentheses in an MS Excel formula called?
  • A. Variables
  • B. Parameters
  • C. Arguments
  • D. Conditions
Correct Answer: C
Explanation:
Values or references inside parentheses are called arguments.
Related Question 1
Comment put on Excel cell, which is displayed by taking the Mouse Pointer there, is called ____.
  • A. Smart tip
  • B. Soft Tip
  • C. Web Tip
  • D. Cell Tip
Correct Answer: D
Explanation:
A comment in Excel is displayed as a Cell Tip when hovering the mouse.
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
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 5
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.