Excel Functions
Function you would use to count up the number of employee names in a column of data.
what is =COUNTA()
This chart would be best if you were displaying the latest four quarters of the company's sales.
What is bar or column chart.
Rather than using several =SUMIF functions to compute subtotals for a series of unique product names it is better to use this.
What is a Pivot table.
This tool is used to change the values of one or more input variables and show the results of one or more output variables in a spreadsheet to identify the worst, mostly likely and best case.
What is scenario manager.
The IT employee that would focus largely on computer hardware.
What is a Network Engineer.
Function used to take data with multiple records with the same values and return only unique values.
What is remove duplicates
If you wished to present the composition of something such as income by product category, you should use this type of chart.
Pie chart, Area chart, waterfall chart or stacked bar chart. (Any of these would work)
This Excel Function is used to check if you entered something into a cell or not.
What is "=ISBLANK()"
When sorting data in Excel you should always do this first.
What is Save the spreadsheet with a new name to keep the data intact in case you mess it up.
Technology used to write data across several disks to serve as a backup method.
What is RAID
CurrentSalary is an example of this used in Excel.
What is a range name.
This chart would not typically be used when you are trying to demonstrate the relationship between items.
What is a stock, high, low, open close chart.
This function can be used in Excel to return the right characters in a cell.
What is =RIGHT()
ie =Right("orange", 2) would return "ge"
The reason you would use Excel's Advance Filter instead of just using the Filter.
To be able to extract the list of selected records. (To do more work on them separately)
Data from a billing, CRM, ERP and flat file systems all being fed to this source to be used to analyze and report on data.
What is a data warehouse?
If you wanted to return the sales tax rate for a US state that a product was sole in, this Excel function would make the most sense.
What is VLookup?
A predictive model to determine if a potential customer was a good credit risk or not is an example of this kind of model.
What is a classification model.
This Excel feature would work best to highlight all the courses attempted during the Spring semesters.
What is conditional formatting.
The tab (s) on the Excel ribbon that has the sort features.
What is Home and Data.
The step in data mining that is the hardest, yet many companies spend too little time on it.
What is setting the business objectives.
A nested if statement is used when you have this.
What is when an inner condition only needs to be checked if an outer condition is true.
A series of yes/no questions would often be found in this type of predictive model.
What is a decision tree.
If you were saving stock prices along with a "moving average line. The number of days that would have the most variation would be this from this group ( 10 days, 15 days, 30 days, 180 days)
What is 10 days.
The smallest number would have the most variation the largest number would have the least variation.
This technique requires LARGE amounts of data.
What is data mining.
Honor points a students would earn for a C+ on a 3 credit course?
What is 6.9