Page 29 - Trackpad_ipro 4.1_Class8
P. 29
The current month will appear. You can also give 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.
Logical Functions
Function Purpose Example
It checks whether the given condition is Percentage = 80
IF(condition, met, and returns value1 if the condition Input: =IF(Percentage >= 50,
value1, value2) evaluates to TRUE, and value2 if the “Passed”, “Failed”)
condition evaluates to FALSE. Output: Passed
Age = 18
This function returns TRUE if Score = 85
AND(condition1,
all specified conditions are true; Input: =AND(Age >= 18,
condition2, ...)
otherwise, it returns FALSE. Score >= 60)
Output: TRUE
Age = 16
This function returns TRUE if at
OR(condition1, Score = 85
least one of the specified conditions
condition2, ...) Input: =OR(Age >= 18, Score >= 60)
is true; otherwise, it returns FALSE.
Output: TRUE
Tech
Funda
✶ The common functions like SUM, AVERAGE, MAX,
and MIN, can also be used by using the down arrow
of the AutoSum command.
✶ To use other functions, click on the More Functions
option.
CHARTS IN EXCEL
A chart is an effective way to display data in a pictorial form. It makes it easier to draw comparisons
and analyse growth, relationships, and trends among values in a table.
Components of a Chart
The various components of a chart are as follows:
Chart Title: The chart title describes the aim and content of the chart.
X-axis: X-axis, also known as category axis, is the horizontal axis of the chart.
Y-axis: Y-axis, also known as value axis, is the vertical axis of the chart.
Plot Area: Plot area is the rectangular area bounded by the two axis that contains the actual
chart and includes plotted data.
Spreadsheet—Functions and Charts 27

