Question Discussion & Solution

An array formula is a formula that can perform multiple calculations on one or more of the items in an array. We can think of an array as a row of values, a column of values, or a combination of rows and columns of values. Array formulas can return either multiple results or a single result. For example, we can create an array formula in a range of cells and use the array formula to calculate a column or row of subtotals. We can also place an array formula in a single cell and calculate a single amount. An array formula that includes multiple cells is called a multi-cell formula, and an array formula in a single cell is called a single-cell formula.

Ctrl+R fills the row cell to the right with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Right arrow to select multiple cells. Then press Ctrl+R to fill them with the contents of the original cell.

In Excel Date format is considered as value.

The absolute cell reference in excel is a cell address that contains a dollar sign ($). It can precede the column reference, the row reference or both.