MICROSOFT EXCEL
ING. MARVIN G. SOTO SOTELO
Meeting 11 – CCoommoo ttrraabbaajjaarr eenn eell eennttoorrnnoo EExxcceell ..
The basic Microsoft Excel work environment is a workbook file that can
contain one or more spreadsheets . A spreadsheet is similar to an accounting book, with
numbers, text, and calculation results aligned in columns and rows. But unlike a book of
accounting, when you enter the numbers in Microsoft Excel, the program is the one that executes the
calculations instead and electronically.
With Microsoft Excel, it is easy to enter information within a spreadsheet and the power
to change, delete or add data to that information. You do not have to worry if initially your
data has not been perfectly entered or has not been completely done. Always
you can change them or finish entering them later. You can order several sheets within a workbook
(for example, you can put in a book all the sheets belonging to a single client or
a single project) and then give them a name to quickly locate the
] information you need.
In this lesson, you will learn how to work with the sheets and workbooks;
will also learn to open, save and close a book and enter and edit data from a spreadsheet. Also
will learn to work more effectively if you use the AutoComplete features and
AutoCorrection that will help you perform some of your work and introduce simple formulas.
I nninicitio nt o f th e ssessment
Start using Excel, for this, go to the Start Menu – Programs – Microsoft Excel. In the
following illustration we can see the elements that appear on the screen.
LESSON 1 – HOW TO WORK IN THE EXCEL ENVIRONMENT.
PAG.1 / 62
INFORMATION TECHNOLOGIES – PANI
MICROSOFT EXCEL
ING. MARVIN G. SOTO SOTELO
PPaarrtteess ddee llaa VVeennttaannaa ::
The title bar indicates the name of the application and the active workbook in this
moment.
The Menu Bar, contains all the commands of Excel 97.
The Toolbar, consists of a series of buttons that allow you to carry out actions on
the Spreadsheet directly, by clicking on they, without having to access the corresponding command
in the menu. By default in Excel there are 2 toolbars, Standard and
Format, respectively.
The Formulas Bar, where the content of a cell of the spreadsheet is edited and modified,
is composed of three sections, the first one referring to the active cell, that is, the one in
that we can edit, modify or enter data. The second section is activated when we are
entering data appear two buttons, cancel, or accept the entered data and the third
section edits the actual content of the cell.
Work Area, is the part of the Excel window that contains the window, or windows of the
open and visible documents, it can be empty if there is no workbook open.
Book sheets, scroll sheets, allows us to move between the different worksheets. If
are all visible, we can move to them by means of the scroll buttons of
labels, placed in front of them.
LESSON 1 – HOW TO WORK IN THE EXCEL ENVIRONMENT.
PAGE.2 / 62
INFORMATION TECHNOLOGIES – PANI
MICROSOFT EXCEL
ING. MARVIN G. SOTO SOTELO
State Bar, gives us on the left side, information on the status of the sheet or on the
function of a selected button or command.
CCóommoo aabbrriirr uunn lliibbrroo ddee ttrraabbaajjoo
When you start an Excel session we open a Workbook New, Book1, but if what we
want is to open an existing Workbook, that is, previously saved, we can do it from
in several ways, by pressing the Open button on the Standard toolbar, or scroll to the
File – Open menu.
The Open dialog box appears. In this dialog box, select the Workbook with
that you want to work with. The text box labeled Search in, shows the currently selected folder
if the workbook you are looking for can not be found in it, display the list
that appears in the Search in box and locate the book searched in the different Units of
Disk and Folders.
Once you have selected the Workbook you want to open, double-click on it.
GGuuaarrddaarr aarcchhiivvoo ccoonn uunn nnuueevvoo nnoommbbrree
When you save a file, give it a name and specify where you want to store it. Press
Save as from the File menu to display the Save As dialog box.
In the text box labeled Save in, find the place where you want to save your workbook
and in the File name box, enter the name you want to store it with
(Try to save the name relationship with the work done).
Press the Save button, or press Enter, to close the dialog box and save the file.
CCóommoo ddeessppllaazzaarrssee aa ttrraavveess dde uunn lliibbrroo ddee ttrraabbaajjoo
In Microsoft Excel, files are called workbooks. The books may contain several
spreadsheets, as well as chart sheets. In the following lessons you will learn, "Creating
graphs to evaluate trends and relationships", we will talk a little more about graphs and sheets of
graphs. In this lesson, you will learn how to scroll through a spreadsheet and through a workbook
that contains spreadsheets.
DDeessppllaazzaammiieennttoo aa ttrraavveess dde uunn lliibbrroo ddee ttrraabbaajjoo
A new Workbook contains three spreadsheets. You can select different sheets of a
book by pressing the sheet labels at the bottom of each sheet. You can use the
scroll sheet shift buttons to retrieve sheet labels that were hidden from
so you can also select them if you wish. The selected sheet is renamed the active sheet
.
Additionally, you can select multiple sheets at once, even if they are non-adjacent sheets, and
enter the same data on all active sheets at the same time. This is particularly useful
if you need to set up multiple sheets that are identical in some aspects (such as
adding common labels in a monthly report).
LESSON 1 – HOW TO WORK IN THE EXCEL ENVIRONMENT.
PAG.3 / 62
INFORMATION TECHNOLOGIES – PANI
MICROSOFT EXCEL
ING. MARVIN G. SOTO SOTELO
SSeelleecccciioonarr hhoojjaass ddee ccaallccuulloo dde uunn lliibbrroo
Select different sheets of a book; press the sheet label with the name Sheet2, Sheet2
becomes the active sheet. By clicking on the different leaf labels at the bottom of the screen, we
scroll through them.
Use the right mouse button to press a sheet label scroll button,
a shortcut menu appears with the names of all the sheets that are contained in the book, if
click on any of them we move to the selected sheet.
SSeelleecccciioonarr vvaarriiaass hhoojjaass aa vveezz
Select multiple sheets at the same time. All selected sheets are activated and, if you enter
data in one of the sheets, they will be automatically entered in all other active sheets.
Press the label on Sheet1, and hold down SHIFT and press the sheet label3, the
sheets1, 2 and 3 have been selected and activated. The word [Grupo] appears in the title bar
next to the file name.
Use the right mouse button to press the sheet label2, in the context menu, press
Ungroup sheets.
Only Sheet2 will remain active.
If the group of sheets you want to select are not adjacent, press and hold the
CONTROL key and press the labels on the sheets.
PPeeddiirr aayyuuddaa aall AAoyuuddaannttee of OOffffiiccee
If you want to know more about scrolling through the sheets, you can get help from
Office Assistant.
You can close any suggestion or message in the Office Assistant by pressing ESC.
OOffffiiccee AAyyuuddaannttee
In this book, the Office Assistant will not appear in the illustrations. If you want the illustrations
to match, at the time the Office Assistant appears, use the right mouse button
to press the Office Assistant, and then select Hide Assistant. If you want to leave the
Office Assistant at the top to guide you, but not trip over it, simply drag it to
another area of the screen.
In the What do you want to do area, enter Learn to scroll through a spreadsheet, and then
click Search.
Press the Books and spreadsheets topic.
Read the Help topic, to finish, press the Close button in the Help window.
DDeessppllaazzaammiieennttoo aa ttrraavveess ddee uunnaa hhoojjaa ddee ccaalccuulloo
A sheet consists of columns and rows. The columns are arranged vertically and identified with
letters at the top. These letters are the column headers. The rows are arranged in the form
LESSON 1 – HOW TO WORK IN THE EXCEL ENVIRONMENT.
PAG.4 / 62
TECNOLO
from Nettech Post http://bit.ly/2SfYiuo
No hay comentarios:
Publicar un comentario