For our course you should be able to perform basic mathematical functions in Excel and correctly follow the order of operations (PEMDAS). These functions include: - Basic Math / Calculator Functions - Add: =number1 + number2 - Subtract: =number1 - number2 - Multiply: =number1 * number2 - Divide: =number1/ number2 - SUM(number1, number 2,...) - Square Root: =SQRT(number) - Exponents, i.e. raise to the power of a: = number^a - Absolute value: ABS(number) - Logarithm: LN(number) returns natural logarithm and LOG(Number,base) returns the logarithm of a number to the base you specify. Match the mathematical operations to the appropriate Excel formulas for the following table of values. Multiply the first three values X1X2X3 Multiply the first three values X1X2X3=A3/B3C3=SQRT(A32+D32)=(A3)(B3)(C3)=A3B3C3=SUM(A3:D3)/ABS(SUM(A3:D3))=LN(B3-C3)=LOG(B3C3)=C3/(1C3)=SQRT(A3+D32)=C3/1C3=A3/(B3C3) ln(X2X3) Take the square root of the sum of X1 squared + X4 squared X12+X42 Find the ratio of X1 divided by the product of X2 and X3 x23x1