Adds the cells in the Sum_Range that meet multiple criteria
What is SUMIFS
100
Converts text to lowercase
What is LOWER
100
Can be a number, text, or expression that tests which cells to sum, cont, or average
What is Criteria
100
Who is the featured artist with Travie McCoy on "Billionaire"?
Who is Bruno Mars
100
This former UNC basketball player has been referenced as the greatest of all time (and that's no Bull)
Who is Michael Jordan
200
Returns the mean of cells that meet a criteria
What is AVERAGEIF
200
Converts text to uppercase
What is UPPER
200
Values that a function uses to perform operations or calculations in a formula
What is Argurments
200
Who had a hit in 2010 with "Rude Boy"?
Who is Rihana
200
Who holds the Major League Baseball record for most consecutive games with a hit?
A: Pete Rose B: Joe DiMaggio C: Ty Cobb D: Paul Molitor
Who is Joe DiMaggio
300
Removes the space at beginning and end of text
What is TRIM
300
Returns the right Num_Chars from text
What is RIGHT
300
One in which the result is determined by the presence or absence of a particular condition
What is Conditional Formula
300
Which group contains members Charles Kelley, Dave Haywood, and Hillary Scott
Who is Lady Antebellum
300
As a way of showing team support, Green Bay Packer fans wear which Wisconsin-made product on their heads?
What is Cheese
400
Capitalizes the first letter in each word of the text
What is PROPER
400
Counts the number of cells within a Range that meet the criteria
What is COUNTIF
400
Location of the cells relative to the location (A2)
What is Relative Cell Reference
400
This boy-band of 5 is down to 4 with the loss of teen heart-throb Zane.
Who is One Direction
400
The player in soccer football or hockey who prevent a score is called the "goalie," which is the abbreviation for what proper title? (actually two correct names...)
What is Goal Keeper/Goal Tender
500
Joins Text 1 Text 2....
What is CONCATENATE
500
Gives number where Within_Text starts inside of Find_Text
What is FIND
500
Cell reference stays the same as it is copied within a formula ($A$2)
What is Absolute Cell Reference
500
Judges on the hit tv show the Voice are known in the music industry. Name 2 of the current judges.
Who are Blake Shelton, Pharrell, Adam Levigne, Christina Aguilera
500
Who is the only man to play a Major League Baseball game and an NFL game in the same day as well as the only man to play in both a Super Bowl and World Series?
A: Jim Thorpe B: Deion Sanders C: Bo Jackson
D: Danny Ainge