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 CELL REFERENCE
|
|
COMBINE DATA FROM MORE THAN ONE WORKSHEET OR WORKBOOK
|
CONSOLIDATE
|
|
THE LIMITATIONS PLACED ON A SOLVER PROBLEM
|
CONSTRAINT
|
|
A METHOD TO FIND A SPECIFIC VALUE FOR A CELL BY ADJUSTING THE VALUE OF THE OTHER CELL. EXCEL VAIRES THE VALUE IN A CELL THAT YOU SPECIFY UNTIL A FORMULA THAT'S A DEPENDENT ON THAT CELL RETURNS THE RESULT YOU WANT.
|
GOAL SEEK
|
|
GROUPING OF DATA IN A WORKSHEET.
|
OUTLINE
|
|
A view used to summarizedata and perform calculation on it. It is displayed in a chart of graph such as a bar or pie chart.
|
Pivot Chart
|
|
An interactive table that quickly summarizes large amounts of data from alist or table.
|
Pivot Table
|
|
The wizard that isused to create Pivot Charts and Pivot Tables in a workbook
|
Pivot Table and Pivot Table Chart Wizard
|
|
A curved trendline that is used when data fluctuates
|
Polynomial Trendline
|
|
To recalculate or redislay data.
|
Refresh
|
|
A set of values that Excel saves and can be subsituted in your worksheet.
|
Scenario
|
|
A tool used to find an optimal value for a formula in one cell (the target cell) on a worksheet.
|
Solver
|
|
A tool used to group data in a worksheet and create totals for each grouping as well as a grand total.
|
Subtotals
|
|
A function in Excel that is used to summarize data, such as SUM or AVERAGE
|
Summary Function
|
|
A graphic representation of trends in data.
|
Trendline
|