BASIC GRD 500 QUESTIONS TEST. – MUST GET A 100 on this.
EXCEL QUESTIONS
What happens to a cell when you use Ctrl + Shift + 5
| Converts to General numbers | ||
| Converts to Dollars | ||
| Converts to Percentage | ||
| Converts to Scientific |
To hide a worksheet you would
| Ctrl + h | ||
| Alt + h | ||
| Right shift the sheet and hide | ||
| Ctrl + shift + h |
How can you tell which column is active on a spreadsheet?
| The boarder flashes | ||
| The column turns grey shade | ||
| The contents turn blue | ||
| None of the above |
Sorting commands are found on this tab in the Ribbon
| Data | ||
| Formulas | ||
| Review | ||
| Insert |
What formula would you use to total the numbers in a column?
| Total | ||
| Add | ||
| Sum | ||
| Quantity |
When you copy/paste data from a filtered list, only the visible data is used:
| True | ||
| Falso |
Database functions consist of the Function name and three arguments: Database, Field, and _________.
| List | ||
| Row | ||
| Criteria | ||
| Column |
To quickly convert a list into a table
| Alt + T | ||
| Ctrl + F2 | ||
| Alt + Tab | ||
| Ctrl + T |
ECONOMICS
___________ can change human behavior. A sale sign in a window is an example.
| Incentives | ||
| Super goals | ||
| The desire to spend more | ||
| False economics |
Government might intervene in Markets when the Markets:
| are not the way they like. | ||
| fail to allocate resources effectively. | ||
| fail to allocate resources fairly. | ||
| both 2 and 3. |
A place where people make exchanges is called a ____________.
| exchange forum | ||
| market | ||
| exchange system | ||
| price place | ||
| Only 1 and 2 |
___________ creates something that has an impact beyond the immediate buyer and seller of the product.
| Economics | ||
| Externality | ||
| Incentives | ||
| Margins | ||
| Only 1 and 2 |
The ____________ is what you give up to get it.
| Cost of Goods Sold | ||
| The Ten Principles | ||
| Seller’s Example | ||
| Cost of Something | ||
| None of the above |
The New York Stock Exchange is a ____________ of our economy.
| microcosm | ||
| microsystem | ||
| microduct | ||
| All of the above | ||
| Only A and B |
The basic reasons countries trade are to:
| get items cheaper than they can produce them. | ||
| to be international players. | ||
| to sell items that they are good at producing. | ||
| both 1 and 3. | ||
| both 1 and 2. |
People make a decision to do something when the marginal __________ exceeds the marginal __________.
| benefit; cost | ||
| cost; benefit | ||
| time; opportunity | ||
| opportunity; time |
______________ are the means by which goods and services are rationed.
| Incentives | ||
| Adjustments | ||
| Prices |
Rational people think at the ______________.
| rational time. | ||
| economics level. | ||
| margin. | ||
| both 1 and 2. | ||
| both 2 and 3. |
FINANCE 1
Which of the following causes the NPV to be zero?
| Net Present Value | ||
| Payback method | ||
| Internal Rate of Return | ||
| Modified Internal Rate of Return |
__________ is the math of finance whereby interest is earned over time by saving or investing money.
| Future value | ||
| Present value | ||
| Principal | ||
| Time Value of Money |
Which one of the following functions is not found on a financial calculator?
| FV | ||
| PV | ||
| PMT | ||
| NoP |
__________is a nation’s output of goods and services achieved over a specified period of time, such as one year.
| Net exports of goods and services | ||
| GDP | ||
| Government expenditures including gross investment | ||
| PCE |
For the comparison of cash flows to be accurate all amounts should be stated at their value at one point in time, generally the present?
| True | ||
| False |
What kind of portfolio contains all risky assets?
| Human capital portfolio | ||
| Market portfolio | ||
| Beta portfolio | ||
| Capital asset portfolio |
True or false: Inflation is defined as the overall increase in prices over time?
| True | ||
| False |
QUESTION 8
- What is the Net Present Value?
| The future value of a project’s cash flows plus its cost | ||
| The present value of a project’s cash flows plus its cost | ||
| The future value of a project’s cash flows minus its cost | ||
| The present value of a project’s cash flows minus its cost |
What is the basic function of money?
| It has never been an acceptable medium of exchange | ||
| It is an unacceptable medium of exchange | ||
| It is an acceptable medium of exchange | ||
| It is not currency, demand deposits, or cash |
A bond that is selling below par value is referred to as what kind of bond?
| A junk bond | ||
| A premium bond | ||
| A discount bond | ||
| A convertible bond |