Excel Final Exam
Constraints
By what rules does the Solver abide when finding a solution?
Nondecimal Number
For constraints, what does the use of an integer represent?
Forecast
Goal Seek is located in which section of the Excel Ribbon?
What-If Analysis
Goal Seek is one of three items that comprise which Excel tool set?
A mini filter symbol appears next to the down arrow
How do the AutoFilter arrow buttons change when you're filtering your table?
1
How many cells can Goal Seek change in a single application?
The chart will change automatically to reflect the new numbers
If you change one or more of the numbers in a worksheet from which a chart was derived, how will the chart respond?
Design
If you want to move your chart location, which tab on the Chart Tools Ribbon is the Move Chart option found on?
Numbers and labels
In order to create a meaningful bar, line, pie, or column chart in Excel, what must your worksheet have present and available for selection before you create the chart?
Min, Max, and Value of
In the Solver parameters, what are the options for setting the target cell?
Math and Trig
In which category will you find the SUMIF function?
LOOKUP and REFERENCE
In which function category would you find the MATCH function?
Group Selection
On the Analyze tab, what is the icon that looks like an arrow pointing to the right?
Collapse Field
On the PivotTable Analyze tab, what is the icon that looks like a little red minus sign?
Format
What additional tab on the Ribbon appears when you create or select a PivotChart as compared to a PivotTable?
Markers
What are the data points along the Sparklines called?
Filtering
What can you use the "Drop Report Filter Fields Here" rectangle in the PivotTable area for?
Data Labels
What chart option allows you to insert labels such as a number, percentage, or category name to each column, line, or pie slice of a chart?
INDEX and MATCH
What combination of nested functions behaves like the VLOOKUP function?
Macro
What do you call a short program that you can write to automate a task you find yourself performing repeatedly?
Table
What does Excel call a worksheet area with an initial row of labels?
Chart Title
What does Excel call the element normally found at the top of a chart that is used as an informative header?
Be flexible and plan ahead
What does your success with the Solver really depend on your ability to do?
COUNTIF
What function is a close sibling to SUMIF, but instead it counts the number of records that meet the criteria?
INDEX
What function uses an array, row_num, and column_num as function arguments?
SUMIFS uses multiple criteria
What is the difference between the SUMIF and SUMIFS functions?
Give it a name
What is the first step in recording a macro?
The Sparkling
What must you first select before you can format a Sparkline?
Absolute
What type of cell addresses should you use to prevent column letters or row numbers from changing when you're copying a formula?
Design
When selecting any Sparkline, which contextual Ribbon appears?
Select the "And" option
When you give Excel's AutoFilter two conditions, what should you do to ensure both conditions are met?
Quick Access Toolbar
Where can you store and quickly process macros?
Personal Macro Workbook
Where must you store your macro so that it's available in any open workbook?
Goal Seek
Which Excel feature would you use if you know the result that you want from a formula but aren't sure what input value the formula needs to get that result?
Analyze
Which PivotTable Tools tab contains the toggle feature that shows or hides the field headers?
Filters
Which PivotTable area creates an overall filter for the entire report?
Top 10
Which PivotTable filter option displays the best (or worst) performers?
Analyze
Which PivotTable-specific tab contains the Refresh command?
Design
Which PivotTable-specific tab on the Ribbon contains the option to apply a colorful style to your report?
COUNTIFS
Which Statistical function will count the number of records based on multiple criteria?
statistical
Which category contains functions that allow you to calculate averages, deviations, distributions, and probabilities?
Waterfall
Which chart is ideal for a quick view of a profit and loss financial statement?
Bubble
Which chart type allows you to associate three numbers with each data point?
X Y Scatter
Which chart type do scientists, engineers, and statisticians use to create scatter plots?
Line
Which chart type fills gaps in knowledge about the collected data?
financial
Which functions can you use to calculate depreciation, rates of return, future values, and loan payment amounts?
logical
Which functions give your worksheets decision-making powers?
Table_Array
Which of the following arguments would you use in the VLOOKUP function?
Sum_Range
Which of the following is a component of the SUMIF function?
Win/Loss
Which of the following is a type of Sparkline?
*.
Which of the following symbols can you use as an AutoFilter wildcard to represent any number of characters?
?.
Which of the following symbols can you use as an AutoFilter wildcard to represent one (and only one) character?
CTRL+SHIFT+C
Which shortcut key is acceptable to assign to a macro?
proper
Which text function capitalizes the first letter and applies lowercase to the remaining letters?
concatenate
Which text function will combine multiple text fields into a single cell?
Doughnut
Which type of chart works like a pie chart but can graph multiple columns of numbers instead of one?
The ability to add constraints and manipulate multiple values
Why is Solver vastly more powerful than the Goal Seek tool?
A payment is a cash outflow
Why is the result of the PMT function negative?
Table
Within your workbook area, what should you have in place before you attempt to create a PivotTable report?
Insert
You'll find Sparklines on which Ribbon tab?