Print test
5 Written questions
5 Matching questions
 Write a formula to determine if all of the items are within budget
 What is the formula to determine the number of cars that cost less than 20,000?
 What formula would you use if you wanted to set a conditional format of cell a3 using the formula is methodsuch that the item name would be shade in yellow if this item has an actual cost of at least 400
 #REF
 Syntax
 a The specific format of a function including the function name and the order of the arguments
 b 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.
 c =And(E3:E8)
 d =countif(B2:B10,"<=20000")
 e Invalid cell reference
5 Multiple choice questions
 Excel charts require at least one numeric data series and at least one label data series
 A function input (when putting a number and how many decimal places)
 Box has insufficient width
 Gives a number between 0 and 1
 Unrecognized text in formula (mispelling)
5 True/False questions

What formula to find the smallest value in the cells? → Average

The result_vector of a lookup function must be sorted in ascending order → Parenthesis
Exponentiation
Multiplication and division
Adding and subtracting 
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? → =(37.5035)/35

List the orders of operations in order → Parenthesis
Exponentiation
Multiplication and division
Adding and subtracting 
Reference and lookup functions may not contain nested functions as arguments → False