NAME: ________________________

# ← CGS2518Test

### Question Limit

of 76 available terms

### 5 Matching Questions

1. The data set: 2,5,4,3,1,2,7, has a standard deviation of 1.58 as compared with another data set that has the same mean but a standard deviation of 2.5. What general differences would you expect to find between the two sets of data?
2. What is the symbol for the greater than or equal to relational operator in Excel?
3. How would you bold a cell when the value is greater than 50?
4. Excel matches the lookup_value "tom" with the entry "TOM" in a lookup table
5. #REF
1. a True
2. b >=
3. c Invalid cell reference
4. d A wider range of value
5. e conditional formatting, highlight cell rules, greater than

### 5 Multiple Choice Questions

1. False, descending
2. =(37.50-35)/35
3. =B2+ Randbetween(50,250)
4. =If(D3<C3, "True","False")
5. =And(Or(E3:E5,B7), Not(Or(E6,E8)))

### 5 True/False Questions

1. How do you change the chart type of an existing chart?Small word-sized charts or graphics are embedded within the words, numbers, and images they represent in a worksheet, making multiple comparisons of trends and patters much easier.

3. What is the sumbol for the not equal to relational operator in Excel?=mode(2,5,4,3,1,2,7)

4. If you enter =2+4*10 exactly as shown, what value would result?Gives a number between 0 and 1

5. What are the three steps involved in using the insert tab to create a chart?=Sumif(A2:A10,"Ford",B2:B10)