Class 6 Exam  >  Class 6 Notes  >  How to become an Expert of MS Excel  >  Use an Entire Column as a Cell Range

Use an Entire Column as a Cell Range | How to become an Expert of MS Excel - Class 6 PDF Download

  • In some situations, you may want to find the sum or average of a column of data. Although you can do this with a normal cell range, for example =SUM(C1:C20), you may have to update the cell range later if you add more data to your spreadsheet.
  • However, Excel also has a different kind of cell range that omits the row number and pulls in all of the cells in the entire column. For example, if you want to find the sum of all of the values in column C, you would type =SUM(C:C). This kind of cell range allows you to add as much data as you want to your spreadsheet without having to update your cell ranges.
The document Use an Entire Column as a Cell Range | How to become an Expert of MS Excel - Class 6 is a part of the Class 6 Course How to become an Expert of MS Excel.
All you need of Class 6 at this link: Class 6
94 videos|62 docs|15 tests

Top Courses for Class 6

94 videos|62 docs|15 tests
Download as PDF
Explore Courses for Class 6 exam

Top Courses for Class 6

Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
10M+ students study on EduRev
Related Searches

pdf

,

Use an Entire Column as a Cell Range | How to become an Expert of MS Excel - Class 6

,

Summary

,

shortcuts and tricks

,

Viva Questions

,

Use an Entire Column as a Cell Range | How to become an Expert of MS Excel - Class 6

,

mock tests for examination

,

MCQs

,

ppt

,

Extra Questions

,

study material

,

past year papers

,

video lectures

,

Sample Paper

,

practice quizzes

,

Exam

,

Semester Notes

,

Previous Year Questions with Solutions

,

Use an Entire Column as a Cell Range | How to become an Expert of MS Excel - Class 6

,

Important questions

,

Objective type Questions

,

Free

;