Spreadsheets_28Aug11

Plicaon division lej to right addion subtracon lej

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: he spreadsheet. The key to this power is to know how to address the cell desired. Mathematical Operators   Addi?on (+): 5+2   Subtrac?on ( ­): 7 ­3   Mul?plica?on (*): 2*A (NOT 2A)   Division (/) 4/3   Exponent (^) 5^3 Precedence Order of evaluation when several operators appear in a single expression   Parenthesis   Func?on evalua?on   Exponen?a?on   Mul?plica?on & Division (leJ to right)   Addi?on & Subtrac?on (leJ to right) Precedence Examples =(3*(a+1))/(d-2) =25^(1/3) Intrinsic Functions   There are many predefined func?ons in Excel. A few examples are:   AVG, SUM, MIN,...
View Full Document

This note was uploaded on 12/01/2012 for the course ECE 1331 taught by Professor Staff during the Fall '08 term at University of Houston.

Ask a homework question - tutors are online