CONTENTS
In this learning guide we will
cover the following learning
outcomes.
Select and prepare resources
Plan spreadsheet design
Create spreadsheet
Produce simple charts
Finalize spreadsheets
SPREADSHEET
What is spreadsheet?
A spreadsheet is a computer application that
is designed to add, display, analyze, organize,
and manipulate data arranged in rows and
columns.
It is the most popular application for
accounting, analytics, data presentation, etc.
Or in other words, spreadsheets are scalable
grid-based files that are used to organize data
and perform calculations.
CONT…
People all across the world use
spreadsheets to create tables for personal
and business usage.
You can also use the tool’s features and
formulas to help you make sense of your
data.
You could, for example, track data in a
spreadsheet and see sums, differences,
multiplication, division, and fill dates
automatically, among other things.
CONT…
Microsoft Excel, Lotus 1-2-3, Google sheets,
Apache open office, LibreOffice, etc are some
spreadsheet software.
Among all these software, Microsoft Excel is
the most commonly used spreadsheet tool and it
is available for Windows, macOS, Android, etc.
What makes a spreadsheet software program
unique is its ability to calculate values using
mathematical formulas and the data in cells.
CONT…
• These programs allow users to work with
data in a variety of ways to create
budgets,
forecasts,
inventories,
schedules,
charts,
graphs and many other data based
worksheets.
CONT…
A collection of spreadsheets is known as a
workbook.
Every Excel file is called a workbook.
Every time when you start a new project
in Excel, you’ll need to create a new
workbook.
To create a new worksheet or access an
existing one, you can either start from
scratch or utilize a pre-designed template.
below is a basic example of what a microsoft
excel spreadsheet looks like, with all the
important features of a spreadsheet highlighted.
F E AT U R E S O F S P R E A D S H E E T
As we know that there are so many
spreadsheet applications available in the
market.
So these applications provide the following
basic features:
1. Rows and columns: Rows and columns
are two distinct features in a spreadsheet that
come together to make a cell, a range, or a
table.
CONT…
In general, columns are the vertical
portion of an excel worksheet, and
there can be 256 of them in a
worksheet,
Whereas rows are the horizontal
portion, and there can be 1,048,576 of
them.
CONT…
The color light green is used to highlight Row 2,
while the color green is used to highlight Column A.
CONT…
2. Formulas: In spreadsheets, formulas process data
automatically.
It takes data from the specified area of the spreadsheet as
input then processes that data, and then displays the output
into the new area of the spreadsheet according to where the
formula is written.
In Excel, we can use formulas simply by typing “=Formula
Name(Arguments)” to use predefined Excel formulas.
When you write the first few characters of any formula,
Excel displays a drop-down menu of formulas that match
that character sequence.
CONT…
Some of the commonly used formulas are:
=SUM(Arg1: Arg2): It is used to find the sum of all
the numeric data specified in the given range of
numbers.
=COUNT(Arg1: Arg2): It is used to count all the
number of cells(it will count only number) specified
in the given range of numbers.
=MAX(Arg1: Arg2): It is used to find the maximum
number from the given range of numbers.
=MIN(Arg1: Arg2): It is used to find the minimum
number from the given range of numbers.
CONT…
=TODAY(): It is used to find today’s date.
=SQRT(Arg1): It is used to find the square
root of the specified cell.
= AVERAGE(D2:D7):The range of values
on which you want to average is defined by
D2:D6. The formula is located near the
name field on the formula tab.
We wrote =AVERAGE(D2:D6) in cell D9, therefore
the average becomes (2 + 3 + 4 + 5 + 6 + 7)/6 = 27/6
= 4.5.
So you can quickly create a workbook, work on it,
browse through it, and save it in this manner.
CONT…
3. Function: In spreadsheets, the function uses a
specified formula on the input and generates output.
Or in other words, functions are created to perform
complicated math problems in spreadsheets without
using actual formulas.
For example, you want to find the total of the numeric
data present in the column then use the SUM function
instead of adding all the values present in the column.
4. Text Manipulation: The spreadsheet provides
various types of commands to manipulate the data
present in it.
CONT…
5. Pivot Tables: It is the most commonly
used feature of the spreadsheet.
Using this table users can organize,
group, total, or sort data using the
toolbar.
Or in other words, pivot tables are used
to summarize lots of data.
It converts tons of data into a few rows
and columns.
USE OF SPREADSHEETS
The use of Spreadsheets is endless.
It is generally used with anything that contains
numbers.
Some of the common use of spreadsheets are:
Finance: Spreadsheets are used for financial data like
it is used for checking account information, taxes,
transaction, billing, budgets, etc.
Forms: Spreadsheet is used to create form templates
to manage performance review, timesheets, surveys,
etc.
CONT…
School and colleges: Spreadsheets are most
commonly used in schools and colleges to
manage student’s data like their attendance,
grades, etc.
Lists: Spreadsheets are also used to create lists
like grocery lists, to-do lists, contact detail, etc.
Hotels: Spreadsheets are also used in hotels to
manage the data of their customers like their
personal information, room numbers, check-in
date, check-out date, etc.
COMPONENTS OF SPREADSHEETS
The basic components of spreadsheets are:
CONT…
Worksheet: rectangular grid of rows
(numbers) and columns (letters)
Cell: intersection of row and column.
Cell reference: unique address, coordinates
of the intersection of a column and row (B7)
Gridlines: horizontal and vertical lines.
