2. Consider a worksheet where cell Al has the value 2 and cell A2 holds the value 5.Select the
two cells and drag to Auto Fill upto cell As What values will you get in cell A3, A4 and AS?
Answers
Answer:
You can also select multiple cells at the same time. A group of cells is known as a cell range. Rather than a single cell address, you will refer to a cell range using the cell addresses of the first and last cells in the cell range, separated by a colon. For example, a cell range that included cells A1, A2, A3, A4, and A5 would be written as A1:A5.
In the images below, two different cell ranges are selected:
Cell range A1:A8
Screenshot of Excel 2013
Cell range A1:B8
Screenshot of Excel 2013
If the columns in your spreadsheet are labeled with numbers instead of letters, you'll need to change the default reference style for Excel. Review our Extra on What are Reference Styles? to learn how.
Mark me as brilliant
Answer:
nsksbsisnydnsodudtwbis8hdidusvjxoxbs