final

Question 1

What is the purpose of a budget?

Answer 1

To predict revenue, expenses, and profit for a future period

Question 2

How is gross profit calculated?

Answer 2

Total income minus COGS

Question 3

A decision support tool that allows users to change assumption value to predict different outcomes is called?

Answer 3

What if analysis

Question 4

The intersection of a column and row is called?

Answer 4

a cell

Question 5

A ____ is a contiguous group of cells

Answer 5

Range

Question 6

You can toggle on and off the formula view T/F

Answer 6

True

Question 7

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:

Answer 7

It would bring higher returns for the stockholders

Question 8

If a PE ratio is higher then it means?

Answer 8

All of the above

Question 9

___ summarizes a companies assets, liabilities, and shareholders equity at a specific point in time?

Answer 9

Balance Sheet

Question 10

____ is the measure to know if an asset can be converted to cash

Answer 10

liquitidy

Question 11

___ are the obligations a company pays in a year

Answer 11

Current liabilities

Question 12

____ are the cumulative income of a company over time that are retained within the company

Answer 12

Retained Earnings

Question 13

Which of the following ratios is not a measure of liquidity?

Answer 13

Total debt ratio

Question 14

The time value of money means?

Answer 14

Money available now is worth more than the same amount of money in the future

Question 15

_____ is the amount of the loan

Answer 15

Principal

Question 16

____ is the cost paid to borrow the money

Answer 16

Interest Rate

Question 17

____ the number used to pay the loan

Answer 17

Term of the loan

Question 18

Variables in the function are called?

Answer 18

Arguments

Question 19

The main purpose of Weighted criteria analysis is?

Answer 19

To help in understanding the subjective business decision that businesses have to constantly make

Question 20

___ is used to evaluate each alternative against criterion

Answer 20

Ranking system

Question 21

Mutually exclusive choices are evaluated by the things called

Answer 21

Alternatives

Question 22

Th ___ identifies color and name of each data series

Answer 22

Legend

Question 23

___ are the assumption values that change

Answer 23

Changing cells

Question 24

___ indenitifys key subtotals used to find scenerios

Answer 24

Result cells

Question 25

__ displays the name of the currently selected cell

Answer 25

Name box

Question 26

___ in formulas copy as what cell addresses?

Answer 26

absolute

Question 27

To navigate quickly in a large workbook, use?

Answer 27

Range names

Question 28

____ is when a company’s total revenues are equal to its expenses

Answer 28

Breakeven point

Question 29

Which of the following statements is correct about breakeven analysis?

Answer 29

All of the above

Question 30

Revenue recieved after breakeven point generally represents

Answer 30

Profits

Question 31

Expenses that are discretionary can ___ at managments will?

Answer 31

Increase or decrease

Question 32

Which of the following is a correct formula for calculating breakeven point?

Answer 32

Fix Costs/Unit Price (Unit Variable cost)

Question 33

__ do not vary based on sales costs

Answer 33

Fixed expenses

Question 34

Regression analysis is used to model any business problem where you need to determine if one variable can be used to predict another?

Answer 34

Regression Analysis

Question 35

The ____ is the variable that we try to predict based on the value of the independent variable

Answer 35

dependent variable

Question 36

___determines the equation for a straight line that most closely describes how the line moves

Answer 36

Linear regression

Question 37

The strength of degree of a relationship is called?

Answer 37

correlation

Question 38

Which Trendline does not have any curve

Answer 38

Linear

Question 39

R squared values range from?

Answer 39

0-1

Question 40

In a linear programming model the answer that you are seeking are represent by x and y in all equations, which are also called?

Answer 40

decision variables

Question 41

The area of the possible solutions is identified by the charging the constrained formulas on a graph. This is also called?

Answer 41

Feasible region

Question 42

A relational database is

Answer 42

Collection of related data lists

Question 43

In relational databsae, a ____ stores all data related to one subject?

Answer 43

Table

Question 44

In a relational database, the field that contains unique data for each field is called?

Answer 44

Primary key field

Question 45

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

Answer 45

Primary key

Question 46

In one to many relationship, a ____ field indicated that may have many related records in the other table

Answer 46

Foreign key

Question 47

The best way to retrieve a data based on your question is to use a?

Answer 47

Query

Question 48

In the query design view, the field that we want to display in the datasheet view must be shown in the?

Answer 48

Design grid

Question 49

___ will limit the record that will be included when the query is run in the datasheet view

Answer 49

Criteria

Question 50

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

Answer 50

AND

Question 51

You use ____ criteria when any one criterion may be true in order for the record to be selected

Answer 51

OR