day 3 excel chapter 1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Day 3: excel chapter 1 PowerPoint Presentation
Download Presentation
Day 3: excel chapter 1

Loading in 2 Seconds...

play fullscreen
1 / 17

Day 3: excel chapter 1 - PowerPoint PPT Presentation


  • 100 Views
  • Uploaded on

Day 3: excel chapter 1. Tazin Afrin taafrin@mix.wvu.edu August 27, 2013. Record attendance. http://cs101.wvu.edu/tools/record-attendance/. Entering data. Enter four types of data Text Values Dates Formulas. Entering data. Text Includes letters, numbers, symbols and spaces Values

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 'Day 3: excel chapter 1' - nura


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
day 3 excel chapter 1

Day 3:excel chapter 1

Tazin Afrin

taafrin@mix.wvu.edu

August 27, 2013

record attendance
Record attendance
  • http://cs101.wvu.edu/tools/record-attendance/
entering data
Entering data
  • Enter four types of data
    • Text
    • Values
    • Dates
    • Formulas
entering data1
Entering data
  • Text
    • Includes letters, numbers, symbols and spaces
  • Values
    • Can be any number
  • Dates
    • Long form and short form
    • Current date (ctrl + ;)
    • Current time (ctrl + shift + ;)
  • Formulas

=A1+A2

entering data2
Entering data

Text Date Values Formula (=C5*D5+C5)

arithmetic operation
Arithmetic operation
  • Addition (+)
  • Subtraction (-)
  • Multiplication (*)
  • Division ( / )
  • Exponentiation ( ^ )
cell reference in formulas
cell reference in formulas
  • Use cell reference instead of actual data
    • Let A1 = 5
    • And B1 = 10
    • Then C1 =A1+B1 instead of 5+10
  • If A1 and B1 changes then C1 will automatically change.
order of precedence
Order of precedence
  • Controls the sequence in which excel performs
    • Parenthesis ()
    • Exponentiation ^
    • Multiplication *
    • Division /
    • Addition +
    • Subtraction -
order of precedence1
Order of precedence

Value changed for parenthesis

auto fill
Auto fill
  • Enables you to copy the contents of a cell or cell range or to continue a series using the fill handle
  • Fill handle is the small black square in the bottom right corner of a cell
    • Copy formulas with auto fill
    • Complete sequence with auto fill
displaying cell formulas
Displaying Cell Formulas
  • The result of a formula appears in a cell.
  • Formula itself appears in the Formula bar.
  • See formulas -
    • Formulas ribbon → show formulas
    • Press the Ctrl+` key combination to display formulas in the worksheet, acts as a toggle
    • ` key is on top left corner of keyboard.
manage worksheets
Manage worksheets
  • Rename worksheets
  • Change tab color
  • Insert
  • Delete
  • Move
  • Copy
manage columns and rows
Manage columns and rows
  • Insert cells, columns and rows
  • Delete cells, columns and rows
  • Adjust column width
  • Adjust row height
  • Hide
  • Unhide
select a range
Select a range
  • Click and drag.
  • Select adjacent cells – shift.
  • Select non-adjacent cells - ctrl.
  • To select an entire column select the column heading.
  • To select an entire row select the row heading.
  • Select current range of data – select+ctrl + A
  • Selects entire worksheets.
move range
Move range
  • Cut and paste or drag selected range.
  • Copy then paste to destination.
  • Copy as picture.
  • Press Esc to deselect copied range.
next class
Next class
  • Formatting
  • Page setup
  • Printing