VISUALIZATIONS
EXCEL TRIVIA AND SHORTCUTS
EXCEL FUNCTIONS
MARKET RESEARCH
MARIST FACTS EVERYONE SHOULD KNOW
100
Bar Charts and Pie Charts always start here.
What is a pivot table?
100
All Excel functions and mathematical formulas must start with this symbol.
What is the equal sign?
100
If we want to categorize a continuous variable (like test scores) into two groups (like pass or fail), the best EXCEL function to use is this.
What is an "IF" Function?
100
This "New" product was introduced in 1985, but was recalled 79 days later when consumers rebelled against the company discontinuing its original product.
What is New Coke?
100
MARIST SCHOOL WAS FOUNDED THIS YEAR
When was 1901?
200
This visualization is used to evaluate the relationship between 2 numeric/quantitative variables.
What is a scatterplot?
200
In Excel, we have to add this symbol to any cell reference to prevent its location from moving when copying a formula.
What is a dollar sign?
200
If you need to identify the lowest value in a long array (column) of data, you should use this function.
What is the "MIN" function?
200
This is one of two reasons why we always use an odd number of options in a linear scale survey question.
What is:
1) it provides the respondent with a neutral option
2) it does not force the respondent to take a position
200
The Marist Crest includes four stars. What do these stars represent?
What is "Georgia - the fourth state in the union"?
300
The best way to represent percentages of whole is to use this kind of graphic.
What is a pie chart?
300
To move quickly to the bottom of your data without scrolling, scrolling, scrolling...you can use these two keys simultaneously (must get both).
What are the "CTRL" and "DOWN ARROW" keys?
300
In an IF function, this is the third (final) piece of information that you need to provide.
What is the value if FALSE?
300
This failed product included "Crispy Beef" flavored water.
What is "Thirsty Dog Bottled Water"?
300
Girls were first admitted to Marist in this year.
What is 1976?
400
In the equation of a line, this is the traditional representation of "slope".
What is "M"?
400
Excel has this many rows (within 1000).
What is 1,048,576?
400
What will this function return in cell B5?:
What is "HIGH"?
400
This is the term we use to describe data that has been collected by another company or government agency and used for a different purpose.
What is "Secondary Data"?
400
This Marist coach started coaching at Marist in 1985 and is in the Georgia Sports Hall of Fame.
Who is Alan Chadwick?
500
In this scatterplot trendline (y=64.50x+.5), interpret the slope...where x=rating and y=purchase amount:
What is: "For every one point increase in customer rating, the expected purchase amount increases by $64.50."
500
If you need to move an existing column (or row) within a large dataset to another position within the spreadsheet (e.g., move column B to column D), you first highlight the column, then press "CTRL" and "X". Then, go to where you want to drop the column and press these THREE keys.
What are "CTRL", "SHIFT", and "+"?
500
What value will be returned in cell A7?
What is "5"?
500
When calculating a Net Promoter Score, we subtract the percentage of these types of responses (less than 6) from these types of responses (9-10). Must get both names correct.
What are Detractors and Promoters?
500
These Latin words on our crest mean "Under the Name of Mary". (Spelling counts)
What is "Sub Mariae Nomine"?