Category: MS Excel Formulas

A range in Excel is a collection of two or more cells. This chapter gives an overview of some very important range operations. Cell, Row, Column Let’s start by selecting a cell, row and column. 1. To select cell C3, click on the box at the intersection of column C and row 3. 2. To select column C, click on the column C header. 3. To select row 3, click on the row 3 header. Range Examples A range is a collection of two or more cells. 1. To select the range B2:C4, click…

A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel. For example, cell A3 below contains a formula which adds the value of cell A2 to the value of cell A1. For example, cell A3 below contains the SUM function which calculates the sum of the range A1:A2. Enter a Formula To enter a formula, execute the following steps. 1. Select a cell. 2. To let Excel know that you want to enter a formula, type an equal sign (=). 3. For example,…