Spreadsheet Basics and Excel Functions
Translated by
ScribdTranslationsSpreadsheet Basics and Excel Functions
Translated by
ScribdTranslationsAbo Hayan Attaouhidi High School
Level: Common core
Module2:Software
ChapterIII:Spreadsheets
Prof: Ouijdane AICH
I. Introduction
II. The features of a spreadsheet
III. The work environment
IV. Development of a spreadsheet (formulas, functions)
2 2
I. Introduction
a spreadsheet is a software that processes
the tables in a dynamic way and
to automate their calculations.
3 2
Examples
Microsoft Office Excel
Gnumeric
OpenOffice Calc
4
II. Basic features of a
spreadsheet
A spreadsheet is an application software that
allows to:
Create, manipulate arrays.
Calculate data
Present data in the form of a graph
5 6
6
III. The environment
of work
7
Electronic document
Binder Contains several worksheets
A leaf An electronic board
of calculation Contains rows and columns
Intersection of a row and a column
Cell An address or a reference
8
Excel formulas
9
IV. Development of a spreadsheet
Excel formulas
▪ Formulas are equations that perform
calculations on the values of a spreadsheet
▪ A formula begins with an equal sign '='
Example:
= 38+
10
IV. Development of a spreadsheet
1. The EXCEL formulas
▪ Formulas are equations that perform
calculations on the values of a spreadsheet
▪ A formula starts with an equal sign " = "
Example:
11
11
Excel formulas
a. Arithmetic operators
ComparisonMeaning(If ...)
A1 is less than A2
A1 is less than or equal to A2
B7<>G7 B7 is different from G7
R1> S2 R1 is larger than S2
A2>=E1 A2 is greater than or equal to E1
C4<D5 C4 is smaller than D5
12
1. The EXCEL formulas
b. RELATIVE ADDRESSING
Relative addressing of cells allows for gaining
time during a document update. If the
the formula needs to be reproduced several times, you just have to
copying from one cell to one or more others.
13 2
IV. Development of a spreadsheet
2. The EXCEL functions
▪ Functions are formulas
predefined that perform
calculations using
particular values called
arguments
Example
14
15