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;
23 Cards in this Set
- Front
- Back
Net Sales
|
Sales - Sales Discounts - Sales R & A
|
|
Net Purchases
|
Purchases - Purchase Discounts - Purchase R & A + Transportation In
|
|
Cost Of Delivered Merchandise
|
Purchases + Transportation In
|
|
Cost of Merchandise Available
|
Net Purchase + Beginning Inventory
|
|
Cost Of Merchandise Sold
|
Cost Of Merchandise Available - Ending Inventory
|
|
Gross Profit
|
Net Sales - Cost Of Merchandise Sold
|
|
Operating Income
|
Gross Profit - Total Expenses
|
|
Net Income
|
Operating Income - Federal Income Taxes
|
|
|
|
|
|
|
|
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
|
|
pivot ttable and pivotchart wizard
|
guides you through the steps to make a pivot chart or table
|
|
refresh
|
recalculate
|