Question

The cell range that starts in cell A1 and goes over to J15 is written as ____ in a formula.
(a) (A1-j15)
(b) (A1;J15)
(c) (A1:J15)
(d) (A1 to J15)​

Answer 1

Answer:

Explanation:

he cell range that starts in cell A1 and goes over to column J and down to row 15 is _____

A1;J15

A1.J15

A1-J15

A1:J15 is the right ans

Answer 2

The cell range that starts in cell A1 and goes over to J15 is written as (A1:J15) in a formula

Explanation:

• In an Excel file, a cell range is a collection of selected cells. A cell range can also be referenced in a formula.  
• A cell range is specified in a spreadsheet by the reference of the upper-left cell (minimum value) and the reference of the lower right cell (highest value).
• The excel range notation A1:J15 denotes from upper left cell A1 to bottom right cell J15.