📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!

    Question

    In MS Excel, a formula is copied vertically downward,

    but the row number of a specific cell reference remains unchanged while the column changes.Which type of cell reference supports this behaviour?
    A Relative reference Correct Answer Incorrect Answer
    B Absolute reference Correct Answer Incorrect Answer
    C Mixed reference Correct Answer Incorrect Answer
    D Circular reference Correct Answer Incorrect Answer
    E 3D reference Correct Answer Incorrect Answer

    Solution

    Mixed reference – One part fixed, other changes

    Practice Next
    More Previous year papers Questions