1 / 80

Lab 1

Lab 1. Creating and Editing a Worksheet. Objectives. Enter, edit, and clear cell entries. Save, close, and open workbooks. Specify ranges. Copy and move cell entries. Enter formulas and functions. Adjust column widths. Change cell alignment. Format cells. Insert rows.

yasir-hill
Download Presentation

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. 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. Lab 1 Creating and Editing a Worksheet

  2. Objectives • Enter, edit, and clear cell entries. • Save, close, and open workbooks. • Specify ranges. • Copy and move cell entries. • Enter formulas and functions. • Adjust column widths. • Change cell alignment. • Format cells. • Insert rows. • Insert and size a ClipArt graphic. • Enter and format a date. • Preview and print a worksheet.

  3. Concepts • Template - A workbook file that includes predefined settings that can be used as a pattern to create many common types of workbooks. • Text and Numeric Entries - Information or data you enter in a cell can be text, numbers, or formulas. • AutoCorrect– A feature that makes some basic assumptions about the text you are typing and, based on these assumptions, automatically corrects the entry. • Column Width - The size or width of a column controls how much information can be displayed in a cell.

  4. Concepts • Range - A selection consisting of two or more cells on a worksheet is a range. • Formulas - A formula is an entry that performs a calculation. • Relative Reference - A cell or range reference in a formula whose location is interpreted by Excel in relation to the position of the cell that contains the formula. • Functions - Functions are prewritten formulas that perform certain types of calculations automatically.

  5. Concepts • Recalculation - Whenever a number in a referenced cell in a formula changes, Excel automatically recalculates all formulas that are dependent on the changed value. • Alignment - Settings that allow you to change the horizontal and vertical placement and the orientation of an entry in a cell. • Fonts - Fonts consist of typefaces, point sizes, and styles that can be applied to characters to improve their appearance.

  6. Concepts • Number Formats - Number formats affect how numbers look onscreen and when printed. • Styles - A combination of formats that have been named and that can be quickly applied to a selection. • Graphics - Anon-text element or object, such as a drawing or picture that can be added to a document.

  7. Outline • Exploring Excel 2002 • Starting Excel 2002 • Exploring the Excel Window • Exploring the Workbook Window • Moving around the Worksheet • Creating New Workbooks • Changing Column Widths • Using the Default Workbook Template • Developing a Workbook

  8. Outline • Entering and Editing Data • Entering Text • Clearing an Entry • Editing an Entry • Using AutoCorrect • Entering Numbers • Changing Column Widths • Dragging the Column Boundary • Using AutoFit

  9. Outline • Saving, Closing and Opening Workbooks • Saving a New Workbook • Closing a Workbook • Opening an Existing Workbook • Duplicating Cell Contents • Using Copy and Paste • Using the Fill Handle • Inserting Copied Cells • Moving Entries

  10. Outline • Working with Formulas • Entering Formulas • Copying Formulas • Using Pointing to Enter a Formula • Recalculating the Worksheet • Inserting Rows

  11. Outline • Formatting the Worksheet • Changing Cell Alignment • Indenting Entries • Centering Across a Selection • Changing Fonts and Font Styles • Applying Character Effects • Using Undo • Using Format Painter • Formatting Numbers • Using Styles • Adding Color

  12. Outline • Working with Graphics • Inserting Graphics • Sizing Graphics • Entering the Date • Previewing and Printing a Workbook • Exiting Excel 2002 • Lab Review

  13. EXPLORING EXCEL 2002

  14. STARTING EXCEL 2002 • Excel Window • Title Bar • Name of open file • Menu Bar • Workbook Window • Information about the workbook

  15. EXPLORING THE EXCEL WINDOW • Standard toolbar • Formatting toolbar • Formula bar • Name box • Task pane • Document window

  16. EXPLORING THE WORKBOOK WINDOW • Workbook window • New blank workbook file • Three blank worksheets • Worksheet • Spreadsheet • Rows • 65, 536 total rows down • Columns • 256 columns to the right

  17. THE WORKSHEET • Row numbers • Column letters • Cell • Cell selector • Active cell • Reference • Sheet tabs • Active sheet • Tab scroll buttons

  18. Keys Action [Page Down] Moves cell selector down one full window [Page Up] Moves cell selector up one full window [Alt] + [Page Down] Moves cell selector right one full window [Alt] + [Page Up] Moves cell selector left one full window [Ctrl] + [Home] Moves cell selector to upper left corner [Home] Moves cell selector to beginning of row [End] [] Moves cell selector to last-used cell in row [End] [] Moves cell selector to last-used cell in column MOVING AROUND THE WORKSHEET Using Keys

  19. Mouse Action Click scroll arrow Scrolls worksheet one row/column in direction of arrow Click above/below scroll box Scrolls worksheet one full window up/down Click right/left of scroll box Scrolls worksheet one full window right/left Drag scroll box Scrolls worksheet multiple windows up/down or right/left MOVING AROUND THE WORKSHEET Using the Mouse

  20. CREATING NEW WORKBOOKS • Blank workbook • Default settings • Most commonly used settings • Stored as workbook template

  21. Concept 1: TEMPLATE • File that includes predefined settings • Default settings stored in Book.xlt • Used as a pattern • Other templates available • Balance sheets • Expense statements • Loan amortizations • Sales invoices • Timecards

  22. DEVELOPING A WORKBOOK • Plan • Enter and edit • Test • Format

  23. ENTERING AND EDITING DATA • Enter data by moving to a cell • Type in entry

  24. Concept 2: TEXT AND NUMERIC ENTRIES • Text entries • Any combination of letters, numbers, spaces • Any other special characters • Numeric entries • Digits 0-9 • Special characters +-(),$ %  • Formula • Variable • Constant

  25. ENTERING TEXT • Entering text • Headings • Alignment • Complete entry using • Clearing an entry • Editing an entry

  26. Key Action [Home] Moves insertion point to beginning of entry [End] Moves insertion point to end of entry [] Moves insertion point one character right [] Moves insertion point one character left MOVING THE INSERTION POINT Keys

  27. Concept 3: AUTOCORRECT • Makes basic assumptions about text you are entering • Automatically corrects entry • Features • Capitalization at the beginning of a sentence • Incorrect capitalization due to accidental use of the Caps Lock key • Corrects many common typing and selling errors

  28. ENTERING NUMBERS • Not necessary to add … • Comma to separate thousands • Currency ($) symbol • Excel displays number entries right-aligned in the cell

  29. CHANGING COLUMN WIDTHS

  30. Concept 4: COLUMN WIDTH • Default column width setting is 8.43 • Average # of digits that can be displayed in a cell • Increase column width to display the largest entry • If larger than column width, text entry is truncated if cell to right contains data • Column width automatically increased for numeric entries

  31. HOW TO CHANGE COLUMN WIDTHS Options • Drag the column boundary • Format/Row/Height • Use AutoFit • Double click column boundary • Format/Column/AutoFit

  32. EXCEL SAVING, CLOSING AND OPENING WORKBOOKS • Saving a new workbook • Closing a workbook • Opening an existing workbook

  33. DUPLICATING CELL CONTENTS • Quickly copy cell contents • Move information to another area on the worksheet

  34. Concept 5: COPY AND MOVE • Source or copy area • Destination or paste area • Office XP Office Clipboard can store up to 24 items that have been cut or copied

  35. Concept 6: RANGE • A selection of two or more cells • Adjacent range • Rectangular block of adjoining cells • Nonadjacent range • Two or more selected cells or ranges that are not adjoining

  36. WORKING WITH ENTRIES • Using the Fill Handle • Inserting copied cells • Moving entries

  37. REVIEW OF COPYING AND MOVING METHODS Three methods to copy or move and entry: • Use the Copy, Cut, and Paste commands. • Use the Edit/Fill command: Right, Left, Up, or Down, or drag the fill handle. • Drag the cell border of the selection to move. Hold down [CTRL] key while dragging a selection to copy.

  38. WORKING WITH FORMULAS Example A:=5*4-3Result is 17 (5 times 4 to get 20, and then subtract 3 for a total of 17) Example B: =5*(4-3)Result is 5 (4 minus 3 to get 1, and then 1 times 5 for a total of 5)

  39. Concept 7: FORMULAS • Formula • Equation that performs a calculation on data contained in a worksheet • Always begins with an equal sign = • Arithmetic Operators • Addition + • Subtraction - • Multiplication * • Percent % • Exponentiation ∧ • Operands

  40. FORMULAS • Entering formulas • Copying formulas

  41. Concept 8: RELATIVE REFERENCES A cell or range reference in a formula whose location is interpreted by Excel in relation to the position of the cell that contains the formula

  42. Concept 9: FUNCTIONS • Functions – prewritten formulas that perform certain types of calculations automatically • Syntax is: = Function name (argument1, Argument2,...) • Argument - data the function uses to perform the calculation

  43. COMMON FUNCTIONS

  44. USING POINTING TO ENTER A FORMULA • Pointing • Makes the process of entering and copying entries easy • Use the [CRTL] + [ENTER] keys to copy entries to a range of cells • Select range first • Enter data • Use [CTRL] + [ENTER] to copy

  45. Concept 10: RECALCULATION • Automatic recalculation whenever a number in a referenced cell in a formula changes • All formulas dependent on the changed value are affected Why is this one of the most powerful features of Excel?

  46. INSERTING ROWS • Insert\Row • Single row • Move cell pointer to row immediately below where you want the new row • Multiple rows • Select a range of rows

  47. FORMATTING THE WORKSHEET • Format • Font (different type styles and sizes) • Color • Patterns • Borders • Number formats • Commas • Dollar signs

  48. Concept 11: ALIGNMENT • Horizontal placement • Vertical placement • Orientation

  49. MORE ON FORMATTING • Indenting entries • Centering across a selection

  50. Concept 12: FONT • A set of characters with a specific design • Typeface • Serif fonts • Sans serif fonts • Size • Points

More Related