Quiz 1 Fall 2008

Quiz 1 Fall 2008 - A formula in Excel begins with: A...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the 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 fill-in 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.

Page1 / 25

Quiz 1 Fall 2008 - A formula in Excel begins with: A...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online