NAME: ________________________

CGS2518 Test

Question Types


Start With


Question Limit

of 76 available terms

Upgrade to
remove ads

5 Written Questions

5 Matching Questions

  1. Write a formula to dtermine if none of items are within budget
  2. #Num
  3. How many standard chart types and sub types are available in Excel?
  4. List the orders of operations in order
  5. The formula =Round(345.43,0) results in what precise value?
  1. a Parenthesis
    Exponentiation
    Multiplication and division
    Adding and subtracting
  2. b =Not(E3:E8)
  3. c 11 standard charts and 73 sub types
  4. d 345
  5. e Invalid numeric values in a formula or function

5 Multiple Choice Questions

  1. Sum
  2. =countif(B2:B10,"<=20000")
  3. =(37.50-35)/35
  4. False, descending
  5. False

5 True/False Questions

  1. What is the symbol for the greater than or equal to relational operator in Excel?>=

          

  2. What formula could you write you calculate the mean of the following data set: 2,5,4,3,1,2,7Sum

          

  3. When using the increase decimal button on the toolbar, the preise value in the cell is modified. True or false?Min

          

  4. Write a formula in cell F3 that can be copied down the column to dtermine if this food item is not within budget=IF(D3>C3,"True","False")

          

  5. Using the worksheet shown in Question 11, write a formula to determine the value of the third most expensive car=Large(B2:B10,3)

          

Create Set