tailieunhanh - Lecture Computer literacy - Lecture 17: Calculations & Graphics using

After studying this chapter you will be able to understand: What is cell alignment? What is the purpose of Fill handle? Why comments are inserted in the excel sheet? Why hyperlinks are used? | Calculations & Graphics using Spreadsheet ADE100- Computer Literacy Lecture 17 Knowledge test What is cell alignment? What is the purpose of Fill handle? Why comments are inserted in the excel sheet? Why hyperlinks are used? 2 2 Topics covered Doing mathematics Formulas, addition, subtraction Average, logic formula, etc. Making charts formatting . background, Legend, color of bars, creating pictograph 3 Formulas Formula Expression that produces some values Use values, cell references and built-in functions Must begin with an equal sign (=) When the formula is entered in the cell the calculation executes immediately Cells display result and formula bar shows formula 4 Entering formulas Entering a formula Click on the empty cell that will display the result of the formula Type the equal sign (=) Type your formula without any spaces like a1+a2+a3 and press Enter key If you change any value of a cell referenced in a formula, the formula will automatically recalculate and display the . | Calculations & Graphics using Spreadsheet ADE100- Computer Literacy Lecture 17 Knowledge test What is cell alignment? What is the purpose of Fill handle? Why comments are inserted in the excel sheet? Why hyperlinks are used? 2 2 Topics covered Doing mathematics Formulas, addition, subtraction Average, logic formula, etc. Making charts formatting . background, Legend, color of bars, creating pictograph 3 Formulas Formula Expression that produces some values Use values, cell references and built-in functions Must begin with an equal sign (=) When the formula is entered in the cell the calculation executes immediately Cells display result and formula bar shows formula 4 Entering formulas Entering a formula Click on the empty cell that will display the result of the formula Type the equal sign (=) Type your formula without any spaces like a1+a2+a3 and press Enter key If you change any value of a cell referenced in a formula, the formula will automatically recalculate and display the new value. 5 Addition Addition Move the cursor to cell A1 and type a value of 10 Press Enter Type a value like 20 in cell A2 Enter formula in cell A3; =A1+A2 and press Enter The result of calculation will display in the cell and formula in the formula bar 6 Subtraction Subtraction All the steps are similar but change the formula like =A1-A2 7 Arithmetic operators in excel Operator Operation Example + Addition =a1+a2 - Subtraction =a1-a2 * Multiplication =a1*a2 / Division =a1/a2 % Percent =50% ^ Exponent =5^3 (cube) 8 Precedence of operators Precedence The order in which operators are evaluated in the expression Expression is combination of operands and operators like 3+4, x+y The operators with high precedence are evaluated first High to low precedence Parentheses () Negation – Percentage % Exponentiation ^ Multiplication and division *, / Addition and subtraction +,- precedence 9 Average Average Calculates arithmetic mean Write some values in the cells like from A1 to A5 Select the cell