BPAM08-M3-ICT Application using EXCEL (1).pdf

KNOWLEDGE MANAGEMENT AND ICT FOR PA BPAM08 MODULE 3: ICT Application using MS Excel – Spreadsheet OBJECTIVES At the end of this lesson, students are expected to: Understand the application of ICT using MS Excel Demonstrate the use of MS Excel Whatis Spreadshee...

KNOWLEDGE MANAGEMENT AND ICT FOR PA BPAM08 MODULE 3: ICT Application using MS Excel – Spreadsheet OBJECTIVES At the end of this lesson, students are expected to: Understand the application of ICT using MS Excel Demonstrate the use of MS Excel Whatis Spreadsheet?  A spreadsheet is made up of cells each identified by a reference. The reference is made up by using the column and the row [COLUMN] [ROW].  You can also select multiple cells at the same time. A group of cells is called as a cell range.  You can refer to a cell range, using the cell reference of the first cell and the last cell in the range, separated by a colon. For example [FIRST CELL in RANGE] : [LAST CELL in RANGE]  Cell references are used when you start applying functions to the numbers in your cells. In the example below, to add two numbers together, you can enter a formula into cell C1. Instead of typing in =5+5 you would enter =A1+B1.  The theory is, if you enter the cell reference instead of the actual number, you can perform calculations automatically and Excel will recalculate all the numbers for you should you change anything. For Example Starting Excel The Ribbon The Home Ribbon This is where you will find your most used tools for basic text formatting, cell borders, cell formatting for text and numbers or currency, etc. The Insert Ribbon This is where you will find all your objects that you can insert into your spreadsheet, such as shapes, tables and charts The Page Layout Ribbon This is where you will find your page formatting functions, such as size of paper, colors s themes, paper orientation when printed, paper margins, etc. The Formula Ribbon This is where you will find your formulas, functions and your data manipulation tools. Sum functions, average, counting tools, etc. The Data Ribbon The data ribbon is where you can find tools to connect to external data sources and databases, as well as sort data. The Review Ribbon The review ribbon has tools that allow you to add comments as well as check spelling and protect parts of the spreadsheet from making changes.  The View Ribbon This is where you will find your view layouts, where you can zoom into your spreadsheet etc. File Backstage Backstage is where you open or save spreadsheets and workbooks, print, export or share workbooks, as well as options, Microsoft account and preference settings. Getting Started. Entering your data Simple Text Formatting Text Orientation Resizing Rows and Columns Inserting Rows and Columns Cut, Copy and Paste Sorting Data To quick sort your data, click on a cell in the column you want to sort the data by. Formatting your Spreadsheet Cell Alignment TextFormat Cell Borders  -Importing Data -Freeze Panes -Conditional For matting -Using For mulas Theparts of a formula are; O Function – a named operation that replaces the arithmetic expression in a formula O Reference – a cell or a range of cells on a worksheet with value(s) O Constant – a number or value entered directly into a formula O Operator – a special character that specifies the type of calculation. Forexample; PI() is a function. A2 is a reference. 2 is a constant. * and + are operators. Thetypes ofoperatorused inExcelarethefollowing: O An arithmetic operator can perform basic mathematical operations, combine numbers, or produce numerical results. The arithmetic operators are +, -,*, /, %, and ^. The ^ operator raises a number to a power. Ex. 3 ^ 2 is equal to 27. O The comparison operators are used to compare values; the result of a comparison is either TRUE or FALSE. The comparison operators are =, >, = (greater than or equal to),