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?