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
3-D reference
|
a cell reference made to another work sheet in the same workbook
|
|
consolidate
|
combine data from more than one worksheet or workbook.
|
|
constraint
|
a limit set to control the changes made to the cell.
|
|
Goal Seek
|
a command that lets you find the value for a variable that will make the result of a formula equal to a specified value.
|
|
outline
|
grouping up data in a worksheet
|
|
PivotChart
|
a chart based on a Pivot Table
|
|
PivotTable
|
is an interactive table that quickly summarizes large amounts of data from a list or table
|
|
PivotTable and PivotChart Wizard
|
guides you through the steps to create a pivot table or pivot chart.
|
|
Polynomial Trendline
|
a curved line that is used when data fluctuates
|
|
refresh
|
recalculate
|
|
scenario
|
a set of values that excel saves and can be substituted in your worksheet
|
|
Solver
|
helps you solve certain kinds of problems involving changing multiple cells.
|
|
subtotals
|
a tool used to group data in a worksheet and create totals for each grouping as well as a grand total.
|
|
summary function
|
a function in Excel that is used to summarize data, such as SUM or AVERAGE
|
|
trendline
|
a graphic representation of trends in data
|