This preview shows pages 1–4. Sign up to view the full content.
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
This note was uploaded on 06/27/2010 for the course CON E 101 taught by Professor Wal.sh during the Spring '09 term at SD State.
 Spring '09
 Wal.sh

Click to edit the document details