This preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
Unformatted text preview: A formula in Excel begins with: A quotation mark An equal sign A cell reference None of the above What does the F4 key do in Excel? Selects the entire worksheet Saves your file Toggles between absolute, relative, and mixed referencing Brings up the Help menu Which one of the following Excel formulas correctly computes the equation below: RIGHT Click on link to see image in another window. Formula 1.jpg =2+(SQRT(300+5/36)/(6*9^3))SQRT(5/4) =2+(((300+5/36)^1/3)/(6*9^3))SQRT(5/4) =2+(((300+5/36)^(1/3))/6*9^3)SQRT(5/4) =2+(((300+5/36)^(1/3))/(6*9^3))SQRT(5/4) Formulas, functions, and cell references are valid arguments of an Excel function. True False The result of the EXCEL formula =MOD(12,5) is 1 2 3 5 12 Which of the following excel formulas should be used to compute e^2? =e^2 =EXP(2) =EXP^2 =EXP(^2) The angle in the argument of the trigonometric functions sine, cosine, and tangent should be in what units? It doesn't matter Degrees Radians Hours:minutes:seconds Which of the following formulas correctly compute the sine of 60 degrees? =SIN(60) =RADIANS(SIN(60)) =SIN(RADIANS(60)) =SIN(DEGREES(60)) Which of the following Excel formulas correctly computes the arctangent of 2/3 in degrees? =ATAN(2/3) =ATAN(DEGREES(2/3)) =DEGREES(ATAN(2/3)) =RADIANS(ATAN(2/3)) The angle returned from the inverse trigonometric functions ASIN, ACOS, and ATAN is is what units? None Degrees Radians Hours:minutes:seconds Which of the following EXCEL formulas computes 2 times pi? =2*PI =2*PI() =PI(2) Which of the following is the correct result for the following Excel formula? =EVEN(4.4) 4 5 6 Which of the following is the correct result for the following Excel formula? =INT(5.8) 4 5 6 Which function should be used to round 5.88 to the nearest integer? INT ROUND Which of the following cell addresses absolute references only the column in a formula? C2 $C2 C$2 $C$2 6 5 points Save Which of the following cell addresses absolute references only the row in a formula? C2 $C2 C$2 $C$2 Which of the following formulas correctly reference the cells for x and y in the equation and worksheet shown below so that the formula only needs to be copied ONCE to fillin the table? RIGHT Click on link to see picture in a new window. Mixed Referencing.jpg =SQRT((B9^2)/3+(A10^2)/7) =SQRT(($B$9^2)/3+($A$10^2)/7) =SQRT((B$9^2)/3+($A10^2)/7) =SQRT(($B9^2)/3+(A$10^2)/7) Can the CONVERT function be used to convert degrees to radians?...
View
Full Document
 Spring '09
 Wal.sh
 Trigonometry, Correct Answer, Inverse function, atan, following excel formulas

Click to edit the document details