Question

In MS Excel, the cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is:
1. G1 - G10
2. B1. G10
3. B1, G1
4. B1: G10

Answer 1

Correct Answer - Option 4 : B1: G10

The correct answer is B1: G10.

• 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:
  1. Relative Cell Reference
  2. Absolute Cell Reference
  3. 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.