Interested in a PLAGIARISM-FREE paper based on these particular instructions?...with 100% confidentiality?

Order Now

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 1. 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

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

  1. 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

 

Interested in a PLAGIARISM-FREE paper based on these particular instructions?...with 100% confidentiality?

Order Now