Selected MCQ

Current Question
Address of the cell at 27th column and 30th row is ____.
  • A. AA20
  • B. AZ26
  • C. 26,30
  • D. None of these
Correct Answer: D
Explanation:
Column 27 = AA, row 30 = AA30.
Related Question 1
In Excel, if you want to reference a cell in the same column but a different row on another sheet, what type of reference should you use?
  • A. Absolute reference
  • B. Relative reference
  • C. Mixed reference
  • D. Circular reference
Correct Answer: A
Explanation:
Absolute reference ($A$1) keeps the cell fixed across sheets.
Related Question 2
Which of the following is a valid cell address?
  • A. A6
  • B. 6A
  • C. A-6
  • D. None of these
Correct Answer: A
Explanation:
Cell addresses follow the column-letter + row-number format.
Related Question 3
MS Excel displays the address of the active cell in the ____.
  • A. Formula bar
  • B. Status bar
  • C. Name box
  • D. Toolbar
Correct Answer: C
Explanation:
The Name Box shows the current cell reference.
Related Question 4
In MS Word, to combine cells of a table’s row/column you ____ the cells.
  • A. Merge
  • B. Simplify
  • C. Join
  • D. Link
Correct Answer: A
Explanation:
Merge is the command used to combine cells.
Related Question 5
Computer spreadsheet cell that is highlighted with a heavy border is a ____.
  • A. Active cell
  • B. Cell containing a formula
  • C. Locked cell
  • D. Cell
Correct Answer: A
Explanation:
The cell with a heavy border is the active (currently selected) cell.