1 / 22

Basic Spreadsheet Skills Review

Basic Spreadsheet Skills Review. BUS 782. Expression. Arithmetic Operators. +, -, *, /, ^, ( ) Evaluating an expression Examples: 4 + 2 – 1 4 + 2 * 3 3 – 4 / 2 8 / 4 * 2 2 * 3 ^ 2 (2 * 3) + 2 ^ 3. Order of Evaluation. Operator Multiples 1 ( ) Inner to outer, left to right

lthompson
Download Presentation

Basic Spreadsheet Skills Review

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. Basic Spreadsheet Skills Review BUS 782

  2. Expression

  3. Arithmetic Operators • +, -, *, /, ^, ( ) • Evaluating an expression • Examples: • 4 + 2 – 1 • 4 + 2 * 3 • 3 – 4 / 2 • 8 / 4 * 2 • 2 * 3 ^ 2 • (2 * 3) + 2 ^ 3

  4. Order of Evaluation • Operator Multiples • 1 ( ) Inner to outer, left to right • 2. ^ left to right • 3. *, / left to right • 4. +, - left to right

  5. Formula to Expression

  6. ((A+B))*2

  7. Expression to Formula • A / B * C - 2 • A + B * C ^ D • (A + B / (C – 2)) ^ D + 1 • Evaluating an expression: • 4 * 2 + 8 / 4 * 2 ^ 2 – 1 • 18 / 3 ^ 2 * (1 + 2)

  8. Introduction to Excel

  9. What is a spreadsheet? • It is a matrix composed of rows and columns. Columns are identified by letters and rows are identified by numbers. • Columns: A – Z, AA – AZ, BA – Bz,…

  10. Cell & Range • Cell: Intersection of row and column identified by specifying column and row coordinates. • A1, B3 • Range: A group of rectangular shape cells identified by specifying the upper left corner and the lower right corner. • B2:D3, A1:A3

  11. Enter Constant in a Cell • Number: • 2.345, -1000, (1000) • With comma or $: 1,234, $1,234.56 • Fraction: 1 7/9, 1/3 • Percentage: 5.25% • Date: mm/dd/yy (without “=“) • If yy < 30  20yy. If yy>=30  19yy • =Date(2012,9,14) • Time: Min:Sec • 15:25 • Date and time: mm/dd/yy min:sec • Text • Home/Fill/Series

  12. Enter Formula and Function in a Cell • Formula: • Begin with an “=“ • Use operators: +, - , *, /, ^, ( ) to define a formula. • Function: • =SUM(A1:A3) • Formula with function: • =SUM(A1:A3) * 5 + B5/2 • To display formulas: • Formulas/Show Formulas

  13. Cell Reference

  14. Demo Note: Software consists of three parts: INPUT, PROCESS, OUTPUT.

  15. Copy Formula • Drag the source cell • Copy/Paste

  16. Cell Reference • Relative cell reference: After copy, the formula will reference cells with the same relative position as the original formula. • Example: • Value in cell E6: C6*D6 • Absolute Cell Reference: After copy, the formula still references the same cell as the original formula. • Example: • Tax in cell F6: E6*$C$3

  17. AnnualGrowthRate: 5% of the previous year. Compute the forecasted sales for the next 5 years

  18. Mixed Cell Reference • $ColumnRow: $A1 • Column$Row: A$1 • Examples: • =$A1 • =A$1

  19. Cases Where Mixed Cell Reference are Optional

  20. Case that Must Use Mixed Cell Reference

More Related