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 |