1 / 13

Excel: Basics

Excel: Basics. Excel Objects, User Interface, and Data Entry. The Excel User Interface. Common Features Application Window Title Bar Menu Bar Toolbars Status Bar Worksheet Window Worksheet Input Area Row and Column Headings Sheet Tabs Scroll Bars. Excel Objects. Excel Application

barr
Download Presentation

Excel: Basics

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. Excel: Basics Excel Objects, User Interface, and Data Entry

  2. The Excel User Interface • Common Features • Application Window • Title Bar • Menu Bar • Toolbars • Status Bar • Worksheet Window • Worksheet Input Area • Row and Column Headings • Sheet Tabs • Scroll Bars

  3. Excel Objects • Excel Application • The Software Application • Workbook • Stored in an Excel data file • Filename has .xlsxextension • Worksheet • Workbook contains 3 by default • Sheet Tabs • Cell • Intersection of a row and a column • Cell Address or Cell Reference (A1, BA542, etc.) • Range • A range is a grouping of two or more cells • Vertical / horizontal grouping of all cells in the dimension • Names are Alpha / Numeric

  4. Excel Data Entry • Data are inputs to Cells • Excel interprets each cell entry as: • Value – numeric constant • Text – any other combination of numeric/nonnumeric chars. • Formula • Each Cell has a Returned Value

  5. Excel Data Entry • Value and Text Entry - the returned value is identical to the entry data • Text • Data Labels like January, February, ... • Value • Numbers that can be used in calculations like 54, 78 • Times or Dates like 2/9/2000

  6. Excel Data Entry - Formula • Formula Entry - the returned value is the result of a computation that may include: • operators • Some formula (arithmetic) operators: * / + - • cell references • Including named cells and/or ranges • A1, B43, A1:D7 • literal values or strings • 46.9, 2.0, 879, January, Monday • worksheet functions and arguments • parentheses • that control the order in which expressions in the formula are evaluated

  7. Excel Data - Formula Entry • Starts with = sign • Examples (assume value A1 is 4, B2 is 3): • Entry: =7+9 Returned Value: 16 • Entry: =A2*5 Returned Value: 20 • Entry: =(A1-B2)*6 Returned Value: 6 • Entry: =“Sat” Returned Value: Sat

  8. Excel Data - Formula Entry • Worksheet Functions a predefined computational task or calculation • Every Function Consists of: • Function Name • Arguments • literal values, cell references, expressions, functions • arguments are separated by commas • argument list is enclosed in parentheses • Example: = SUM(4,6,10,B8)

  9. A Few Functions • Functions: • SUM • AVERAGE • MAX • MIN • COUNT • COUNTIF • SUMIF • ROUND

  10. Why Use Spreadsheet Apps? • Value, Text and Formula Entries can be easily duplicated to other cells • When you copy a cell you are copying both entry and formatting • Formatting refers: • Numeric Formatting • Stylistic Formatting • Copy using: • Home | Copy Home | Paste • Drag n Drop using edge of selection

  11. Copying Considerations • Cell and Range References • Relative • Cell reference adjusts to new location • Absolute • Cell reference does not change • Mixed References • Row Absolute • Column part adjusts, row part does not change • Column Absolute • Row part adjusts, column part does not change

  12. Excel continues • Math operations with multiple spreadsheets • Protection by a password • Conditional formatting • Function If • Function AND • Using IF and AND in a formula • Data tools

  13. Importing Data • Guidelines for importing foreign data: • When possible, save data as tab-delimited ASCII text in a file with a .txt extension; • When data comes from the Web, select a browser that supports Copy/Paste of tagged tables; • When the foreign data format is messed up, use a text editor with Search/Replace, apply placeholder technique, and write the revised data with .txt extension.

More Related