Page 63 - Penta Book's ICT Catalogue
P. 63
TASK 2
Functions
As you know, Microsoft Excel can help you calculate
and analyze numerical information with the help of a
wide variety of functions.
Type the table:
2
Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5 COUNT 1
The COUNT function is used to calculate the number
of cells that contain numbers.
To add COUNT function: 3
8 4
/ Functions / Functions > In the Formulas tab, in the Function Library 5
5. Analyzing data / Functions
5. Analyzing data / Functions
GRADE > Click the cell where you want to create the
function, in this example, cell B7. 1
group, click Insert Function. 2
> On the Insert Function window, in the Or
select a category list, click Statistical. 3
> Click COUNT 4 and click OK. 5
> In the Function Arguments window, in the 6
Value1 box, type A1:B6. 6 It is the range of
cells which you want to count.
> Click OK. 7
7
Even if you don’t know the purpose
of a function, you can always read the
description. It explains in simple words what
the selected function is going to calculate.
62 Penta Books
