Page 208 - DCAP101_BASIC_COMPUTER_SKILLS

Unit 10: Microsoft Excel

10.8 Excel Function Notes

ln the function dictionary that follows, the most commonly used Excel functions are listed
with their arguments. Function definitions are grouped by typ” and are listed in alphabetical
order within each group. The function groups include the following:
Database

Lookup and Reference
Date and time

Mathematical amd Trigonometic
Finacial
Statistical

Information
Text
Logical

The following sections explain some important functions of Excel.
10.8.1 Date and Time Function

Working with dates antl times is a common worksheet task and excel includes a rich set of
date and time functions. First, it is important to understand how Excel works with date and
time values.
Date and time values are numbers, regardless of how the cells are formatted. Dates and time
are stored as serial numbers-by default. Excel uses a 1900 date. System in which serial
numbers range from 1 to 65, 380 corresponding to dates Jan 1, 1990 through Dec 31, 2078.
In the serial number, digits to the right of the decimal point representing time of day
(as fraction of 24 hours); 12:00A p.m. is the equivalent of 5.
Today Returns the serial number of today’s sheet.
Syntax : TODAY()

Date Returns the serial number of a particular date.
Syntax : DATE (year, month, day)
Year is the year number 1900 or larger.

Month is a number representing the month of the year.
Day is a number representing the day of the month.
Day Convert a serial number to a day of the month.

Syntax : DAY (serial_number)
Seriai_number is the date_time code used by Microsoft Excel for
date and time calculations.
NOW Returns the serial number of the current date and time.

Synrax : NOW 0

LOVELY PROFESSIONAL UNIVERSITY 201