1 / 14

CONTACT TORY ROBINSON 819-2489 edpm_edu_magghigh@yahoo.com edpminstitute.yolasite.com

CONTACT TORY ROBINSON 819-2489 edpm_edu_magghigh@yahoo.com edpminstitute.yolasite.com. ELEECTRONIC DOCUMENT PREPARATION AND MANAGEMENT SCHOOL: MAGGOTTY HIGH SUMMER SCHOOL 2012 SESSION #1 ACTIVITY: SPAPP123EDPMMAGHIG H APPLICATION SOFTWARE: MICROSOFT OFFICE EXCEL 2007

yachi
Download Presentation

CONTACT TORY ROBINSON 819-2489 edpm_edu_magghigh@yahoo.com edpminstitute.yolasite.com

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. CONTACTTORY ROBINSON819-2489edpm_edu_magghigh@yahoo.comedpminstitute.yolasite.com created by: Tory Robinson

  2. ELEECTRONIC DOCUMENT PREPARATION AND MANAGEMENT SCHOOL: MAGGOTTY HIGH SUMMER SCHOOL 2012 SESSION #1 ACTIVITY: SPAPP123EDPMMAGHIGH APPLICATION SOFTWARE: MICROSOFT OFFICE EXCEL 2007 OPERATING SOFTWARE: WINDOWS XP TOPIC: SPREADSHEET APPPLICATION created by: Tory Robinson

  3. INTRODUCTION TO SPREADSHEET A spreadsheet can be defined as an electronic worksheet that is made of grid lines in which you enter data to be processed into useful information. These are special tools used to arrange and analyze data and to do complex calculations with great speed and efficiency. created by: Tory Robinson

  4. Examples of Spreadsheet software • Lotus 1-2-3 • Coral • Quattro Pro • Excel created by: Tory Robinson

  5. Some basic components of a spreadsheet • Work Book • Work Sheet • Columns • Rows • Formula • Cell • Cell referencing created by: Tory Robinson

  6. Let us take a closer at the items listed above. • Workbook – this is the combination of multiple work sheets on one specific task. For e.g. a student data file. • Worksheet – this is a single page that you work on. For e.g. sheet 1. created by: Tory Robinson

  7. The spreadsheet grids are made of column and rows. The columns are indentified by letters and the run up and down the page. The rows are identified by number and they run across the page. New Microsoft Office Excel Worksheet.xlsx created by: Tory Robinson

  8. Cell - This is the intersection where a row and column meets. • Cell reference – this is cell name or cell address. • Formula – This is a mathematical equation which the spreadsheet application use to bring a result. created by: Tory Robinson

  9. Working with formula As stated before if you want to find out or to do some mathematical function using a spreadsheet application you would have to use some sort of formula. created by: Tory Robinson

  10. How to write and use a formula? In order to get a result you will need a formula or select one from the function menu box. created by: Tory Robinson

  11. The equal sign (=) must be present in all formulas. • The formula must have the cell address of the cells you will work with and not the NOT the number. created by: Tory Robinson

  12. How to enter a formula? • Select the cell where you want the result to appear. • Write the formula. • E.g. of a formula is =sum(A1:E5) OR =SUM(A5-E5) created by: Tory Robinson

  13. SIGNS USED IN MICROSOFT EXCEL FORMULA: created by: Tory Robinson

  14. THE END created by: Tory Robinson

More Related