1 / 17

Day 3: excel chapter 1

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

nura
Download Presentation

Day 3: excel chapter 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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Day 3:excel chapter 1 Tazin Afrin taafrin@mix.wvu.edu August 27, 2013

  2. Record attendance • http://cs101.wvu.edu/tools/record-attendance/

  3. Entering data • Enter four types of data • Text • Values • Dates • Formulas

  4. 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

  5. Entering data Text Date Values Formula (=C5*D5+C5)

  6. Arithmetic operation • Addition (+) • Subtraction (-) • Multiplication (*) • Division ( / ) • Exponentiation ( ^ )

  7. 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.

  8. Order of precedence • Controls the sequence in which excel performs • Parenthesis () • Exponentiation ^ • Multiplication * • Division / • Addition + • Subtraction -

  9. Order of precedence Value changed for parenthesis

  10. 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

  11. 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.

  12. Manage worksheets • Rename worksheets • Change tab color • Insert • Delete • Move • Copy

  13. Manage columns and rows • Insert cells, columns and rows • Delete cells, columns and rows • Adjust column width • Adjust row height • Hide • Unhide

  14. 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.

  15. Move range • Cut and paste or drag selected range. • Copy then paste to destination. • Copy as picture. • Press Esc to deselect copied range.

  16. Next class • Formatting • Page setup • Printing

  17. Please LOG OFF

More Related