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




 =countif(B2:B10,"<=20000")




 =(37.5035)/35




 False, descending




 False




5 True/False Questions

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

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

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

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")

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