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

