# Quiz: Business Mathematics & Statistics #4

15 Questions | Total Attempts: 245  Settings Create your own Quiz BUSINESS MATHEMATICS & STATISTICS

• 1.
Store A marked down a \$ 50 perfume to \$ 40 with markdown of  \$10 The % Markdown is:
• A.

10%

• B.

20%

• C.

30%

• D.

40%

• 2.
Given Net price of shirt = \$20, Discount =  10%, List price will:
• A.

\$22

• B.

\$24

• C.

\$26

• D.

\$30

• 3.
Which is the correct syntax for the determinant of a matrix given by the following array:
• A.

=DETERM(B4:E7)

• B.

=MDTERM(B4:E7)

• C.

=MDETERM(B4:E7)

• D.

=MDETERM(B4;E7)

• 4.
VDB returns the depreciation of an asset for:
• A.

Zero period

• B.

One period

• C.

Two period

• D.

Any arbitrary period

• 5.
If the cost & selling price of a pen are Rs.12 & Rs.15 respectively, profit percentage is:
• A.

33.33%

• B.

25%

• C.

20%

• D.

10%

• 6.
This example returns the depreciation for an asset that costs Rs. 10,000, with a salvage value of \$8,000. The useful life of the asset is 5 years. The depreciation is being calculated for the third year, and there are 10 months in the first year.
• A.

=DB (10000, 5, 8000, 3, 10)

• B.

=DB (10000, 8000, 5, 10, 3)

• C.

=DB (10000, 8000, 5, 3, 10)

• D.

=DB (10000, 8000, 10, 3, 5)

• 7.
Which of the following functions is not related to financial analysis?
• A.

AMORDEGRC

• B.

AMORLINC

• C.

CUMIPMT

• D.

MDETERM

• 8.
Dimension of a matrix means:
• A.

Column space

• B.

Row space

• C.

Order of the matrix

• D.

None of these

• 9.
If there is a -30% change in the price of an item, what does the negative sign show?
• A.

The price is increasing.

• B.

The price is decreasing.

• C.

The price has low rate of change.

• D.

None of the above.

• 10.
Write a formula to find the simple interest (I) if \$5000 is invested at 4% for 2 years.
• A.

I=PRT

• B.

I=P+R+T

• C.

I=PT

• D.

I=P(R+T)

• 11.
Every percentage can be converted into:
• A.

Decimal

• B.

Ratio

• C.

Proportion

• D.

Both decimal & ratio

• 12.
Monthly installments of a leased car are calculated by using the techniques of:
• A.

Simple interest method

• B.

Compound interest method

• C.

Annuity

• D.

Hit & trial method

• 13.
Suppose that you are spending 1500 dollars in an investment and Accumulated factor is 15 then Accumulated Value will be:
• A.

22550

• B.

22500

• C.

21000

• D.

22510

• 14.
What is the interest on Rs. 1600 for one year at the rate 3-1/2 %?
• A.

65

• B.

56

• C.

75

• D.

90

• 15.
Write the output of B9, B10, B11 and B12. If you think the formula is incorrect write "Error" in output.
• A.

The output of =sum(B3,B4,B5,B6) = 100

• B.

=multiply(B5,B6) will not give result because multiply is not a excel function

• C.

B4/B6 is not a formula because in excel formula must start with "="

• D.

=B4% will return 0.2

Related Topics Back to top
×

Wait!
Here's an interesting quiz for you.