The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Store A marked down a $ 50 perfume to $ 40 with markdown of $10
The % Markdown is:
A.
10%
B.
20%
C.
30%
D.
40%
Correct Answer B. 20%
Explanation The percentage markdown can be calculated by dividing the markdown amount by the original price and then multiplying by 100. In this case, the markdown amount is $10 and the original price is $50. So, the percentage markdown is (10/50) * 100 = 20%.
Rate this question:
2.
Given Net price of shirt = $20, Discount = 10%, List price will:
A.
$22
B.
$24
C.
$26
D.
$30
Correct Answer A. $22
Explanation The list price of the shirt will be $22. This can be calculated by subtracting the discount amount from the net price. Since the discount is 10% of the net price, which is $20, the discount amount is $2. Subtracting $2 from the net price gives us $20 - $2 = $22, which is the list price of the shirt.
Rate this question:
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)
Correct Answer C. =MDETERM(B4:E7)
Explanation The correct syntax for the determinant of a matrix given by the array B4:E7 is =MDETERM(B4:E7).
Rate this question:
4.
VDB returns the depreciation of an asset for:
A.
Zero period
B.
One period
C.
Two period
D.
Any arbitrary period
Correct Answer D. Any arbitrary period
Explanation VDB, which stands for Variable Declining Balance, is a function used in financial calculations to determine the depreciation of an asset. Unlike other depreciation methods that calculate depreciation for specific periods, VDB allows for depreciation to be calculated for any arbitrary period. This means that it can be used to determine depreciation for any desired time frame, regardless of whether it is a zero, one, two, or any other period. Therefore, the correct answer is that VDB can be used to calculate depreciation for any arbitrary period.
Rate this question:
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%
Correct Answer B. 25%
Explanation The profit percentage can be calculated by subtracting the cost price from the selling price, and then dividing the result by the cost price. In this case, the profit is Rs.15 - Rs.12 = Rs.3. Dividing Rs.3 by Rs.12 and multiplying by 100 gives a profit percentage of 25%.
Rate this question:
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)
Correct Answer C. =DB (10000, 8000, 5, 3, 10)
Explanation The correct answer is =DB (10000, 8000, 5, 3, 10). This is the correct formula to calculate the depreciation for the given asset. The parameters in the formula are in the correct order and correspond to the cost of the asset, salvage value, useful life, period, and months. The formula will accurately calculate the depreciation for the third year considering the 10 months in the first year.
Rate this question:
7.
Which of the following functions is not related to financial analysis?
A.
AMORDEGRC
B.
AMORLINC
C.
CUMIPMT
D.
MDETERM
Correct Answer D. MDETERM
Explanation MDETERM is not related to financial analysis because it is a mathematical function used in linear algebra to calculate the determinant of a matrix. Financial analysis involves analyzing financial statements and data to make informed decisions about investments, budgeting, and other financial matters. The other three functions listed (AMORDEGRC, AMORLINC, and CUMIPMT) are all specific financial functions used in Excel for calculating different financial metrics such as amortization and cumulative interest payments.
Rate this question:
8.
Dimension of a matrix means:
A.
Column space
B.
Row space
C.
Order of the matrix
D.
None of these
Correct Answer C. Order of the matrix
Explanation The dimension of a matrix refers to the number of rows and columns it has, which is also known as the order of the matrix. It is determined by the number of elements in each row and column. Therefore, the correct answer is "Order of the matrix."
Rate this question:
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.
Correct Answer B. The price is decreasing.
Explanation The negative sign in the -30% change in price indicates that the price is decreasing. A negative sign denotes a decrease or reduction in value, and in this case, it represents a decrease of 30% in the price of the item.
Rate this question:
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)
Correct Answer A. I=PRT
Explanation The formula to find the simple interest is I = PRT, where I represents the interest, P represents the principal amount (in this case $5000), R represents the rate of interest (4%), and T represents the time period (2 years). By substituting the given values into the formula, we can calculate the simple interest.
Rate this question:
11.
Every percentage can be converted into:
A.
Decimal
B.
Ratio
C.
Proportion
D.
Both decimal & ratio
Correct Answer D. Both decimal & ratio
Explanation Every percentage can be converted into both decimal and ratio formats. Converting a percentage to a decimal involves dividing the percentage value by 100. For example, 50% can be converted to 0.50 as a decimal. On the other hand, converting a percentage to a ratio involves expressing it as a fraction with a denominator of 100. For instance, 75% can be written as the ratio 75/100. Therefore, both decimal and ratio formats can be used to represent percentages.
Rate this question:
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
Correct Answer B. Compound interest method
Explanation The monthly installments of a leased car are calculated using the compound interest method. This method takes into account the principal amount, the interest rate, and the time period over which the installments will be paid. Compound interest is calculated by adding the interest earned to the principal amount, and then calculating interest on the new total for each time period. This ensures that the interest is compounded and the monthly installments are adjusted accordingly.
Rate this question:
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
Correct Answer B. 22500
Explanation The accumulated value of an investment can be calculated by multiplying the amount invested by the accumulated factor. In this case, the accumulated factor is 15, so multiplying 1500 dollars by 15 gives us an accumulated value of 22500 dollars.
Rate this question:
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
Correct Answer B. 56
Explanation The interest on Rs. 1600 for one year at the rate of 3-1/2% can be calculated using the formula: Interest = (Principal * Rate * Time) / 100. Plugging in the given values, we have (1600 * 3.5 * 1) / 100 = 56. Therefore, the interest on Rs. 1600 for one year at the rate of 3-1/2% is 56.
Rate this question:
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
Correct Answer C. B4/B6 is not a formula because in excel formula must start with "="