• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

Card Range To Study

through

image

Play button

image

Play button

image

Progress

1/15

Click to flip

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