Page 30 - iPro_trackGPT_V5_Class8
P. 30
Logical Functions
Function Purpose Example
It checks whether the given condition Percentage = 80
IF(condition, value1, is met, and returns value1 if the Input: =IF(Percentage >= 50,
value2) condition evaluates to true, and value2 “Passed”, “Failed”)
if the condition evaluates to false. Output: Passed
Age = 18
This function returns TRUE if all Score = 85
AND(condition1,
specified conditions are true; otherwise, Input: =AND(Age >= 18, Score
condition2, ...)
it returns FALSE. >= 60)
Output: TRUE
Age = 16
This function returns TRUE if at least Score = 85
OR(condition1,
one of the specified conditions is true; Input: =OR(Age >= 18, Score
condition2, ...)
otherwise, it returns FALSE. >= 60)
Output: TRUE
Tech Tweak
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 a graphical representation of data designed to make information easier to understand
and analyse. It helps you compare numbers, observe changes over time, and identify patterns or
relationships. Charts use visual elements such as bars, lines, or slices to simplify the process of
viewing and analysing data.
Components of a Chart
The various components of a chart are as follows:
Chart Title: The chart title explains the main purpose and content of the chart.
X-Axis: The x-axis is the horizontal axis of the chart, commonly known as the category axis.
Y-Axis: The y-axis is the vertical axis of the chart, commonly known as the value axis.
Plot Area: This is the rectangular section between the X and Y axes. It displays the actual
chart, including the plotted data, data series, category, and value axes.
28 TrackGPT iPRO (V5.0)-VIII

