[go: up one dir, main page]
Scribd
Upload
42 views36 pages

Familiarizing With Spreadsheet Application: Prepared By: Joanne Fel A. Ogoc

This document provides an introduction to using Microsoft Excel spreadsheets. It explains that Excel allows performing mathematical operations without manual calculation by showing only the results. Key parts of an Excel document are described such as workbooks, spreadsheets, cells, rows, columns, and tabs in the ribbon interface. Common arithmetic, comparison, text, and reference operators used in Excel formulas are defined. Commonly used functions like SUM, AVERAGE, COUNT, MIN, and MAX are also outlined. The document provides examples of creating basic formulas and using functions in Excel. It aims to familiarize users with the spreadsheet application.

Uploaded by

Aileen Malapit
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
42 views36 pages

Familiarizing With Spreadsheet Application: Prepared By: Joanne Fel A. Ogoc

This document provides an introduction to using Microsoft Excel spreadsheets. It explains that Excel allows performing mathematical operations without manual calculation by showing only the results. Key parts of an Excel document are described such as workbooks, spreadsheets, cells, rows, columns, and tabs in the ribbon interface. Common arithmetic, comparison, text, and reference operators used in Excel formulas are defined. Commonly used functions like SUM, AVERAGE, COUNT, MIN, and MAX are also outlined. The document provides examples of creating basic formulas and using functions in Excel. It aims to familiarize users with the spreadsheet application.

Uploaded by

Aileen Malapit
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 36

FAMILIARIZING

WITH
SPREADSHEET
APPLICATION
Prepared by: Joanne Fel A. Ogoc
Are you familiar with these mathematical expressions? Do you
still use calculators?
MANUAL COMPUTATION

• essential to daily life, specifically the four basic


arithmetic operations
• used for on-the-spot computation
How would you compute a certain problem if you cannot even
perform the mathematical operations manually?
What is Microsoft
Excel?
MICROSOFT EXCEL
• is a spreadsheet
application used to
perform mathematical
equations without
manual computation. It
shows only the results
of the given operations
and data.
EXCEL

● Workbook
- the term for Excel
document
● Spreadsheet
- portion (a page) of
the workbook
FORMULAS
• work like normal arithmetic operations but the equal
sign (=) must be entered first before other values
FUNCTIONS
• specialized
operations with
assigned names of
actions that use
formulas and return
values
PARTS OF
AN EXCEL
DOCUMEN
T
• Quick Access Toolbar
• Ribbon
• Name Box
• Formula Bar
• Column Letter
• Row Number
• Sheet Tabs
• Status Bar
PARTS OF AN EXCEL DOCUMENT
• Cell - is a rectangular box where you can input your values.
• Row Number - shows the number in a row of the currently
selected cell.
• Column Letter - shows the letter in a column of the currently
selected cell.
• Name Box - shows the currently selected cell if you select only
one cell.
• Formula Bar- is the long rectangle beside the name box where
you can input your formulas for your data.
PARTS OF AN EXCEL DOCUMENT
• Ribbon - is found on the top of the grid in Excel. You can find
different buttons and tools to edit and customize your data.
• Quick Access Toolbar - allows you to access frequently used
tools such as save, undo, and redo.
• Spreadsheet Tab - also known as sheets, is where you can
select a different sheet to look at its contents. The current sheet you
are working on is highlighted to avoid confusion.
• Status Bar - shows different information about the document.
You can set the layout of how your spreadsheet appears on your
screen.
TABS FOUND IN THE RIBBON OF
EXCEL
• File Tab
• Home Tab
• Insert Tab
• Draw Tab
• Page Layout
• Formulas Tab
• Data Tab
• Review Tab
• View Tab
TABS FOUND IN THE RIBBON OF
EXCEL
• File Tab - shows tools for opening an existing workbook,
creating a new workbook, saving a workbook, printing a
workbook, and other functional tools that are not necessarily
connected to data manipulation or formatting.
• Home Tab - gives you tools to format your table and its
data You can change the font size, font color, alignment, and
other basic formatting options
TABS FOUND IN THE RIBBON OF
EXCEL
• Insert Tab - gives you tools to insert objects such as
images, shapes, tables, graphs, and charts.
• Draw Tab - gives you tools so that you can draw flexibly on
your table or charts when discussing it.
• Page Layout Tab - gives you tools and commands to
format the orientation of your spreadsheet on the screen and
the paper after printing.
TABS FOUND IN THE RIBBON OF
EXCEL
• Formulas Tab - gives you commands to edit, define, audit,
and control formulas.
• Data Tab - gives you commands to connect to external data
or databases to import pre-existing data tables.
• Review Tab - gives you tools and commands for spell
checking, sheet protection, workbook protection, and changes
tracking.
• View Tab - gives you commands to control the view of your
spreadsheet and how you would interact with it.
SPREADSHEET OPTIONS
● Add spreadsheet
● Rearrange spreadsheet
● Rename, color, move, and delete the spreadsheet
● Protect spreadsheet
● Select an entire row or column
● Select a group of cells
● Insert or delete a row or column
● Adjust the size of rows and columns
BASIC FORMATTING

● Font face, size, alignment, and colors


● Number formats
Activity
● Open Microsoft Excel on your computer. Check each
tab on your spreadsheet application and find the
specified tool on the next slide. Categorize each tool
based on the tab where you can find it. Write your
answers on the table given on the next slide.
Activity

● Print ● Table ● Font Size ● Thesaurus


● Lasso ● Save As ● Look Up & ● Calculate
Selection ● Get Data Reference Now
● Insert Bar From ● Translate ● Page Break
Chart Access ● Adjust Preview
● Cell Styles ● Sort Margins ● Print Area
Activity
File Tab Home Tab Insert Tab

Draw Tab Page Layout Tab Formulas Tab

Data Tab Review Tab View Tab


TYPES OF OPERATORS
• Arithmetic
• Comparison
• Text Concatenation
• Reference
ARITHMETIC OPERATORS
● are mathematical operations used in performing
calculations.
COMPARISON OPERATORS
● are logical operators used to compare two values.
The result of the comparison can either be TRUE or
FALSE.
TEXT CONCATENATION OPERATORS
● is used to join or connect two or more words to
create a single word.
REFERENCE OPERATORS
● are used to set a range of cells or values when
computing.
FACTORS TO CONSIDER BEFORE
CREATING A FORMULA
1.Locate the cell
reference of each
piece of data or use
the point-click
method
2.Use Fill Handle to
copy formulas
CREATING A BASIC FORMULA
1. Select the cell where the formula will be entered.
2. Type the equal sign and select the cell that has the
value/s to be computed using the point-click method.
3. Add the operator needed in the formula (arithmetic,
comparison, concatenation, or reference).
4. Select another cell with a desired value (use the point-
click method) and hit Enter.
SPREADSHEET FUNCTIONS
• predefined operations using different formulas
• named after their function
PARTS OF A FUNCTION

Argument
Equal Sign
Function Name
Take Note!

• Creating formulas with added functions has the


same procedure as using operating symbols.
• The only difference is you use function names
instead of operating symbols (as in the image
given on the previous slide)
COMMONLY USED FUNCTIONS
• SUM - is a function that adds all the values of the cells in
the argument.
• AVERAGE - is a function that computes the average
value of the cells in the argument.
• COUNT - is a function that checks the number of cells in
the range given.
• MIN - is a function that looks for the highest value in the
range.
• MAX - is a function that looks for the lowest value in the
range.
• CONCATENATE
FUNCTION
LIBRARY
• Different functions
are available in the
function library,
which can be
found inside the
Formulas tab.
ACTIVITY

• Classify each symbol or sign listed on the next slide


as an Arithmetic Operator, a Comparison Operator,
a Text Concatenation Operator, or a Reference
Operator.
ACTIVITY
● > ● : ● # ● %
● < ● ^ ● <= ● @
● & ● >= ● = ● +
● /
Arithmetic Operator ● ,
Comparison Operator ●Text<> ● -
Concatenation Reference Operator
Operator
ANY QUESTIONS?

You might also like