Question

to create a range, which option is used ​

Answer 1

Answer:

"cell address" is used to create a range of data automatically

Explanation:

hope it helped you

Answer 2

Answer:

1-In a cell (E2 in this example) enter the formula =COUNT(C2:C100)+1. ...

2-In another cell (F2 in this example), enter the formula =“Sheet1! ...

3-Go to the Data tab and select Named Ranges.

4-Create a named range with the name SalesData and use Sheet1!