office excel 2010 lab 1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Office Excel 2010 Lab 1 PowerPoint Presentation
Download Presentation
Office Excel 2010 Lab 1

Loading in 2 Seconds...

play fullscreen
1 / 26

Office Excel 2010 Lab 1 - PowerPoint PPT Presentation


  • 69 Views
  • Uploaded on

Office Excel 2010 Lab 1. Creating and Editing a Worksheet. What is a spreadsheet?. Think of a spreadsheet as a word processor for numbers. The first was Visicalc – 1979. http://en.wikipedia.org/wiki/VisiCalc EXCEL is Visicalc’s great, great, great grand……. Objectives.

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

Office Excel 2010 Lab 1


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
office excel 2010 lab 1

Office Excel 2010Lab 1

Creating and Editing a Worksheet

what is a spreadsheet
What is a spreadsheet?
  • Think of a spreadsheet as a word processor for numbers.
  • The first was Visicalc – 1979.
  • http://en.wikipedia.org/wiki/VisiCalc
  • EXCEL is Visicalc’s great, great, great grand……
objectives
Objectives
  • Create new worksheets.
  • Enter and edit data.
  • Modify column widths and row heights.
  • Use proofing tools.
  • Copy and paste cell contents.
objectives1
Objectives
  • Create formulas.
  • Insert and delete rows and columns.
  • Format cells and cell content.
  • Hide and unhide rows and columns.
  • Create a basic chart.
objectives2
Objectives
  • Format values as a date.
  • Preview and print a worksheet.
  • Display and print formulas.
  • Change worksheet orientation and scale content.
concept preview
Concept Preview
  • Data
  • AutoCorrect
  • Column Width
  • Spelling Checker
  • Thesaurus
  • Range
  • Formula
concept preview1
Concept Preview
  • Relative Reference
  • Function
  • Recalculation
  • Alignment
  • Row Heights
  • Number Formats
exploring the excel window
Exploring the Excel Window

Blank worksheet in Sheet2

exploring the excel window cont
Exploring the Excel Window cont.

Sheet tabs

Tab scroll buttons

Active sheet

creating a workbook
Creating a Workbook

Title bar displays default file name

Excel Ribbon consists of seven tabs

Formula bar

Name box

creating a workbook cont
Creating a Workbook cont.

Workbook window

Mouse pointer

Status bar

concept data

1

Concept : Data
  • Data you enter in a cell
    • Text
      • Letters, numbers, spaces, & special characters
    • Numbers
      • Only the digits 0 to 9
      • Characters + - () ,. / $ % ? =
    • Formulas used for calculations
concept autocorrect
Concept : AutoCorrect

2

  • Makes basic assumptions about the text you are typing
    • Automatically corrects the entry
    • Automatically corrects many common typing and spelling errors
    • Makes corrections by …
      • Checking against a built-in list
      • Looking for certain types of errors
concept column width

Size of column controls the amount of information displayed in a cell

If text larger than the column width is entered in a cell, data may not be fully displayed.

Column width can be adjusted using the mouse, using the AutoFit feature, or set to an exact value.

Concept : Column Width

3

concept spelling checker

Proposes the correct spelling for:

    • Misspelled words
    • Duplicate words
    • Capitalization irregularities
  • Compares words to the main dictionary
    • Custom dictionary, if one exists

4

Concept : Spelling Checker
concept thesaurus
Concept : Thesaurus

5

  • A reference tool that provides:
    • Synonyms
    • Antonyms
    • Related words for a selected word or phrase
  • Helps to liven up documents by adding interest and variety to the text
concept range
Concept : Range

6

  • A selection of two or more cells on a worksheet
  • Cells can be
    • Adjacent: A rectangular block of adjoining cells
    • Nonadjacent: A range consisting of two or more selected cells or ranges that are not adjoining
concept formula
Concept : Formula

7

  • An equation that performs a calculation on data in a worksheet
    • Always begins with an equal sign (=)
    • Formulas use arithmetic operators (+, -, /, *, %, ^)
    • Calculated result is a variable value
  • Follows the order of precedence, except where overridden by parentheses
concept relative reference
Concept : Relative Reference

8

  • A cell or range reference in a formula whose location is interpreted in relation to the position of the cell that contains the formula
  • When a formula is copied, referenced cells automatically adjust to reflect the new location
concept function
Concept : Function

9

  • Function is a prewritten formula
  • Performs certain types of calculations automatically
  • Function name identifies the type of calculation to be performed
  • Argument is the data the function uses to perform the calculation

=NOW()

concept recalculation
Concept : : Recalculation

10

  • When a number in a referenced cell in a formula changes, Excel automatically recalculates all formulas that are dependent upon the changed value.
  • One of the most powerful features of electronic worksheets.
concept alignment
Concept : Alignment

11

  • Settings allow you to change placement and orientation of the entry in a cell.
    • Horizontal
    • Vertical
    • Angle of text
concept row height
Concept : Row Height

12

  • The size or height of a row measured in points.
  • Default height is 12.75 points.
  • Can be changed manually or set to a specific value.
concept number formats

13

Concept : Number Formats
  • Number formats change the appearance of numbers
  • Does not change the way the number is stored or used in calculations
  • Default number format is General
  • Other formats include:
    • Accounting, Currency, Date, Time, Percentage, Fraction, Scientific, Custom