Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
15 Cards in this Set
- Front
- Back
a cell reference made to another worksheet
|
3-D reference
|
|
data from more than one worksheet or workbook.
|
Consolidate
|
|
a limit set to control the changes made to the cell.
|
Constraint
|
|
a command that lets you find the value for a variable that will make the result of a formula equal to a specified value.
|
Goal Seek
|
|
grouping of your data in a worksheet.
|
Outline
|
|
a chart based on a Pivot Table.
|
PivotChart
|
|
is an interactive table that quickly summarizes large amounts of data from a list or table.
|
PivotTable
|
|
guides you through the steps to create a PivotTable or PivotChart.
|
PivotTable and PivotChart Wizard
|
|
a curved line that is used when data fluctuates.
|
Polynomial Trendline
|
|
recalculate.
|
Refresh
|
|
a set of values that Excel saves and can be substituted in your worksheet.
|
Scenario
|
|
helps you solve certain kinds of problems involving changing multiple cells.
|
Solver
|
|
tools used to group data in a worksheet and create totals for each grouping as well as a grand total.
|
Subtotals
|
|
a function an Excel that is used to summarize data, such as SUM or AVERAGE.
|
Summary Function
|
|
a graphic representation of trends in data.
|
Trendline
|