Download
spreadsheet software n.
Skip this Video
Loading SlideShow in 5 Seconds..
Spreadsheet Software PowerPoint Presentation
Download Presentation
Spreadsheet Software

Spreadsheet Software

128 Views Download Presentation
Download Presentation

Spreadsheet Software

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Spreadsheet Software

  2. IS goals: efficiency, improving effectiveness, improving decision-making • Efficiency: • Speed, Cost, Time & Effort • Effectiveness: • Quality of output, accuracy, presentation & comprehensiveness • Improved decision-making • Requires 3 factors, sufficient information, communication and time

  3. Efficient software functions: • =Sum(A2:A10) • =MAXIMUM(A2:A10) • =MINIMUM(A2:A10) • =AVERAGE(A2:A10) • If function: =IF(D2>=2000,"Gold",IF(D2>=1000,"Silver",IF(D2>=50,"Bronze","")))

  4. Efficient software functions: • =COUNT(F13:F16) • =COUNTIF(E2:E19,"Gold") • OR =COUNTIF(D2:D13,"above") =VLOOKUP(c2,$F$2:$G$12, 2)

  5. Efficient software functions • Use of naming ranges and Vlookup: • Cell protection • Graphs • Relative & absolute cell references • Electronic validation