JAMIA 2026 — Computer PYQ

Q: How do I solve JAMIA 2026 Computer questions?

Practice JAMIA 2026 Computer previous year questions with step-by-step solutions on Mathem Solvex. Each question includes a detailed explanation and video solution to help you master the concept quickly.

Q: What is the difficulty level of JAMIA Computer questions?

JAMIA Computer questions range from moderate to advanced difficulty. Consistent practice with official previous year papers and topic-wise drills on Mathem Solvex is the most effective preparation strategy.

Q: Are JAMIA previous year papers available for free?

Yes. Mathem Solvex provides free access to JAMIA previous year question papers and topic-wise PDFs. You can download them or attempt them as timed live mock tests directly on the platform.

Question

JAMIA 2026 — Computer PYQ

JAMIA | Computer | 2026

Which of the following is an invalid cell reference in MS Excel?

Choose the correct answer:

Explanation

Correct Answer: (a) 1C

Detailed Explanation

Standard Excel Cell Addressing: In Microsoft Excel, a standard cell address must always start with the Column Letter(s) followed directly by the Row Number. For example, column $C$ and row $1$ is correctly written as $C1$ .
Why 1C is Invalid: The string 1C reverses this structural sequence by starting with a numeric row descriptor before the letter descriptor, making it an invalid identifier that Excel cannot parse.
The Role of the Dollar Sign ( $):</strong> The character <span style="font-family: "Google Sans Text", sans-serif !important;">$ \$$ is a special operator used to create absolute addresses. It locks a column reference, a row reference, or both, ensuring they do not shift when a formula is copied or dragged to another cell.