SMP Quranic Science
Boarding School
BASIC DATA PROCESSING
Presentation by : Rosi Maelani, [Link].
SMP Quranic Science
Boarding School
Do you know the basic functions of
Microsoft Excel?
SMP Quranic Science
Boarding School
OBJECTIVE LEARNING
01 02
Understanding
Basic Functions Understanding the
and Basic if logic function in
Statistical microsoft excel
Functions
SMP Quranic Science
Boarding School
BASIC
FUNCTIONS
SMP Quranic Science
Boarding School
BASIC FUNCTIONS
SUM Function
Used to sum cells or ranges of
cells. The SUM formula is written as
"=SUM(range)"
SMP Quranic Science
Boarding School
BASIC FUNCTIONS
2
Count Function
Used to count cells that contain
numbers in a range of cells. The
formula for the count function is
"=COUNT(range)"
SMP Quranic Science
Boarding School
BASIC FUNCTIONS
SUMIF Function
Used to sum data with certain
criteria. The sumif function is
written as "=SUMIF(range;criteria)"
SMP Quranic Science
Boarding School
BASIC FUNCTIONS
4
Countif Function
Used to count the number of data
with certain criteria. The formula
writing is "=COUNTIF(range;criteria)"
SMP Quranic Science
Boarding School
BASIC FUNCTIONS
5 Mathematical Function
Functions to perform mathematical calculations with the help of standard
arithmetic operators such as add (+), subtract (-), multiply (*), and divide (/).
SMP Quranic Science
Boarding School
BASIC
STATISTICAL
FUNCTIONS
SMP Quranic Science
Boarding School
BASIC STATISTICAL FUNCTIONS
AVERAGE Function
Used to calculate the average from
a group of data. The formula
writing is "=AVERAGE(range)"
SMP Quranic Science
Boarding School
BASIC STATISTICAL FUNCTIONS
2
MAX / MIN Function
The max/min function is used to
find the maximum and minimum
values from a set of data. The
formula writing is "=MAX(range)
or =MIN(range)".
SMP Quranic Science
Boarding School
BASIC STATISTICAL FUNCTIONS
3 Logical If Function
The if function is a logical function used to perform logical comparisons
between values and estimates. This function requires logical operators.
Logical operators in Excel are
used to compare 2 values.
SMP Quranic Science
Boarding School
BASIC STATISTICAL FUNCTIONS
3 Logical If Function
The if logic function is used to determine
decisions based on certain conditions.
Uses the value “true” if the condition is
met or “benar” and uses the value “false”
if the condition is not met or “salah”.
The formula is written as
"=IF(logical_test;value_if_true;
value_if_false)".
SMP Quranic Science
Boarding School
CONCLUSION
Basic functions used in Microsoft Excel to process data
efficiently. Some basic functions used are SUM, COUNT,
SUMIF, COUNTIF and Mathematical Functions that Use
standard arithmetic operators such as addition (+),
subtraction (-), multiplication (*), and division (/). In
addition, Basic Statistical Functions such as AVERAGE,
MAX/MIN and IF Functions are used to compare values
and determine results based on given conditions.
Using TRUE values if the conditions are met and FALSE if
the conditions are not met.
SMP Quranic Science
Boarding School
What was the
most interesting
part of today’s
lesson?
SMP Quranic Science
Boarding School
THANK YOU !
ANY QUESTION ?