_is used for generating series of numbers,days,months etc
Answers
Answer:
For Excel to know how to fill in the series, you usually need to provide two or three examples. In the case of sequences like months, weekdays, and hours, you only need to provide one example.
1)Type in either the first element (e.g. January or any month) or the first two or three elements (e.g. 1, 2) of a series.
2)Select the cell(s) you just typed in.
3)Move the cursor over the little block in the lower right corner of the active cell, and the cursor changes to a hairline plus sign (+), as opposed to the usual block plus sign.
4)Click and hold on the fill handle and drag to the right (or down) to fill in the series. Note that Excel can only extend series by adding to the sequence (that is, the next month, adding the same number, etc.), not other kinds of math such as square, multiplication, etc.
Answer:
For Excel to know how to fill in the series, you usually need to provide two or three examples. In the case of sequences like months, weekdays, and hours, you only need to provide one example.
1)Type in either the first element (e.g. January or any month) or the first two or three elements (e.g. 1, 2) of a series.
2)Select the cell(s) you just typed in.
3)Move the cursor over the little block in the lower right corner of the active cell, and the cursor changes to a hairline plus sign (+), as opposed to the usual block plus sign.
4)Click and hold on the fill handle and drag to the right (or down) to fill in the series. Note that Excel can only extend series by adding to the sequence (that is, the next month, adding the same number, etc.), not other kinds of math such as square, multiplication, etc.