Course Content

  • Formulas

Course Content


Type the column letter followed by the row number to refer to a cell. The cell at the junction of column D and row 50, for example, is designated as D50.

Columns are labelled alphabetically, and rows are labelled numerically in the A1 style. Both columns and rows are numerically labelled in the R1C1 reference style.

When generating formulas in Excel, cell references are crucial. Cell references allow your formulas to automatically update when the value in a particular cell changes, and they can also help you update formulas as cells are copied or relocated.

But, beneath all of this beauty and capability, the two most fundamental elements of Excel are rows and columns, which let the user to apply any formula and store or manage any data in the spreadsheet.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere