Tuesday, September 24, 2013

Introduction to Excel

What is a Spreadsheet?
  A spreadsheet is the computer equivalent of a paper ledger sheet.
  It consists of a grid made from columns and rows.
  It is an environment that can make number manipulation easy and somewhat effortless.

Types of Spreadsheets:
Manual – creating a worksheet on a ledger
or columnar paper using a pencil/pen,
  calculator, and eraser.

Electronic – A computer-generated
  spreadsheet that makes the basic tasks much easier.

Spreadsheets are made up of :
 columns – identified with alphabetic headings
 rows - identified with numeric headings
 and their intersections are called cells 
 (Cell references: B4, A20)

In each cell there may be the following types of data:
 text (labels)
 number data (constants)
 formulas (mathematical equations that do all the work) 

Formulas ALWAYS begin with an  =   sign.  This “tells” Excel that a calculation will need to be performed.
Reference cells, NOT the numbers in them!

There are two ways to enter information into a cell:
1. Type directly into the cell.
Click on a cell, and type in the data (numbers or text) and press Enter.
2. Type into the formula bar.
Click on a cell, and then click in the formula bar.  Now type the data into the bar and press Enter.

Microsoft Excel 2007 Window
Microsoft Excel is an electronic spreadsheet. 
 - You can use it to organize your data into rows and columns.
 - You can also use it to perform mathematical calculations quickly.

Microsoft Office Button
When you click the button, a menu appears.
You can use the menu to create a new file,
open an existing file, save a file, and perform many other tasks.

Quick Access Toolbar
provides you with access to commands you frequently use.
By default, Save, Undo, and Redo appear on the Quick Access toolbar.
You use Save to save your file, Undo to rollback an action you have taken,
and Redo to reapply an action you have rolled back.

Title Bar
The Title bar displays the name of the workbook on
which you are currently working. Microsoft Excel
displays the name of the workbook you are currently using.
At the top of the Excel window, you should see
"Microsoft Excel - Book1" or a similar name.

Ribbon
Microsoft Excel 2007, you use the Ribbon to issue commands.
At the top of the Ribbon are several tabs;
clicking a tab displays several related command groups.
 Within each group are related command buttons.
 You click buttons to issue commands or to access
menus and dialog boxes. You may also find a dialog box
launcher in the bottom-right corner of a group. When you
click the dialog box launcher, a dialog box makes additional
commands available.

Cells
The combination of a column coordinate and a
row coordinate make up a cell address.
For example, the cell located in the upper-left
corner of the worksheet is cell A1, meaning column A, row 1.

Formula Bar
If the Formula bar is turned on, the cell
 address of the cell you are in displays
in the Name box which is located on the left side of
 the Formula bar. Cell entries display on the right side
of the Formula bar. Note: The current cell address displays
 on the left side of the Formula bar.

Status Bar
Display information such as the sum, average, minimum, and maximum value of selected numbers. You can change what displays on the Status bar by right-clicking on the Status bar and selecting the options you want from the Customize Status Bar menu. You click a menu item to select it. You click it again to deselect it. A check mark next to an item means the item is selected.

For Complete reference please visit this link:
http://www.baycongroup.com/el0.htm







0 comments:

Post a Comment