Highly Functional
This function is a quick way to add values.
What is the sum function?
This is the first step to perform when you receive a new data set.
What is make a copy of the data?
Baseball is as American as this.
What is apple pie?
Problem solver, creator, effective communicator, subject matter expert
What is a data analyst?
A worksheet contains this.
What are rows and columns?
This function requires a reference to find data within a table or an array.
What is VLookup?
If you want an accurate count, you must do this.
What is sort and/or remove duplicates?
In the Uk, you would do a pub crawl but in the US it's called this.
What is a bar crawl?
Maximum, Trim, Length, Match
What are functions?
A row contains this.
What is a cell?
All functions contain this fussy input.
What is an argument?
What is create a pivot table?
This kind of dancing also shares its name with a chart type.
What is line dancing?
Gridlines, Axis title, Data Labels, Data Markers
What are chart attributes?
This is where you will add your function or formula.
What is the formula bar?
This function returns TRUE if all arguments are true, FALSE if all arguments are false.
What is the AND function?
This is the one of the first things you should ask for before you begin your analysis.
What is a data dictionary?
This area contains the data markers, gridlines and data labels
What is plot area?
Mathematical, Logical, Text, Reference
What are operators?
You can customize 1 of these 2 built-in features of Excel.
What is quick access toolbar or ribbon?
This function will add of a range of cells if the condition is true.
What is SUMIF?
You should keep this in mind when presenting data.
What is your audience?
One of these charts would be best to use to see outliers.
What is a scatterplot or boxplot?
Filters, column, row, value
What are areas of a pivot table?
This should be the last step if you are using this Excel feature to combine rows or columns.
What is a merge?