Transcript Excel Project One

Excel Project One
INT197B – Spring 2005
What is Excel?

Spreadsheet program with four parts
–
–
–
–
Worksheets – where you enter, calculate,
manipulate, and analyze data
Charts – visual representation of relationships
among data
Database – manage data (sort, search, select)
Web support – save in html format, access real
time data using web queries
How do you plan a spreadsheet?

Identify the following:
–
–
–
–
Needs
Source of data
Calculations
Chart requirements
First Excel Project




Extreme Blading Company
Needs: sales tracking report
Source of data: financial analyst
Calculations:
–
–
–

total sales for each of four product groups
total second quarter sales for each of four sales channels
second quarter sales for the company
Chart requirements: 3-D column chart comparing
amount of sales for each product group within each
sales channel
Start Excel






From start button begin Excel
Right-click the Language bar
Click Close the Language bar
Click the Getting Started task pane Close button in
the upper-right corner of the task pane
If the toolbars are positioned on the same row, click
the Toolbar Options button
Click Show Buttons on Two Rows
The Excel Worksheet




Row (numbered)
Column (lettered)
Cells (A1, C5)
Toolbars (invoke commands and functions)
Selecting a cell



Use mouse to move the block plus sign to
the cell and then click
Use arrow keys to select cells
A cell is active when a heavy border
surrounds the cell
Start entering text (EX 17)





Click cell A1
A1 becomes the active cell and a heavy border
surrounds it
Enter text “Extreme Blading”
Text displays in the formula bar and in A1
The text in A1 is followed by the insertion point (a
blinking vertical line), indicates where the next typed
character will display
Continue Project One

Follow the instructions for Project One
beginning on page EX 17
Summary





Start and Quit Excel
Describe the Excel worksheet
Enter text and numbers
Use the AutoSum button to sum a range of
cells
Copy a cell to a range of cells using the fill
handle
Summary




Copy a cell to a range of cells using the fill
handle
Format a worksheet
Create a 3-D Clustered column chart
Save a workbook and print a worksheet
Summary




Open a workbook
Use the AutoCalculate area to determine
statistics
Correct errors on a worksheet
Use the Excel Help system to answer
questions