|
Microsoft Office Excel 2003 is a powerful spreadsheet
program designed for organizing, formatting, and calculating numeric data.
Excel displays data in a row-and-column format, with gridlines between the
rows and columns, similar to accounting ledger books or graph paper.
Consequently, Excel is well suited for working with numeric data for
accounting, scientific research, statistical recording, and any other
situation that can benefit from organizing data in a table-like format.
Teachers often record student grade information in Excel, and managers
often store lists of data—such as inventory records or personnel
records—in Excel. As you work through this course, you’ll learn how Excel
makes it easy to perform calculations on numeric data and provides dozens
of ways to format data for presentation purposes, including charts and
reports.
Creating a workbook
Start Excel, create a standard workbook, and close the workbook
In this exercise, you start Excel, create a standard workbook, and close
the workbook.
On the Windows taskbar, click the Start button, point to All Programs,
point to Microsoft Office, and click Microsoft Office Excel 2003.
Excel opens with Book1 ready for you to use.
Display the New Workbook task pane by clicking the
Other Task Panes button and clicking New Workbook.
In the New section of the New Workbook task pane, click Blank Workbook.
Excel creates a workbook called Book2, and the task pane disappears.
On the File menu, click Close.
Excel closes Book2, and Book1 reappears.
Keep this file open for the next exercise.
Understanding Microsoft Excel Elements
The image below shows many of the parts of an excel window
(you can open a larger image of it by clicking on the picture. When
you want to return here click the Back button on your browser)
The following table describes the elements in the Excel window.
Element Description
Title bar
Identifies the current program and the name of the current workbook
Menu bar
Lists the names of the menus in Excel
Toolbars
Give you quick access to functions that you use frequently, such as
formatting, aligning, and totaling cell entries; the Standard and
Formatting toolbars appear by default
Name Box
Displays the address of the active cell
Formula bar
Displays the contents of the active cell
Task pane
Lets you open files, paste data from the Clipboard, create blank
workbooks, and create Excel workbooks based on existing files
Ask A Question box
Allows you to query the Help system; help topics that match your request
are displayed in the task pane
Status bar
Displays information about a selected command; it also indicates the
status (on or off) of the Caps Lock and Num Lock keys
Scroll bars
Include a vertical and a horizontal scroll bar and four scroll arrows,
each used to display different areas of the worksheet
Select All button
Selects every cell in a worksheet
Sheet tabs
Identify the worksheets in the open workbook; click a tab to display a
worksheet
Tab scrolling buttons
Let you display and navigate sheet tabs
Worksheet
A grid of vertical columns (identified by alphabetic characters) and
horizontal rows (identified by numeric digits); columns and rows intersect
to form cells; each cell can be identified by a full-cell reference, or
address, consisting of the column and row coordinates of that cell—for
example, B3
Active cell
The cell, designated by a thick border that will be affected when you type
or edit data
Minimize button
Minimizes the window to a button on the taskbar
Maximize/Restore Down
Toggles (switches back and forth) between maximizing a window and
restoring a window to its previous size
Close Window button
Closes the current workbook window
ScreenTip
A small pop-up box that displays the name of an object or a toolbar button
when you point to it with the mouse pointer
|
|
Entering Text in a worksheet
Click cell A1, type
Sales, and press Enter.
The text is
entered in cell A1, and A2 becomes the active cell.
Click cell A3,
type Cabins, and press Enter.
Cell A3 contains
the word Cabins, and the active cell moves to A4.
Type Condos, and
press Enter.
The word Condos
is entered in cell A4.
Keep this file open for more...
Entering numbers in a worksheet
A numeric entry contains some combination of the digits 0 through 9
and,optionally, the following special characters.
Character Used
To
+ Indicate a
positive value
- or ( ) Indicate a negative value
$ Indicate a currency value
% Indicate a percentage
/ Indicate a fraction
.
Indicate a decimal value
, Separate the digits of the entry
When you
start an entry with a plus sign to indicate a positive number, Excel
ignores the sign. When you type parentheses to indicate a negative number,
the number appears with a minus sign. When you include a dollar sign, a
percent sign, a forward slash, a comma, or an exponential symbol, the
program automatically assigns a numeric format to the entry.
By default, a numeric entry appears right-justified in a cell. When the
entry is longer than the defined width of the cell, it appears in
scientific notation, as pound signs (####), or rounded. Internally,
however, Excel stores all numbers as originally entered.
Click cell B3, type 42848, and press Enter.
The number is entered in cell B3, and B4 becomes the active cell.
Type 92346, and press Enter.
The number is entered in cell B4, and B5 becomes the active cell.
Keep this file open for more again
Entering Dates in a worksheet
Dates in Excel
worksheets can be represented using only numbers or a combination of text
and numbers. For example, January 22, 2004, and 1/22/04 are two ways of
entering the same date. Like text, dates are often used as row and column
labels. But unlike text, dates are considered serial numbers; they are
sequential and can be added, subtracted, and used in calculations.
Click cell B1, type January 2005, and press Tab.
Excel abbreviates
the date to Jan-05, and C1 becomes the active cell.
Type Feb 2005, and press Tab.
Excel uses the
same date formatting as above, and Feb-05 is entered in cell C1. D1 is now
the active cell.
Keep this file open
Entering a range of data
To enter data in an individual cell, you type the data and then press
Enter. When you have several consecutive entries to make, you can select
the range first to enter the data more quickly. For example, you might
have several rows listing expenses and columns that label the expenses by
day of the week. When you select the range first, you simply type the raw
expense figures and press Enter. When you get to the bottom cell of a
column in the range and press Enter, the insertion point automatically
jumps to the first cell in the next column of the range
Click cell C3, drag to cell D4, and release the mouse button.
Cells C3,
C4, D3, and D4 are selected.
Type 39768, and press Enter.
The number is entered in cell C3, and C4 becomes the active cell.
Type 90426, and press Enter.
The number is entered in cell C4, and D3 becomes the active cell.
Type 45122, and press Enter.
The number is entered in cell D3, and D4 becomes the active cell.
Type 87409, and press Enter.
The number is entered, and cell C3 becomes the active cell.
Saving the file
After completing this part of the assignment you need to save your
work.
Save As changing the file name to "Lodging Sales".
Close the Workbook by clicking "File" on the menu bar and then choosing
"Close" leaving Excel open for the next part of
this assignment.
Opening an existing file.
Now, click "File" on the menu bar; notice Excel displays a list of
recently opened workbooks at the bottom of the File meni
On the File menu click "Lodging Sales" and the file opens.
Renaming a Worksheet
By default, the worksheets in each Excel workbook are named Sheet1,
Sheet2, and Sheet3. Just as giving a unique name to your workbook helps
you remember what is in it, renaming a worksheet can remind you of its
contents. For example, a chain of restaurants might have a budget workbook
that contains a worksheet for each restaurant location.
In this exercise, you give a worksheet a different name.
Double-click the Sheet1 sheet tab.
Sheet1 is selected within the tab.
Type the name of the imaginary development where we are selling cabins
and so forth, Tar Pit Pines, and press Enter.
Tar Pit Pines appears on the sheet tab.
Keep this file open for the next exercise.
Save this workbook again and email the file as an attachment to me. |