ALL THE YELLOW CELLS MUST CONTAIN FORMULAS… DO NOT JUST TYPE IN THE ANSWER
List A
4 23 63.98 0 34.7 Gleneagle 23 33 23 23 Talons 0.45 13.66
List B
Last Name Test A
Formula Today Average Maximum Minimum Sum Count Counta
What the formula does… finds out today's date find the average number in a list finds the highest number in a list finds the lowest number in a list find the total amount in a list counts the # of cells with numbers counts the # of cells with info. counts only the cells that contain a specific characteristic find the square root of a number counts char. from left side of cell counts char. From right side of cell ranks a specific cell in al ist
raises a number to the power of another
Formula's Structure =today() =average(list) =max(list) =min(list) =sum(list) =count(list) =counta(list)
Question What is today's date? What is the average in List A? What is the highest score in List B? What is the lowest score in List B? What is the total of List A and List B together? How many numbers are there in List A? How many pieces of information is there in List A?
Answer (use a formula)
Brown Chaput Dowski Ming Zhang
65 75 52 88 95
Countif
=countif(list,condition)
How many times does the number 23 appear in list A? What is the square root of cell A9? What the first 3 characters in cell B9? What are the last 5 characters in cell B7? How does Chaput's score rank overall in List B? What is result of raising A10 to the power of 4?
Square Root Left
=sqrt(cell) =left(cell,# of char.)
Right Rank Exponential
=right(cell,# of char.) =rank(cell,list) use the carat (^) key above the "6" key