NAME: ________________________

# ← CGS2518Test

### Question Limit

of 76 available terms

### 5 Matching Questions

1. How do you change the chart type of an existing chart?
2. Write a formula to determine the average price of only Ford vehicles using the worksheet in question 11.
3. The rows and column arguments in the INDEX functions can be numeric values, Boolean values, or text
4. The lookup_value of a Vlookup function can be contiguous cell range
5. =NOT(OR(FALSE,FALSE,False)
1. a False
2. b Go to the design ribbon and click change chart type
3. c =Averageif(A2:A10,"Ford",B2:B10)
4. d True because all are false so its going to come back false, but it says not, so it is the opposite
5. e True

### 5 Multiple Choice Questions

1. =average(2,5,4,3,1,2,7)
2. =countif(B2:B10,"<=20000")
3. INDEX
4. =IF(B3="O",C3,C3*3)
5. You have to ttell it to shade yellow, so it should be conditional format using the Formula is method to create one. Use =\$D3>=400, indicate to shade yellow, applying to \$A\$3:\$A\$8.

### 5 True/False Questions

1. Write a formula to generate a random integer value between 10 and 20=OR(E3:E8)

2. What formula could you write to average the values in cells A10 through A20, excluding blank cells, rounded to the nearest 10?Sum

3. Write a formula to determine if all of the items are within budget=And(E3:E8)

4. What is the formula to determine the total value of all ford cars?=countif(B2:B10,"<=20000")

5. What formula would you write to add a range of numbers in cells A2:X2?Min