Selected MCQ

Current Question
$ sign in excel formula to ____ row and column.
  • A. update
  • B. new
  • C. fixed
  • D. duplicate
Correct Answer: C
Explanation:
The $ sign fixes (makes absolute) the row or column reference.
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, which function automatically totals a column or row of values?
  • A. Total
  • B. ADD
  • C. SUM
  • D. AVG
Correct Answer: C
Explanation:
SUM is the dedicated function for totaling values.
Related Question 4
How do you automatically adjust the width of a column in Excel?
  • A. Double-click the left border of the column
  • B. Double-click the right border of the column
  • C. Double-click the column header
  • D. All of the above
Correct Answer: B
Explanation:
Double-clicking the right border of the column header auto-fits the column width.
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.