TAILIEUCHUNG - Lecture Computer literacy - Lecture 15: Using Productivity Application - Spreadsheet

After studying this chapter you will be able to understand: Why columns are used in word? What is autocorrect feature of word? What is the use of templates in word? General introduction to spreadsheets interface creating, saving and opening spreadsheet, using worksheets. | Using Productivity Application- Spreadsheet ADE100- Computer Literacy Lecture 15 1 Knowledge test Why columns are used in word? What is autocorrect feature of word? What is the use of templates in word? 2 Topics covered General introduction to spreadsheets interface Creating, saving and opening spreadsheet Using worksheets 3 Spreadsheet Spreadsheet program Used for calculations Provides worksheets to enter data Worksheet Collection of rows and columns Calculate using formulas and built-in functions Display data in charts and figures Workbook Collection of worksheets 4 Advantages of spreadsheet Spreadsheet Increases the ease and speed of calculations Easy to modify and recalculate data automatically Display numeric data as charts or graphs 5 Microsoft Excel Microsoft Excel Used for calculations in tabular form The main window is called worksheet. The intersection of a row and column is called Cell. Cell contains data, text, numbers, date, formula, functions Rows are labelled by numbers

• Tin học văn phòng
• Computer Literacy
• Lecture Computer literacy
• Computer science
• Introduction to computers
• Computer applications
• Computer Networks
• Using Productivity Application
• Computer Ethics
• Transferring images
• Central Processing Unit
• Operating system software
• Operating system
• Folder properties
• Storage devices
• Working with tables
• Advanced features
• Formatting cells
• Doing mathematics
• Print properties
• Microsoft PowerPoint
• Assignment presentation
• Saving Web Resources
• Communication through internet