Page 270 - Computer - 9(A&B)
P. 270
DATE (Year, Month, Day) Provides an internal number for the date given.
TODAY ( ) Returns the current date of the system.
SQRT (Number) Returns the square root of a number.
MOD (Number, Divisor) Returns the remainder value of a division.
R
Rapid Fireapid Fire
Rahul wants to calculate the factorial of a number in a Calc Is it possible to get
worksheet. Suggest which function would he use? the current date of the
system in Calc?
Using Functions
To insert functions in a Calc worksheet:
Step 1: Select the cell in the worksheet where the function’s results are to be displayed.
Step 2: Click the Insert menu and select Function option.
Or
Click Function Wizard button on the Formula bar.
Or
Press Ctrl+ F2 keyboard shortcut.
The Function Wizard dialog box appears.
Step 3: Select the function category from the Category drop list. Function from the selected category will
appear in the Function list box.
132
132