Transcript Excel Project One

Excel Project One
CIS101
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




Dynamite Music Fourth Quarter Sales
Needs: sales report for each product group
Source of data: Chief Financial Officer (CFO)
Calculations:




total sales for each of four product groups
total fourth quarter sales for each of four stores
fourth quarter sales for the company
Chart requirements: 3-D column chart
comparing amount of sales for each product
group within each store
Start Excel



From start button begin Excel
Remove new workbook task pane
Set up 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 (1.17)





Click cell A1
A1 becomes the active cell and a heavy
border surrounds it
Enter text “Dynamite Music”
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 1.17
Summary of Project One





Enter and format data (text and
numbers)
Select a single cell, or use the mouse to
select a range of cells
Use auto sum function
Apply auto format to a selection of cells
Name a cell
Summary cont.





Create and embed a chart in a specific
location on your worksheet
Use Excel help system
Save, print, and re-open your
worksheet
Use the Auto Calculate area
Fix errors and change information