Page 61 - 2611_SmartGPT Pro V(5.0) C-5

When you press the Enter key, the current date appears Date Function
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() functions to get the year and

day from a date respectively.
Using TODAY function

a. Which chart type is circular in shape?

____________________________________________________
uiz Bee b. Which chart type is also known as XY scatter plot chart?

____________________________________________________

Self Reflection 21 st Century #Initiative
Skills
#Leadership & Responsibility
Your neighbour has been preparing a list of grocery items with their prices. She has been
Self Reflection
manually calculating the total amount. Do you think you should help people whenever you
see an opportunity?

Hashtag

#Chart: Displays data in a pictorial form
#Text: Defines the information on the spreadsheet

REVISIT

▶ A cell reference is a cell address that can be used in a formula to denote a specific cell.
▶ In relative reference, you actually refer to cell that is above or below and left or right to a
number of rows or columns.

▶ If you wish to maintain the original references as they were, then you should make use of
the absolute references.
▶ A mixed reference is a reference that refers to a specific row or column.
▶ Functions are predefined formulas in Excel to perform both simple and complex
calculations.

Charts, Formulas & Functions in Excel 59