This question was previously asked in

MP Patwari Previous Paper 16 (Held On: 15 Dec 2017 Shift 2)

Option 4 : B1: G10

The correct answer is __ B1: G10__.

__Key Points__

**Cell Reference**- A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Excel can find the values or data that users want that formula to calculate.
- There are three types of cell references:

- Relative Cell Reference
- Absolute Cell Reference
- Mixed Cell Reference

**MS-Excel**- It is a spreadsheet program for data analysis and documentation.
- It contains a number of rows and columns, where the intersection of a column and cell and a row is a "cell".
- Each cell contains one point of data.
- It is developed by Microsoft.
- It features calculation, graphing tools, pivot tables, etc.