Excel project
Download
1 / 27

Excel Project - PowerPoint PPT Presentation


  • 251 Views
  • Uploaded on

Excel Project 1: Creating a Worksheet and an Embedded Chart ... Type Inline Skates and then press the DOWN ARROW key. Repeat the previous step for the ...

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Excel Project' - Kelvin_Ajay


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Excel project l.jpg

Excel Project

Part 1

Creating a Worksheet and an Embedded Chart


Objectives l.jpg
Objectives

  • 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


Objectives3 l.jpg
Objectives

  • 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


Objectives4 l.jpg
Objectives

  • Open a workbook

  • Use the AutoCalculate area to determine statistics

  • Correct errors on a worksheet

  • Use the Excel Help system to answer questions


Starting excel l.jpg
Starting Excel

  • Click the Start button on the Windows taskbar, point to All Programs on the Start menu, point to Microsoft Office on the All Programs submenu, and then point to Microsoft Office Excel 2003 on the Microsoft Office submenu

  • Click Microsoft Office Excel 2003

  • If the Excel window is not maximized, double-click its title bar to maximize it



Entering the worksheet titles l.jpg
Entering the Worksheet Titles

  • Click cell A1

  • Type Extreme Blading in cell A1 and then point to the Enter box in the formula bar

  • Click the Enter box to complete the entry

  • Click cell A2 to select it. Type Second Quarter Sales as the cell entry. Click the Enter box to complete the entry



Entering column titles l.jpg
Entering Column Titles

  • Click cell B3

  • Type Direct Mail in cell B3

  • Press the RIGHT ARROW key

  • Repeat the last two steps for the remaining column titles in row 3, as shown on the following slide



Entering row titles l.jpg
Entering Row Titles

  • Click cell A4. Type Inline Skates and then press the DOWN ARROW key

  • Repeat the previous step for the remaining row titles in column A, as shown on the following slide



Entering numbers l.jpg
Entering Numbers

  • Click cell B4

  • Type 58835.35 and then press the RIGHT ARROW key

  • Enter 97762.50 in cell C4, 71913.73 in cell D4, and 85367.37 in cell E4

  • Click cell B5

  • Enter the remaining fourth quarter sales provided on the next slide for each of the three remaining product groups in rows 5, 6, and 7



Summing a column of numbers l.jpg
Summing a Column of Numbers

  • Click cell B8

  • Click the AutoSum button on the Standard toolbar

  • Click the AutoSum button a second time


Copying a cell to adjacent cells in a row l.jpg
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 C8:E8

  • Release the mouse button


Determining multiple totals at the same time l.jpg
Determining Multiple Totals at the Same Time

  • Click cell F4

  • With the mouse pointer in cell F4 and in the shape of a block plus sign, drag the mouse pointer down to cell F8

  • Click the AutoSum button on the Standard toolbar

  • Select cell A9 to deselect the range F4:F8



Changing the font type l.jpg
Changing the Font Type

  • Click cell A1 and then point to the Font box arrow on the Formatting toolbar

  • Click the Font box arrow and then point to Arial Rounded MT Bold

  • Click Arial Rounded MT Bold



Bolding a cell l.jpg
Bolding a Cell

  • With cell A1 active, click the Bold button on the Formatting toolbar


Increasing the font size of a cell entry l.jpg
Increasing the Font Size of a Cell Entry

  • With cell A1 selected, click the Font Size box arrow on the Formatting toolbar

  • Click 24 in the Font Size list


Changing the font color of a cell entry l.jpg
Changing the Font Color of a Cell Entry

  • With cell A1 selected, click the Font Color button arrow on the Formatting toolbar

  • Click Violet (column 7, row 3) on the Font Color palette


Centering a cell entry across columns by merging cells l.jpg
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


Formatting the worksheet subtitle l.jpg
Formatting the Worksheet Subtitle

  • Select cell A2

  • Click the Font box arrow on the Formatting toolbar and then click Arial Rounded MT Bold

  • Click the Bold button on the Formatting toolbar

  • Click the Font Size box arrow on the Formatting toolbar and then click 16

  • Click the Font Color button on the Formatting toolbar


Formatting the worksheet subtitle26 l.jpg
Formatting the Worksheet Subtitle

  • Select the range A2:F2 and then click the Merge and Center button on the Formatting toolbar


Excel project 1 end of part 1 l.jpg

Excel Project 1 end of part 1

Due: Friday, October 17 2008


ad