1 / 24

Module 4.1: Introduction to Spreadsheets

Module 4.1: Introduction to Spreadsheets. Contents. What is a spreadsheet? Basic functions Inputting data Use of formatting More about different types of data formats Effective input using AutoFill Test and improve knowledge and skill Module Activities. What is a spreadsheet?.

cameron-adams
Download Presentation

Module 4.1: Introduction to Spreadsheets

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. Module 4.1:Introduction to Spreadsheets

  2. Contents • What is a spreadsheet? • Basic functions • Inputting data • Use of formatting • More about different types of data formats • Effective input using AutoFill • Test and improve knowledge and skill • Module Activities

  3. What is a spreadsheet? Examples of uses Part of a spreadsheet that is used for the calculation of marks.

  4. What is a spreadsheet? First acquaintance with Excel 2010 Quick Access Toolbar Tabs Ribbon Cell name box Formula bar Rows 4-9 Columns A-I Active cell Different worksheets

  5. Basic functions Format of a function = (argument(s)) Function Name A function always begins with an equal sign. Name of the function Argument: cells on which the function is based

  6. Basic functions Examples of functions Sum Average Minimum Maximum

  7. Basic functions Entering functions =SUM(D1:D7) =SUM( D1:D7)

  8. Basic functions Entering functions

  9. Inputting data Move to a cell by using: Data aligned: text left for text 123 right for numbers Tab To edit data: F2

  10. Use of formatting Selection of cells Specific range: click and drag with mouse Whole row: click on row heading number Whole column: click on column heading number Whole spreadsheet: Click on select all block or <Ctrl>< A>

  11. Use of formatting Basic formatting Word wrapping in a cell Vertical alignment Text orientation Character formatting and borders indenting Horizontal alignment merging of cells

  12. Use of formatting Or use Format Cells Character formatting Alignment Borders Shading Text orientation Merging of cells

  13. Use of formatting Formatting cells, rows and columns Format as table

  14. More about different types of data formats Numerical data Functions and Formulae Text

  15. More about different types of data formats Change data format

  16. More about different types of data formats Ordinary numbers Set decimal places after point Use system separator

  17. More about different types of data formats Currency formats Select symbol here – do not type R R 324.78 Accounting R 324.78 Currency

  18. More about different types of data formats Numbers which must be treated as text 0002 098 567 8473 To save numbers as text: ‘0002 or

  19. More about different types of data formats Numbers which must be treated as text Error message: Select Ignore Error.

  20. More about different types of data formats Dates and times Dates Times

  21. Effective input using AutoFill

  22. Overview of module

  23. Test and improve your knowledge and skills Important terms and concepts

  24. Test and improve your knowledge and skills Tips and Recommendations

More Related