NAME: ________________________
5 Written Questions
5 Matching Questions
 The formula =RAND() gives what result?
 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?
 List and describe the significance of each of Tufts five data graphics principles
 #NAME?
 The formula =Round(345.43,0) results in what precise value?
 a Above all else, show data
Maximize the dataink ration, within reason
Erase nondata ink, within reason
Erase redundant data ink, within reason
Revise and eit  b Gives a number between 0 and 1
 c =If(D3<C3, "True","False")
 d 345
 e Unrecognized text in formula (mispelling)
5 Multiple Choice Questions
 False, descending
 The specific format of a function including the function name and the order of the arguments
 42
 Go to the design ribbon and click change chart type
 A function input (when putting a number and how many decimal places)
5 True/False Questions

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? → False

List the orders of operations in order → True because all are false so its going to come back false, but it says not, so it is the opposite

What charting limits does excel have in terms of data points and series? → Max

Write a formula to round up 63.34% to the nearest percent → =roundup

How would you bold a cell when the value is greater than 50? → Min