Page 77 - Code & Click - 6

Using AutoSum Feature

The AutoSum feature allows you to quickly add the values in a selected cell
range. You can also use it to find the average, count, maximum and minimum
of values in a desired cell range.
To use the AutoSum feature:
1. Select the cell range containing numeric values.
2. On the Home tab, click the AutoSum down arrow in the Editing group.
A drop-down list of predefined functions appears.

3. Select the desired function.
Excel displays the result of the selected function in the cell below or to the right of the selected
cell range.
Error Results in a Formula or Function
Sometimes, a cell containing a formula indicates an error instead of the desired result because there
is some mistake in the formula and Excel cannot evaluate it.
The table given below lists some common errors with reason for their occurrence.

Error Reason
###### Occurs when a column is not wide enough to display the result

#VALUE! Occurs when the formula contains invalid data

#DIV/0! Occurs when a number is divided by zero (0)
#N/A Occurs when a value that formula uses is not available

#NAME? Occurs when the text in a formula is not recognised by Excel
#REF! Occurs when the formula contains an invalid cell reference

#NUM! Occurs when the formula contains an invalid numeric value

Post-Processingost-Processing
P
 A Formula is an equation used to perform calculation on the data and produce a result in a
worksheet.

 A formula always starts with an equal (=) sign, which can be followed by operators, constants,
cell references, and functions.
 In Relative referencing, cell references of the cells, containing the data, change when the
formula is copied from one cell to another cell, depending on the target cell address.
 In Absolute referencing, a cell reference in a formula remains constant even if the formula
is copied or moved from one cell to another cell.

 In Mixed referencing, one part of the cell address – column or row, is made absolute while
the other part is relative.
 Functions are in-built formulas in Excel that you can use to perform calculations in your
worksheets.
 Excel reports an error in a formula in different ways that relate to the cause of error.

75