TRENTO SCHOOLS - BUILDING A BRIGHT FUTURE

MICROSOFT EXCEL 6. Formula Bar

1 2 3 4
It is an Application Software known worldwide as a
Spreadsheet, which allows performing Mathematical calculations,
Statistical, Financial, etc. It also allows for creating graphs.
statisticians, manage Database.

CHARACTERISTICS:
5 6
. An Excel file with the .xls extension is a Workbook.
CALCULATION SHEET
. Each workbook opens by default with 3 worksheets,
being able to add or remove sheets. Active Cell Column Labels
. A spreadsheet contains 256 columns and 65,536 rows.
. The intersection of a column and a row is called a Cell.
. A set of two or more cells is called a Range.
. When a workbook is saved, it is saved with the sheets that
contain.
. The columns are labeled by letters.
. The rows are labeled with numbers.

Steps to enter the program:

Home / Programs / Microsoft Office / Microsoft Office Excel

Labels of Leaves of
Rows Calculation
EXECUTECELL:
MANIPULATING DECALCULATION LEAVES:
Home / Run / Excel

DESCRIPTION OF THE EXCEL WINDOW: By simply right-clicking on any of the sheets of

calculation will display a menu with a list of options (Insert,
Title Bar Delete, Rename, Label Color, etc.), select
Menu Bar any of the alternatives will execute the action
3. Standard Bar corresponding.
4. Format Bar
5. Name Box (Indicates the location of the active cell)

PROFESSORALANESTRADA- COMPUTING
 TRENTO SCHOOLS - BUILDING A BRIGHT FUTURE

When choosing the Insert option, a window will open, select

the Spreadsheet option (this is selected by default) and
Accept. Right click on
the row label

Write the value

customized

Accept

ENTERING INFORMATION IN THE CELLS.

You can enter two types of data in an active cell:

a CONSTANTVALUE, which can be a numeric value

or a text (understood as any data that to the
less contain a character whether it is a letter, space in
white, an asterisk, a dash, etc.
When a number is entered, it is aligned by default to the
to the right of the cell and when it is text, it aligns to the
left of the cell.

b. A FORMULA, which is a sequence of values, references

CUSTOMIZE THE COLUMN HEADER: of cells, names, functions or operators that produce a
new value.

Right click on the Text

column label
Number
Write the value
customized Formula
Accept

PROFESSOR ALANESTRADA - COMPUTING

 Schools TRENT - BUILDING A BRIGHT FUTURE
INSERT OR DELETE COLUMNS AND ROWS. SELECTCELLS:

Para seleccionar una o varias celdas, dar un clic en una celda

Initial and drag the mouse to the Final cell (Range).
Right click
about the label Another way to select cells is to click on a cell.
Column or Row. Initially, press the Shift key and click on the Final cell.
Select Insert
to Delete
To select a column,
With this form we can also perform the action of Cut. click on the label of the
Copy and Paste a Column or Row. It can also be applied to the column when the cursor
cells. I switched to Arrow .

GENERARLISTASAUTOMÁTICAS.

This action allows generating numbered lists from a value.

determined.
Select the cell To select a row, give a
Place the mouse cursor click on the row label
in the lower corner when the cursor changes to
to the right of the cell, until Arrow .
that changed to
Press the Ctrl key
+ +
Hold down a click and
drag the mouse.

Automatically is
To select all the
generara una lista
Click on the sheet
numbered.
Button of
Intersection.

PROFESSORALANESTRADA - COMPUTING
 TRENTO SCHOOLS - BUILDING A BRIGHT FUTURE

FORMATO DECELDAS
To carry out these
The actions of Font type, Size, N, K, S, Alignment of actions are taken
texts (Left, Center, Right, and Justify), Text color and from the Menu
Cell (fill) adjustments are made from the formatting bar. Format - Cells.

COMBINE
CELLS.-This action
it is done by pressing the Each cell can have a different format, these can be:
button Combine y Number - Alignment - Source - Borders - Patterns - Protect, these
Center that is located applications allow formatting of the cells.
in the format bar
.

NUMBER, allows
The cell format also allows for the customization of values. give a format
numerical such as: Currency type, Date, Time, Address of customized to the
Text, Borders and Fill, etc. numbers, type of
moneda, fecha, hora
and other formats
more.
Borders and Shadows

Customize Numbers

Coins

Date and Time

FONT allows you to format text such as font type.
Text direction color, subrayado, tamaño, estilos, etc.

PROFESSORALANESTRADA - COMPUTING
 TRENT colleges - BUILDING A BRIGHT FUTURE

PROTECT A
SHEET.

Select the Sheet.

ALIGNMENT
allows to align the Menu - Tools.
text inside the
cells and give the type of Protect - Protect Sheet
orientation.
Write the password

Accept.

PROTECT THE CELLS.

Select the entire spreadsheet

Deactivate the locker

EDGES Y Select the desired cells

TRAMAS, give to the
cells the style and Block (activate) the locker
line color, like this
like the color of Protect the Sheet
filling.
HIDE
FORMULAS

Activate the locker

PROTECT, it is used to protect the cells, that is to say to
prevent changes from being made or that the formula is not visible Protect the Sheet
could contain the cell.

TEACHER ALANESTRADA - COMPUTING

 SCHOOL TRENTO - BUILDING A BRIGHT FUTURE

EXCEL FORMULAS (2010, 2013, 2016, 2019)

A formula IS A CALCULATION OPERATION THAT

IT IS THE CORE OF AN EXCEL SHEET. The When a formula
formulas can be used for multiple purposes: from performing it is copied to the
simple operations, such as addition and subtraction, to complex ones right or left
financial, statistical, and scientific calculations. yes modify the
Every formula... column. =B2*B3 =C2*C3 =D2*D3
Put an equal sign (=) before.
There should be no blank spaces.
TYPES OF REFERENCES:
Entering formula
values =35+105+79.5-15 Relative References.- It is the predetermined cell that makes
directly inside reference to its position and that adjusts automatically to
of the formula any change of the formula. Example: A1, C5, D10, etc.

Absolute Reference.- It is that cell that refers to a

specific location, so that if the cell's position changes
what the formula contains; it remains unchanged and is not adjusted.
These cells are expressed with the dollar sign in front of them.
Formula using cells column and in front of the row: $B$5, $H$10, etc.
as a reference
CALCULATION OPERATORS IN THE FORMULAS.
To copy a formula, select the cell and position the cursor.
in the bottom corner of the cell until the course The operators specify the type of calculation you want to execute on
change to + the elements of a formula. There are four types of operators
+ of calculation:

dereference operators
When a formula
it copies upward =B3*C3 Operador Significado Example
or down it goes =B4*C4 : Until D5:G10 They are those who
modifica la Fila. =B5*C5
Sum combine cells.
=B6*C7 Merge cells
,ó; (A5, C4, D3)
=B7*C6 discontinuous
Operator of
space E1:E5 F4:F1
intersection

PROFESSORALANESTRADA - COMPUTING
 TRENTON SCHOOLS - BUILDING A BRIGHT FUTURE

FUNCTIONS
ARITHMETIC OPERATORS

Operator Meaning Example They are built-in formulas that accelerate the speed of the
+ Sum 3+5
calculation.
They are those who Formula =(A1+A2+A3+A4+A5+A6)
- Stay 10-5 Function =Sum(A1:A6)
they generate a result
* Multiplication 5*8 numeric.
Syntax of a Function. Every function accepts values called
/ Division 60/5
arguments.
% Percentage 19%
Start of the Name of the
^ Power 4 Function Function

=Average(B5:B12)
COMPARISON OPERATORS
Operator Arguments
Operator Meaning Example
= Same A5=F4 STATISTICAL FUNCTIONS.
> Greater than D2>E1
They are those who
and as a result SUM FUNCTION. AVERAGE FUNCTION.
< Less than A7<C5 a logical value
Greater than or equal Sum all the numbers of a Returns the average (mean
>= G2>=E2 (True or False). range. arithmetic) of the arguments.
what
<=
Less than or equal to
B3 is less than or equal to A7 =Sum(number1,number2,…) =Average(number1,number2,...)
what
<> Different from D4<>E6

TEXT CONCATENATION OPERATORS.

They are those that serve to unite (concatenate) one or more
text strings in order to generate a single text element.

Operator: & ("and")

Meaning: Connects or concatenates two values to generate a
value of continuous text.
Ejemplo: “Viento”&”norte”

PROFESSORALANESTRADA - COMPUTING
 TRENT SCHOOL - BUILDING A BRIGHT FUTURE

ROUND FUNCTION. MAXIMUM FUNCTION. COUNT FUNCTION.

Round a number to the Returns the maximum value of Count the cells that contain
number of decimals a list of numbers. text elements and values
specified. =Max(Range) numerical.
=Round(Number,0) =Count(Range)

For example, for column B

(numbers) and column C (text),
the result is 5.

FUNCTION
[Link].
Count the number of cells.
MINIMUM FUNCTION. COUNT FUNCTION.
that are found without data.
Return the minimum value Count those that contain
=COUNTBLANK(Range)
from a list of numbers numbers.
=Min(Range) =Count(Range)

CONDITIONAL FORMAT

It is a dynamic format that allows you to give font color,

size, cell color, etc.; to a specific group of cells, if the
the specified condition is true.
Menu: Format - Conditional Format

PROFESSORALANESTRADA- COMPUTING
TRENTON SCHOOLS - BUILDING A BRIGHT FUTURE

FOR AUGUST 23

CELL VALIDATION.

It consists of specifying the type of data that is allowed in a

cell, such as text, integers, dates, and the range of the
valid data.
Menu: Data – Validation

Configuration:
Allow.- Choose the type of data you want to assign to a
cell.
Data.- The comparison operator is chosen.
Initial Value.- The initial value is introduced.
Final Value.- The final value is introduced.

Mensaje de Entrada.
Explain the type of data that can be entered in the cell.

Error Message.
It is the message that appears when the user inputs data
incorrect in the cell.

PROFESSOR ON THE ROAD - COMPUTING

 TRENT UNIVERSITY - BUILDING A BRIGHT FUTURE
LOGICAL FUNCTIONS.

Conditional Statistical Functions.

COUNTIF FUNCTION.
Count the cells that
they comply a criterion
determined.
=COUNTIF(Range, Criteria)
In the example, they count
the cells that contain
>10 numbers. (Criterion)

SUMIF FUNCTION.
Sum the cells that
match the criteria
determined.
=SUMIF(Range, "Criteria",
Sum_Range
In the example, add the
quantity of Colors
(Criterion).

PROFESSOR ALANESTRADA - COMPUTING

TRENTO SCHOOLS - BUILDING A BRIGHT FUTURE

PROFESSORALANESTRADA - COMPUTING