Page 49 - Plus_V2.2_C6_Flipbook
P. 49
Step 2: Press the Enter key from the keyboard. Factopedia
Using TODAY function
When you press the Enter key, the current date appears in the cell.
We can also give the reference of a cell containing the date to the
MONTH() function. Similarly, we can use the YEAR() and DAY() Examples of some
other spreadsheet
functions to get the year and day from a date, respectively.
programs are
Google Sheets, iWork
Let’s CatCh uP
Numbers, LibreOffice
Write the output of the following: Calc and Lotus
1. =MIN (5,7,8) _____________ Symphony.
2. =Left("Computer", 4) _____________
3. =AVERAGE(12,3,6) _____________
4. =TODAY() _____________
5. =LEN("Touch") _____________
6. =COUNT(4,8,12) _____________
One of the most
Tech Hint famous bug in Excel is
To use the common functions like Sum, that it considers 1900
Average, Max and Min: click on the as a leap year.
down-arrow of the AutoSum command.
To use other functions: click on More
Functions option.
Let’s BaCk-uP
Excel allows users to create custom formulas to perform Microsoft considered
calculations on their data. other names for the
A group of selected cells is called a range. program including
A cell reference is a cell address that can be used in a formula "Mr. Spreadsheet"
to denote a specific cell. and "Master Plan"
The equal sign tells Excel that the succeeding characters before deciding on
constitute a formula.
Excel also contains built-in formulas called functions that "Excel".
make it easy to perform common calculations on data.
Formulas and Functions in Excel 2016 47

