TLE_ICT_WEEK6

TLE- ICT and

Entrepreneurship

Mam Milchie

Performing Advance

Calculations Using Electronic

Spreadsheets

Different concept in TLE

Internet is an electronic communication network
for the interconnection of computers to access
different websites.



Online Survey is a questionnaire created as web
forms that provides summary of responses and
percentage of each question.


Google form is a free service in making online
survey or poll offered by Google.

12

Electronic spread sheet application program
is designed to perform basic to advanced mathematical and arithmetic operations.
-Microsoft Excel is one example of the most used electronic spreadsheets.
-Google Sheets is an online spreadsheet
developed by Google.

Propriety Software

also known as non-free software or closed- source software, is computer software for which the software’s publisher or another person retains intellectual property rights,
usually copyright of the source code, but
sometimes patent rights.

Open Source

is a source code that is
made freely available for possible modification and redistribution.

Functions

-are calculations that return a result.
To create and enter functions, always
start with an equal sign (=).
- The inputs in functions are called
arguments. Arguments can be in a form of
numbers, cell references, or texts.

SUM Function:
• To get the sum of the values in column X of the
table, you type the formula below and you will
get 36
=SUM(B9:B13)

• To get the sum of the values in column X and
column Z, you type the formula below and you
will get 65
=SUM(B9:B13,D9:D13)

PRODUCT Function
• To get the product of the values in column X of
the table, you
type the formula below and you will get 16800
=PRODUCT(B9:B13)

• To get the product of the values in the first row
of the table, you type the formula below and you
will get 240
=PRODUCT (B9: D9)

QUOTIENT Function:

• To get the quotient of the value in the first cell of
the table as the numerator and 2 as the
denominator, you type the formula below and
you will get 6
=QUOTIENT(B9,2)

MOD Function:

• To get the remainder of the value in the
first cell of the table and as the divisor,
you type the formula below and you will
get 0
=MOD(B9,2)

SUMPRODUCT Function
• If you want to multiply the values in
column X and column Y of
the table and then add the products, you type
the formula below and you will get 298

=SUMPRODUCT(B9:B13,C9:C13)

SUMIF Function

• If you want to add only the values in column X that are
larger than 5, you type the formula below and you will get
27
=SUMIF(B9:B13, ">5")
• If you want to add only the values in column Z, where the
corresponding cells in column X is larger than 5, you type
the formula below and you will get 19

=SUMIF(B9:B13, ">5", D9:D13)

SUMSQ Function
• If you want to get the sum of the squares of
the values in column X, you type the formula
below and you will get 307

=SUMSQ(B9:B13)

SUMIFS Function

• If you want to add the values in column Z only if two conditions
are met:o The corresponding cells in column X is larger than 5, and o
The corresponding cells in column Y is smaller than 5.then
you type the formula below and you will get 0
=SUMIFS(D9:D13, B9:B13, ">5", C9:C13, "<5")
• If you want to add the values in column Z only if two conditions
are met:o The corresponding cells in column X is smaller than 10,
ando The corresponding cells in column Y is larger than 5. then
you type the formula below and you will get 22
=SUMIFS(D9:D13, B9:B13, "<10", C9:C13, ">5")

ROUND Function
• After dividing the value in the first cell of
the table by the value in the second cell to
the right of the table, you want to round the
result to two decimal places, you type the
formula bbelow and you will get 1.2
=ROUND(B9/C9, 2)

Note:
If you cannot remember the description
and syntax of the functions,
just use the Insert function button to look
for the function. The corresponding
description and syntaxwill be displayed.

SHORT QUIZ

True or False. Write your answers
________1. MS Excel is one of the most commonly used
computerized worksheet.
________2. SUMPRODUCT is a function that returns the remainder after a number is divided by a divisor.
________3. Using the formulas and functions will help you increase the accuracy ofyour calculations while decreasing the amount of time you need to spend.
________4. MS Excel is widely used in accounting and financial
applications, statistics, engineering calculations, as well as in
analyzing data.
________5. To create and enter functions without the equal (=) sign, excel will still calculate a result.

Answer the following
1. How can an electronic spreadsheet help an entrepreneur run a business?
2. Can we rely on an electronic spreadsheet to deliver an accurate output? Why?
3. How would you compare and differentiate the features of proprietary software and those of open source software?