Excel Project 1

1
Excel Project 1

• Creating a Worksheet and an Embedded Chart

2
Starting Excel
3
Entering the Worksheet Titles
4
Entering Row Column Titles
5
Entering the Numbers
6
Summing a Column of Numbers

• Click cell B8
• Click the AutoSum button on the Standard toolbar
• Click the AutoSum button a second time

7
Copying a Cell to Adjacent Cells in a Row

• With cell B8 active, point to the fill handle
• Drag the fill handle to select the destination
  area, range C8E8
• Release the mouse button

8
Complete the Total
9
Match this Format
10
Insert Your name in A1

• Must first insert a row
• Then type name in call A1

11
Centering a Cell Entry across Columns by Merging
Cells

• With cell A1 selected, drag to cell F1
• Click the Merge and Center button on the
  Formatting toolbar

12
Formatting the Worksheet Subtitle

• Select the range A2F2 and then click the Merge
  and Center button on the Formatting toolbar

13
The 3-D Chart highlight area
14
Adding a 3-D Clustered Column Chart to the
Worksheet
15
Adding a 3-D Clustered Column Chart to the
Worksheet
16
Inserting the chart
17
Positioning and Sizing the Chart
18
Make your chart like this
19
Saving a Workbook

• Create a new folder on your tablet under My
  Documents called CSC 105 Excel
• Save the file as Lastname Extreme Blading.xls
• Continue on with the INKING additions, then
  submit to WebCt.

20
Add Ink Annotations See WebCt
21
Submit to WebCt

• Save file as Lastname Extreme Blading ink.xls
• Submit to WebCt as Assignment 10