excel 2007 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
EXCEL 2007 PowerPoint Presentation
Download Presentation
EXCEL 2007

Loading in 2 Seconds...

play fullscreen
1 / 13

EXCEL 2007 - PowerPoint PPT Presentation


  • 69 Views
  • Uploaded on

EXCEL 2007. Part 3. What we know so far. Enter Data Enter Simple Formulas – Basic Arithmetic Symbols Select Cells – Click/Drag, Ctrl-Click, Shift-Click Format Cell Contents – Bold , Italic , Underline Insert Cell Borders Standard Error Values Format Numbers – Comma Style, Decimals

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 2007' - prescott-ellison


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
what we know so far
What we know so far . . .
  • Enter Data
  • Enter Simple Formulas – Basic Arithmetic Symbols
  • Select Cells – Click/Drag, Ctrl-Click, Shift-Click
  • Format Cell Contents – Bold, Italic, Underline
  • Insert Cell Borders
  • Standard Error Values
  • Format Numbers – Comma Style, Decimals
  • Column Width
  • Insert Columns/Rows
this lesson
This Lesson
  • Centre Align Cell Contents
  • Format Decimals
  • Sum a Column of Data
  • Selecting and Renaming Worksheets
  • Moving and Copying Worksheets within a Workbook
ribbon groups used home tab
Ribbon Groups Used – Home TAB

Centre

Alignment

Decimal

Formatting

AutoSum

open spreadsheet
Open Spreadsheet
  • Save as Stats
  • Change Column Widths
  • Format Headings as Bold
open spreadsheet1
Open Spreadsheet
  • Format columns C and D to two (2) Decimal places
  • Centre Align Headings in Row 3
auto sum
Auto Sum
  • Click in Cell C11
  • Click AutoSum
  • Press Enter

AutoSum

selecting renaming worksheets
Selecting & renaming worksheets

Home Tab Cells Group

Insert / Delete / Format

Insert New Worksheet

  • Right-click Sheet 1 Tab
  • Rename
    • Type Birth Stats
    • Repeat for Sheet 2, renaming it Daily Weights
  • Delete
    • Right-click Sheet Tab
    • Select Delete from Short-cut Menu
moving a worksheet
Moving a worksheet
  • Change the Worksheet Order
    • Click Sheet 4 tab drag to new position between Birth Stats and Daily Weights
  • Use the guide to help you determine placement
copying a worksheet
copying a worksheet
  • Similar to Moving a Worksheet
  • Hold Ctrl Key as you drag to the new position
    • A small + will appear on the pointer to show that you are making a copy.
  • Right-Click Shortcut menu also gets you Worksheet Options to rename, copy or move worksheets
open birthday2 xlsx
Open birthday2.xlsx
  • Ensure Column Widths are wide enough to hold contents and centre align cells A3 to D3.
  • Remove the formula in cell D10 and replace it with AutoSum button.
  • Rename the worksheet Home.
  • Make a copy of worksheet Home and rename it Park.
  • In the Park worksheet edit the formula in cell D11 (per child calculation) to divide by 10.
  • Edit the data in columns A, B and C on the Park worksheet so that it looks like this:
  • Save the spreadsheet as Birthday3.xlsx