Page 102 - Computer - 6
P. 102
11. Select cell L3 and drag its fill handle down to cell L6.
12. In cell M3, insert the CONCATENATE function. Specify A3 in Text1 box and B3 in Text2 box, and
click the OK button.
13. Select cell M3 and drag its fill handle down to cell M6.
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.
Lab Activity 2
Experiential Learning
To calculate the total marks of various students in different subjects by using the AutoSum feature.
1. Prepare the worksheet as shown.
2. Select the cell range A1:E1.
100
