basic computer MCQ #2145

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?

basic computer MCQ #2145

  1. Question 1

    Q1. 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) Mixed Reference
    • C) Relative reference
    • D) None of these

    Answer: Absolute reference

    Explanation: Absolute reference is the right answer. This tests practical computer literacy expected in clerical, banking, and IT operator recruitment papers.