MTH302 Grand Quiz Searchable

Mth302 - grand quiz

Business Math and Stats (Virtual University of Pakistan)

Scan to open on Studocu

Studocu is not sponsored or endorsed by any college or university

Mth302 - grand quiz

Business Math and Stats (Virtual University of Pakistan)

Scan to open on Studocu

Studocu is not sponsored or endorsed by any college or university

BUSINESS MATHEMATICS AND STATISTICS – MTH302 (GRAND QUIZ)

For the implementation of XIRR function, the series off values must contain at least:

One positive value One negative value One negative OR one positive value One negative AND one positive value

Difference between IRR and XIRR is that _________.

IRR needs regular interval, but XIRR does not need regular intervals XIRR does not calculate internal rate, as IRR does The schedule cash flows are needed for IRR only

In EXCEL worksheet, cell D1 and D3 has numeric data which of the following formula is correct for finding product of data in these cells?

=(D1)(D3) =D1.D3 =D1*D3 =D1:D3

What is 5% of 85?

(5 / 100 ) x 85 5 x 100 x 85 ( 5 / 100 ) / 85 (5 / 85 ) x 100

______ returns the straight-line depreciation of an asset for one period.

SLN SYD VDB IRR

If a matrix ‘M’ and a number ‘c’, then, which of the following is true for computing the scalar multiplication ‘cM’?

Divide the scalar ‘c’ by every element of ‘M’ Multiply the scalar ‘c’ by every element of ‘M’ Add the scalar ‘c’ by every element of ‘M’ Subtract the scalar ‘c’ by every element of ‘M’

BEP in units is given by the following formula: I = FC/CM

I II BEP in Rs is given by the following formula: I = FC/CM

I II

It is asked to find a number whose 7% is 54? Which of the following is required to be evaluated?

Fraction Base Percentage Rate

Round 3.1456 to 3 decimal places.

3. 14
4. 146
5. 145

MINVERSE is the _______ function of Microsoft Excel.

Sum fraction Set function Matrix function None

If Rs. 40,000 is the price of a laptop, along with 20%, 10% and 5% of series discounts. Then which of the following is true for calculating the net price?

40,000(1+0.20)(1+0.10)(1+0.05) 40,000(1-0.20)+(1-0.10)+(1-0.05) 40,000(1-0.20)(1-0.10)(1-0.05) 40,000(1-0.20)-(1-0.10)-(1-0.05)

If P is the principal amount, T is the time in years and R is the rate of interest per annum, then simple interest will be

I = P.R.T X 100 I = P. R.T

I = P.R.T I = P.R

In order to stimulate the demand, the deduction in original sale price of an item is called:

Discount Markup Retail price Markdown