CIVE 120 Quizzzzzsss

# CIVE 120 Quizzzzzsss - 8 How will the cell references...

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

8. How will the cell references change in formula =2*A1 +3*A2 + B\$7 if it is copied over to the right one column and down two rows? a. =2*B3 +3*B4 + C\$9 b. =2*B3 +3*B4 + C\$7 c. =2*A1 +3*A2 + B\$9 d. =2*C2 +3*C3 + D\$7 QUIZ 3 8. The angle returned from the reverse trigonometric functions ASIN, ACOS, and ATAN is in what units? a. None b. Degrees c. Radians d. Hours:minutes:seconds 11. The AVERAGEA, MINA, and MAXA functions treat empty cells and text as the number zero. a. True b. False 13. What function computes the sum of squares of a range of numbers in a column? a. SUM b. SUMSQ c. SUMX2MY2 d. SUMXMY2 15. Which is the correct result for the following formula? =INT(5.8)

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

View Full Document
a. 4 b. 5 c. 6 d. None of the above 16. Which is the correct result for the following formula? =EVEN(4.3) a. 4 b. 5 c. 6 d. None of the above 20. Can the CONVERT function be used to convert the temperature in W/mC? a. Yes b. No QUIZ 4 1. If there are 5 conditions, how many IF functions will be used in an efficient nested IF statement? a. 3 b. 4 c. 5 d. 6 2. How many IF functions would be needed to compute the following equation without the use of the AND or OR functions? a. 1
b. 2 c. 3 d. 4 QUIZ 5 1. What does a Stacked Column chart show? a. Totals and proportions b. Totals only c. Proportions only d. None of the above 2. What does a 100% Stacked Column chart show? a. Totals and proportions b. Totals only c. Proportions only d. None of the above 12. Which of the following statements about combination charts are true? a. Two or more chart types are combined to emphasize different kinds of information.

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

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

## This note was uploaded on 12/12/2010 for the course CIV E 120 taught by Professor T.parsons during the Fall '10 term at San Diego State.

### Page1 / 10

CIVE 120 Quizzzzzsss - 8 How will the cell references...

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

View Full Document
Ask a homework question - tutors are online