What is the address of the cell in the tenth row of the fifth column in an MS-Excel worksheet?

This question was previously asked in
RRB NTPC CBT 2 (Level-3) Official Paper (Held On: 17 June 2022 Shift 3)
View all RRB NTPC Papers >
  1. 5J
  2. E10
  3. J5
  4. 10E

Answer (Detailed Solution Below)

Option 2 : E10
Free
RRB Exams (Railway) Biology (Cell) Mock Test
8.8 Lakh Users
10 Questions 10 Marks 7 Mins

Detailed Solution

Download Solution PDF

The correct answer is E10.

Key Points

  • A cell reference or cell address is a combination of a column letter and a row number that identifies a cell on a worksheet.
  • ADDRESS can return an address in relative, mixed, or absolute format, and can be used to construct a cell reference inside a formula.
  • Example : ADDRESS(1,1) returns $A$1 ( column is A and row is 1).

Additional Information

  •  The CELL function returns information about the formatting, location, or contents of a cell.

MS-Excel Worksheets

  • The term Worksheet used in Excel documents is a collection of cells organized in rows and columns.
  • It is the working surface you interact with to enter data.
  • Each worksheet contains 1048576 rows and 16384 columns and serves as a giant table that allows you to organize information.
Latest RRB NTPC Updates

Last updated on Jun 6, 2025

-> RRB NTPC 2025 Exam Postponed. Railway Recruitment Board has rescheduled the RRB NTPC Exam for June 5, 2025 (Shift 3). 

-> RRB NTPC Exam Analysis 2025 is LIVE now. All the candidates appearing for the RRB NTPC Exam 2025 can check the complete exam analysis to strategize their preparation accordingly. 

-> The RRB NTPC Admit Card 2025 has been released on its official website.

-> Candidates who will appear for the RRB NTPC Exam can check their RRB NTPC Time Table 2025 from here.

-> The RRB NTPC CBT 1 Exam is scheduled from 5th June to 24th June 2025 as per the revised tentative exam schedule. 

-> The RRB NTPC 2025 Notification has been released for a total of 11558 vacancies.

-> A total of 3445 Vacancies have been announced for Undergraduate posts like Commercial Cum Ticket Clerk, Accounts Clerk Cum Typist, Junior Clerk cum Typist & Trains Clerk.

-> A total of 8114 vacancies are announced for Graduate-level posts in the Non-Technical Popular Categories (NTPC) such as Junior Clerk cum Typist, Accounts Clerk cum Typist, Station Master, etc.

-> Prepare for the exam using RRB NTPC Previous Year Papers.

Get Free Access Now
Hot Links: teen patti master gold download teen patti rummy teen patti master king teen patti lotus teen patti jodi