tailieunhanh - 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 | 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 (1,2,3 ) Columns are labelled by alphabets (A,B,C,AA,AB ) Cell address Cells are labelled with both row number and column letter . A1, B5, C30 6 6 MS Excel Interface Worksheet 256 columns and 65,536 rows in a worksheet Workbook By default, 3 worksheets in a workbook First sheet; sheet1 then second; sheet2, etc. You save a workbook with worksheets Active cell The current cell where you will enter data 7 MS Excel Window 8 Active cell 9 Ribbon 10 Menu bar 11 Toolbars 12 Formula bar Formula bar Displays the location of active cell and the value or formula used in the active cell 13 Row/column headings 14 Sheet tabs 15 Creating a file To create a new spreadsheet Open File menu and choose New or press CTRL+N A new excel workbook will be open with “three default sheets” 16 Opening a file To open an existing spreadsheet Open File menu and choose Open or press CTRL+O Open dialog box appears, select the desired file and then click Open button 17 Saving a file To save a file Select File menu