Page 64 - Penta Book's ICT Catalogue
P. 64
TODAY
To have the current date 2
displayed on your worksheet, use
the TODAY function.
To use the TODAY function:
> Click cell B8, the location
where you want your 1
results to be displayed. 1
> On the Formulas tab, in the
Function Library group, 3
click Date & Time. 2
> In the list, click TODAY. 3
> In the Functions
Arguments window,
click OK. 4
4 DIGITAL TEENS 2 MODULE 5
CONCATENATE Computing and ICT . Sample Pages
To join cell contents, you can use the CONCATENATE function.
To use the CONCATENATE
function: 8
2 GRADE
> Click cell C2. 1 3
> On the Formulas tab, 4
in the Function Library
group, click Insert 1
Function. 2 5
> In the Insert Function
window, in the Or select a
category list, click All. 3
> Click CONCATENATE. 4
> Click OK. 5 6
> In the Function
Arguments window, in
Text1 box type A2, in
Text2 type “ ” and in 7
Text3 type B2, in Text4
type “m”. 6
> Click OK. 7
> Use the Autofill tool 8
to complete the other 8
rows. 9 9
Penta Books 63
