final Flashcards
What is the purpose of a budget?
To predict revenue, expenses, and profit for a future period
How is gross profit calculated?
Total income minus COGS
A decision support tool that allows users to change assumption value to predict different outcomes is called?
What if analysis
The intersection of a column and row is called?
a cell
A ____ is a contiguous group of cells
Range
You can toggle on and off the formula view T/F
True
Earning per share is a key factor in determining the future price of a company’s stock. If a company has a higher EPS then:
It would bring higher returns for the stockholders
If a PE ratio is higher then it means?
All of the above
___ summarizes a companies assets, liabilities, and shareholders equity at a specific point in time?
Balance Sheet
____ is the measure to know if an asset can be converted to cash
liquitidy
___ are the obligations a company pays in a year
Current liabilities
____ are the cumulative income of a company over time that are retained within the company
Retained Earnings
Which of the following ratios is not a measure of liquidity?
Total debt ratio
The time value of money means?
Money available now is worth more than the same amount of money in the future
_____ is the amount of the loan
Principal
____ is the cost paid to borrow the money
Interest Rate
____ the number used to pay the loan
Term of the loan
Variables in the function are called?
Arguments
The main purpose of Weighted criteria analysis is?
To help in understanding the subjective business decision that businesses have to constantly make
___ is used to evaluate each alternative against criterion
Ranking system
Mutually exclusive choices are evaluated by the things called
Alternatives
Th ___ identifies color and name of each data series
Legend
___ are the assumption values that change
Changing cells
___ indenitifys key subtotals used to find scenerios
Result cells
__ displays the name of the currently selected cell
Name box
___ in formulas copy as what cell addresses?
absolute
To navigate quickly in a large workbook, use?
Range names
____ is when a company’s total revenues are equal to its expenses
Breakeven point
Which of the following statements is correct about breakeven analysis?
All of the above
Revenue recieved after breakeven point generally represents
Profits
Expenses that are discretionary can ___ at managments will?
Increase or decrease
Which of the following is a correct formula for calculating breakeven point?
Fix Costs/Unit Price (Unit Variable cost)
__ do not vary based on sales costs
Fixed expenses
Regression analysis is used to model any business problem where you need to determine if one variable can be used to predict another?
Regression Analysis
The ____ is the variable that we try to predict based on the value of the independent variable
dependent variable
___determines the equation for a straight line that most closely describes how the line moves
Linear regression
The strength of degree of a relationship is called?
correlation
Which Trendline does not have any curve
Linear
R squared values range from?
0-1
In a linear programming model the answer that you are seeking are represent by x and y in all equations, which are also called?
decision variables
The area of the possible solutions is identified by the charging the constrained formulas on a graph. This is also called?
Feasible region
A relational database is
Collection of related data lists
In relational databsae, a ____ stores all data related to one subject?
Table
In a relational database, the field that contains unique data for each field is called?
Primary key field
In joining two tables to create one to many relationships, a primary key field is used which represent on side of of a one to many relastionships
Primary key
In one to many relationship, a ____ field indicated that may have many related records in the other table
Foreign key
The best way to retrieve a data based on your question is to use a?
Query
In the query design view, the field that we want to display in the datasheet view must be shown in the?
Design grid
___ will limit the record that will be included when the query is run in the datasheet view
Criteria
If we are creating a query and using 2 criteria to display the records and if we want both the criteria to be satisfied then we should use the ___ operator
AND
You use ____ criteria when any one criterion may be true in order for the record to be selected
OR
