Which of the following is the correct way to refer to a cell located in column A and row 10 in MS-Excel 365 within a function or formula?

Question

Accepted Answer

**Solution:**

1. In Microsoft Excel, a cell reference is given by the column letter followed by the row number.

2. For a cell in column A and row 10, the correct reference is **A10**.

3. The option **A-10** is invalid because the hyphen is not used in cell references.

4. The option **10A** is invalid because the column letter must come before the row number.

5. The option **A:10** is invalid because it refers to a range from column A to row 10, which is not a valid single cell reference.

**Answer:** A10

Answer

Answer

Answer