Quiz: Business Mathematics & Statistics #4

15 Questions | Total Attempts: 143

SettingsSettingsSettings
Please wait...
Quiz: Business Mathematics & Statistics #4

BUSINESS MATHEMATICS & STATISTICS


Questions and Answers
  • 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

Back to Top Back to top