Spreadsheet Application
Spreadsheet Application
Spreadsheet Application
iWork LibreOffice
Numbers of Calc (Free)
Apple
OpenOffice Lotus
Calc (Free) Symphony
Spreadsheets
of IBM
Microsoft Excel
Forms
Form templates can be created to handle inventory, evaluations, performance reviews, quizzes, time sheets, patient
information, and surveys.
Lists
Managing a list in a spreadsheet is a great example of data that does not contain numbers, but still can be used in a
spreadsheet. Great examples of spreadsheet lists include telephone, to-do, and grocery lists.
Sports
Spreadsheets can keep track of your favorite player stats or stats on the whole team. With the collected data, you can
also find averages, high scores, and statistical data. Spreadsheets can even be used to create tournament brackets.
Reference: https://www.computerhope.com/jargon/s/spreadsheet.htm#examples
Basic Excel Formulas
1. SUM
The SUM function is the first must-know formula in
Excel. It usually aggregates values from a selection
of columns or rows from your selected range.
=SUM(number1, [number2], …)
Reference:
https://corporatefinanceinstitute.com/resources/excel/study/basic-
excel-formulas-beginners/
Basic Excel Formulas
2. AVERAGE
The AVERAGE function should remind you of
simple averages of data such as the average
number of shareholders in a given shareholding
pool.
=AVERAGE(number1, [number2], …)
Reference:
https://corporatefinanceinstitute.com/resources/excel/study/basic-
excel-formulas-beginners/
Basic Excel Formulas
3. COUNT
The COUNT function counts all cells in a given
range that contain only numeric values.
=COUNT(value1, [value2], …)
Reference:
https://corporatefinanceinstitute.com/resources/excel/study/basic-
excel-formulas-beginners/
Basic Excel Formulas
4. COUNTA
Like the COUNT function, COUNTA counts all cells
in a given rage. However, it counts all cells
regardless of type. That is, unlike COUNT that only
counts numerics, it also counts dates, times, strings,
logical values, errors, empty string, or text.
=COUNTA(value1, [value2], …)
Reference:
https://corporatefinanceinstitute.com/resources/excel/study/basic-
excel-formulas-beginners/
Basic Excel Formulas
4. COUNTA
Like the COUNT function, COUNTA counts all cells
in a given rage. However, it counts all cells
regardless of type. That is, unlike COUNT that only
counts numerics, it also counts dates, times, strings,
logical values, errors, empty string, or text.
=COUNTA(value1, [value2], …)
Reference:
https://corporatefinanceinstitute.com/resources/excel/study/basic-
excel-formulas-beginners/
Basic Excel Formulas
5. IF
The IF function is often used when you want to sort
your data according to a given logic. The best part
of the IF formula is that you can embed formulas
and function in it.
Reference:
https://corporatefinanceinstitute.com/resources/excel/study/basic-
excel-formulas-beginners/
Basic Excel Formulas
6. MAX & MIN
The MAX and MIN functions
help in finding the maximum
number and the minimum
number in a range of values.
=MIN(number1, [number2],
…)
Reference:
https://corporatefinanceinstitute.com/res
ources/excel/study/basic-excel-formulas-
beginners/
Resources