Day 3: excel chapter 1

1 / 17

Day 3: excel chapter 1 - PowerPoint PPT Presentation

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

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

PowerPoint Slideshow about 'Day 3: excel chapter 1' - nura

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

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
• Can be any number
• Dates
• Long form and short form
• Current date (ctrl + ;)
• Current time (ctrl + shift + ;)
• Formulas

=A1+A2

Entering data

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

Arithmetic operation
• Subtraction (-)
• Multiplication (*)
• Division ( / )
• Exponentiation ( ^ )
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
• Controls the sequence in which excel performs
• Parenthesis ()
• Exponentiation ^
• Multiplication *
• Division /
• Subtraction -
Order of precedence

Value changed for parenthesis

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
• 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
• Rename worksheets
• Change tab color
• Insert
• Delete
• Move
• Copy
Manage columns and rows
• Insert cells, columns and rows
• Delete cells, columns and rows
• Hide
• Unhide
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
• Cut and paste or drag selected range.
• Copy then paste to destination.
• Copy as picture.
• Press Esc to deselect copied range.
Next class
• Formatting
• Page setup
• Printing