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 that is made to another worksheet
|
|
outline
|
grouping of your data
|
|
subtotals
|
calculates subtotals and grand totals for groups of data according to your criteria
|
|
summary function
|
sum or average
|
|
scenarios
|
a set of values that excel saves and can be substituted into your worksheet
|
|
tredline
|
a graphric representation of trends in data
|
|
polynomial tredline
|
a curved line that is used when data fluctuates
|
|
goal seek
|
a command that lets you find the value for a variable that will make the results of a formula equal to a specified value
|
|
solver
|
helps you solve certain kinds of problems involving changing multiple cells
|
|
constraints
|
a limit set to control the changes made to the cell
|
|
pivot table
|
an interactive table that quickly summarizes large amounts of data from a list or table
|
|
pivot chart
|
uses the same data to display it in different ways
|
|
consolidate
|
data from more than one worksheet or workbook
|
|
pivot table and pivot chart wizrd
|
guides you through the steps to create a pivot chart or pivot table
|
|
refresh
|
to recalculate or redisplay data
|