5 Written Questions

1. =And(E3:E8)
2. False
3. =average(2,5,4,3,1,2,7)
4. =countif(B2:B10,"<=20000")
5. True

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
   1. Give an example of a low data ink ratio in a chart.
   2. What formula to find the largest value in cells?
   3. The result_vector of a lookup function must be sorted in ascending order
   4. List the orders of operations in order
2. =(37.50-35)/35
   1. In the chapter, original labor rate for inspectors was given as 35 per hour. However, the value is 37.50. What algebraic expression could you use to determine the percent increase in labor cost?
   2. Write a formula to dtermine if none of items are within budget
   3. Write a formula to determine if all of the items are within budget
   4. What is the sumbol for the not equal to relational operator in Excel?
3. =B2+ Randbetween(50,250)
   1. What are the differences and similarities between a line chart and XY scatter chart?
   2. Reference and lookup functions may not contain nested functions as arguments
   3. If each car shown in Question 11 is marked up between 50 and 250 increments, what function could be used to randomly assign the amount to be added to the car price in this formula?
   4. Write a formula to dtermine if at least one item is within budget
4. =If(D3<C3, "True","False")
   1. Write a formula in cell b13 in the pricing worksheet to determine the total cost of making copies for this order (3). write the formula so that it works when copied into cells B14:B16.
   2. Write a formula in cell F3 that can be copied down the column to dtermine if this food item is not within budget
   3. Write an excel formula in H3 that can be copied down the column to calculate the cost of this component for a larger sales meeting base on the following: if this item is optional as indicated in column b, then the cost will be equal to the original budgeted amount, if this item is required as indicated in column, then the cost will be three time the original budgeted amount.
   4. What formula is used in cell E3, which can be copied down the column to determine True or false if this item is within budget?
5. =And(Or(E3:E5,B7), Not(Or(E6,E8)))
   1. Write a formula to determine if all of the items are within budget
   2. Write a formula to dtermine if at least one item is within budget
   3. Write a formula to determine if true or false only the required items (r) are within budget.
   4. Write a formula to dtermine if none of items are within budget

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.

   True        False

2. #N/A → No Answer

   True        False

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

   True        False

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

   True        False

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

   True        False