Financial Statements and misc. data
On this statement you will see categories like assets, liabilities and equity.
What is a balance sheet.
The chart type that would be best for showing a linear regression.
What is a scatterplot.
If you were working with a data set containing teacher salaries across multiple districts in the state of Iowa and wished to find a teacher in the Dubuque school district in the math department with the highest salary you would use this function.
What is =MAXIFS()
You might use this to determine how much you can mortgage with a given monthly payment.
What is Goal seek
This feature would work best to highlight all the courses attempted in the spring semester.
What is conditional formatting.
On this financial statement you will see categories like Revenue, expenses and net income.
What is an income statement.
Diagnostic analytics has us looking at charts that show a deviation from a standard or thing that is normal or expected. Another name for this is..
What is an anomaly.
A$1 is an example of this.
What is a mixed reference.
You would use this if you wanted to find your monthly payment, the total you could mortgage, and the total amount of interest you would pay in that mortgage for various different interest rate values contained in a column.
What is a one dimensional data table
CurrentSalary is an example of this of this in Excel.
What is a range name.
When looking for sudden change in quarterly revenue would the best way to look at this would be on absolute basis, percentage basis, YOY change basis or YOY percentage change basis?
What is "all of these".
This is a modeling technique used to find the best solution to a problem.
What is optimization.
$A$1is an example of this
What is an absolute reference
You use this for displaying single output based on various values contained in two different input fields.
What is a two- dimensional data table
Rather than using several =SUMIF() functions to compute subtotals for a unique series of product names you should probably use this.
What is a Pivot Table
You are creating a 14 day moving average and the value on Day 1 was 372, Day 14 is 314 and the moving average is 376. If Day 15 is 350 your moving average will do this.
What is go down.
The process in predictive analytics of continually learning from your efforts to improve a process and make it better.
What is Looping back
The excel function you would use to return a tax rate of 25% if the taxable income was over $100,000, otherwise the rate is 10%.
What is =IF()
This what if analysis is best used to display multiple outputs based on changes in the inputs for multiple fields.
What is scenario manager.
This is used to get rid of repetitive data in a series where only unique data is needed.
What is remove duplicates.
Predictive analytics differ from descriptive and diagnostic analytics largely due to this.
What is machine learning.
Random forest models use several of these.
What are decision trees.
If you saw the following formula entered into an Excel spreadsheet =VLOOKUP(B5,C10:E15,3,FALSE) this should be returned based on the number 3.
What is the item in column E (Assuming there is a match in the contents of cell B5)
When presenting various scenarios to executives in a meeting using it is best to use what type of scenarios.
What is worst case, best case and most likely.
Freeze panes is located here
What is view.