Autosum Feature and Relative Cell Reference:
In the given example, autosum is used in cell F2. Now we can
place the mouse handle in cell F2 and can copy formula using fill
handle(dragging downward), Excel will copy formula to all the below cells.
While copying formula cell addresses automatically get changed, this feature is
known as relative cell reference. 
Excel provides Autosum button in Home Tab (Editing group).
This includes 5 commonly used functions sum, average, count, max and min. Using
this feature we can avoid typing these five functions. But caution is required
while auto-selecting range.
No comments:
Post a Comment