LAUNCHING AND EXPLORING EXCEL
1. Go to the Start Button on the Desktop and press ALL apps
2. Then click on Excel.
Identifying
the items on the Excel program screen:
Menu
bar:
1.
Menu bar contains all the operators which the user wishes to perform on their
Data.
2.
By clicking on each tab user and view the operator. Example: By clicking on
Home tab user can see the operators which allow changing the Font type, size,
and color.
Toolbars:
1.
A wide variety of toolbars displaying buttons which make editing quicker and
easier are available.
2.
Usually Toolbars have only three options: Save, Undo and Redo. Users have an
option of adding any tool they wish to have in Toolbar by simply Customizing
the Toolbar.
Customizing
Toolbars:
1.
By clicking on the small down arrow present beside Toolbar users can Customize
Toolbar.
2.
From the available options, user can select any option by clicking on them.
The
File tab.
In
the top left of the Ribbon in Excel there's a File. This one:
Click
this, and you'll see all the file operations: New, Open, Save, Exit, etc.
Quick
Access
The
small discrete toolbar "Quick Access", where with a single click you
can save, undo, etc., is located just to the right of the File Button.
"Quick Access" can be customized so that you can choose the features
that suit you best. You do this by right-clicking on a button and choosing
Customize Quick Access Toolbar. Alternatively, you can click the small arrow to
the right of the toolbar, which enables you to quickly select and deselect
various features.
The
Workspace
The
workspace is located underneath the Ribbon, and this is where you have your
spreadsheet. The spreadsheet is a huge table with "columns" and
"rows". The columns are named with letters in the "column
headings", and the rows are labeled with row numbers in the “row
headings." By clicking on a column heading, you can select the cells in
the whole column, and the same is true if you click on a row heading. The
“Corner “is in the top left corner of the worksheet. By clicking on the corner,
you can select all the cells in the entire worksheet. The cells are the basic
elements of the worksheet; this is where we type in our data and formulas.
Wherever a row and a column meet, we have a "cell". Each cell in the
worksheet has a unique name. For example, the cell located where column C and
row 4 meet is called "C4". A cell can contain numbers, words, and formulas.
Formulas are kinds of commands that you type into a cell, which make the cell
display the result of a calculation.
Sheet
Tabs
The
“Sheet Tabs” are located just below the worksheet, on the left side. This is
because you can work with multiple worksheets at once. An Excel file is
therefore also called a” Workbook” because it is like a folder containing
several spreadsheets.
The
Sheet Tabs are by default named "Sheet1", "Sheet2" etc.,
but you can give them more meaningful names yourself. You can also delete and
add Sheet Tabs, and thus spreadsheets. If you right-click on one of the Sheet
Tabs, a menu pops up giving you the opportunity to do various things.
You
can add, delete, and copy Sheet Tabs, and thus the spreadsheets they represent.
You can also change the order of the Tabs and give each Tab its own color,
which can facilitate the overview.
Display
Buttons
You
can use the display buttons to adjust the way you view the spreadsheet. When
you start a new spreadsheet, it is displayed in "Normal View", but
you can also view it as a "Page Impression", which is somewhat like
the way it would look if you were to print the sheet.
"Show
page breaks" is another option, where you can view and adjust the page
breaks in the print-out.
Finally,
there is the zoom function, which allows you to enlarge or reduce the view of
the sheet. The zoom function does not affect how the spreadsheet appears on a
print-out. The zoom function is easy to use, but a better way in my opinion is
to hold down the CTRL key on your keyboard while scrolling up and down with the
scroll wheel on your mouse. Of course, this requires that you have a mouse with
a scroll wheel.
Comments
Post a Comment