MTH 302 Complete Preparation

Prepare for your MTH302 exams with our comprehensive lesson-wise MCQs! Each MCQ is designed to test your understanding of the key concepts in mathematics, helping you excel in both your midterms and finals. Detailed explanations are provided for each answer to ensure you grasp the material thoroughly.

/25

Lesson 2

1 / 25

What is the cell reference for a cell in column B and row 15?

2 / 25

What does the range A1:D5 include in Excel?

3 / 25

How do you correct a mistake in an Excel cell?

4 / 25

If 16 is in cell A85 and 2 in cell B85, what formula calculates 16^2?

5 / 25

Which operator is used for exponentiation in Excel?

6 / 25

What does the range A1:D5 include?

7 / 25

What happens if you press Enter after entering data in a cell?

8 / 25

Which Excel function can also be used for exponentiation?

9 / 25

What is the correct Excel formula to calculate the sum of numbers in cells A34 to F34?

10 / 25

In Excel, which operator is used for multiplication?

11 / 25

What is the first step to open Microsoft Excel?

12 / 25

Which formula calculates the sum of 5, 10, 15, 20, 30, and 40 in Excel?

13 / 25

Which operator is used for subtraction in Excel?

14 / 25

How do you reference a cell in row 10 and column C?

15 / 25

If the formula =A1+B1 is entered in Excel, what does it do?

16 / 25

In Excel, what does the formula =5+4 return?

17 / 25

Which formula multiplies values in cells A60 and B60?

18 / 25

How is 20% represented as a fraction in Excel?

19 / 25

What happens if you press Enter after entering a formula in a cell?

20 / 25

What result does the formula =20% give in Excel?

21 / 25

Which step comes FIRST when entering data into an Excel cell?

22 / 25

If 25 is in cell A50 and 15 is in cell B50, which formula calculates their difference?

23 / 25

What is the multiplication operator in Excel?

24 / 25

To calculate 240 ÷ 15 using Excel, what formula should be written in cell C75?

25 / 25

What should you do to correct a mistake in an Excel cell?

Your score is

0%

/29

Lesson 3

1 / 29

If an employee's gross salary is Rs. 15,000, what is the cost of leaves (18.2%)?

2 / 29

What is the typical percentage of gross salary allocated to group insurance/medical?

3 / 29

If basic salary = Rs. 10,000, what is the total contribution (employee + company) to the Provident Fund?

4 / 29

What percentage is 6% of 40?

5 / 29

What is the company’s contribution to the Provident Fund for an employee with a basic salary of Rs. 10,000?

6 / 29

If a company establishes a Provident Fund, how much of the basic salary does it deduct for the employee's contribution?

7 / 29

Convert 0.1 into a percentage.

8 / 29

What is the total cost of casual, earned, and sick leaves as a percentage of gross salary?

9 / 29

If an employee's basic salary is Rs. 6,000, what is the typical percentage of allowances?

10 / 29

What is the percentage of Rs. 120 at the rate of 20%?

11 / 29

If basic salary = Rs. 10,000 and allowances = Rs. 7,000, what is the taxable income of the employee?

12 / 29

What is the percentage of Conveyance allowance in the common structure of allowances?

13 / 29

Which of the following is NOT included in gross remuneration?

14 / 29

What is the duration of each lecture in this course?

15 / 29

How is House Rent allowance typically calculated as a percentage of basic salary?

16 / 29

Which of the following best describes a common fraction?

17 / 29

What is the formula to convert percentage into a fraction?

18 / 29

What is the gross salary of an employee earning a basic salary of Rs. 10,000 and allowances of Rs. 5,000?

19 / 29

Which of the following is NOT a component of gross salary?

20 / 29

If an employee's gross salary is Rs. 15,000, what is the cost of group insurance/medical?

21 / 29

How many days of Casual Leave are typically allowed per year?

22 / 29

What is the cost of other social benefits (5.8%) for a gross salary of Rs. 15,000?

23 / 29

What is the formula for percentage in terms of base and rate?

24 / 29

For an employee with a basic salary of Rs. 10,000, what is the company’s monthly contribution to the Gratuity Fund?

25 / 29

What is the typical percentage of gross salary allocated to social charges?

26 / 29

Find the base if the percentage is 96 and the rate is 24%.

27 / 29

Which of the following is part of Ethics emphasized in the course?

28 / 29

Convert 20% into a decimal.

29 / 29

What percentage of allowances are tax-free according to taxation rules?

Your score is

0%

/30

Lesson 4

1 / 30

What is the conveyance allowance for an employee with a basic salary of Rs. 6,000?

2 / 30

Which function is used to round off values in Excel?

3 / 30

What is the Excel formula for calculating gratuity, rounded to the nearest integer, if the basic salary is in cell B93?

4 / 30

What is the gross salary of an employee with a basic salary of Rs. 6,000?

5 / 30

If homework is weighted at 10%, quizzes at 20%, and tests at 70%, what weight fraction corresponds to quizzes?

6 / 30

What is the formula for the weighted average?

7 / 30

What Excel function calculates the average of numbers?

8 / 30

What is the gross salary formula in Excel for an employee with a basic salary of Rs. 6,000?

9 / 30

How many decimal places does the ROUND((1/11)*$B$93,0) formula keep in the result?

10 / 30

What is the weighted average hourly wage for labor categories with weights: Skilled (0.6), Semiskilled (0.3), and Unskilled (0.1), and respective wages: 300, 200, and 100?

11 / 30

What does the $ sign in an Excel formula indicate?

12 / 30

In a weighted average, the sum of the weights must always equal:

13 / 30

If Ahmad has grades of 92 (homework), 68 (quiz), and 81 (test), what is his overall grade using weights of 10%, 20%, and 70%, respectively?

14 / 30

What is the average of the dataset: 10, 7, 9, 27, 2?

15 / 30

What does the ROUND function in Excel do?

16 / 30

What is the result of the Excel formula =SUM(B93:B96) if cells B93 to B96 contain values 6000, 2700, 150, and 150 respectively?

17 / 30

What is the Excel syntax for the AVERAGE function?

18 / 30

Which of the following is an Excel formula for calculating social charges (29% of basic salary)?

19 / 30

Which Excel function adds numbers based on criteria stored in a separate range?

20 / 30

What is the Excel formula for calculating house rent based on a basic salary in cell B93?

21 / 30

If you need to add numbers based on multiple conditions, which combination of functions can you use?

22 / 30

Which Excel function is used to add numbers in noncontiguous cells?

23 / 30

What is the formula to calculate average (arithmetic mean)?

24 / 30

If you copy a formula from cell D93 to E93 without $ in the reference, what happens to the reference?

25 / 30

What percentage of the basic salary is allocated to house rent?

26 / 30

Which Excel tool can be used to add all contiguous numbers in a row or column?

27 / 30

What is the syntax of the DSUM function in Excel?

28 / 30

Which Excel function is used to add numbers based on a single condition?

29 / 30

What is the average of the numbers 5, 10, 15, 20, and 25?

30 / 30

What is the result of the formula `=5+10` when typed in an Excel cell?

Your score is

0%

/17

Lesson 5

1 / 17

What is the price-earnings (P/E) ratio for a stock trading at Rs. 43 with earnings of Rs. 1.95 per share?

2 / 17

How is dividend per share calculated?

3 / 17

What is the net cost price of an item with a list price of Rs. 4,500 and a 20% discount?

4 / 17

What is the market value of a stock?

5 / 17

What is the compound interest formula?

6 / 17

If a chartered bank lowers its loan interest rate from 9% to 7%, what is the percentage decrease in the rate?

7 / 17

If Rs. 500 is invested for 4 years at 11% per annum, what is the simple interest?

8 / 17

A company declares a 50% dividend on a share with a face value of Rs. 10. What is the dividend per share?

9 / 17

What is the return on investment (ROI) if shares are bought for Rs. 52.25 and sold for Rs. 68 with a 10% dividend and 1% commission rate?

10 / 17

How is the P/E ratio interpreted in stock valuation?

11 / 17

What is the formula for percentage decrease in Excel, if the rates are in cells F4 and F5?

12 / 17

What does the Net Current Asset Value per Share (NCAVPS) represent?

13 / 17

If you buy 100 shares at Rs. 62.50 per share with a 2% commission, what is the total cost?

14 / 17

What does the face value of a stock represent?

15 / 17

What is the formula for simple interest?

16 / 17

What is the compound interest on Rs. 750 at 12% per annum for 8 years?

17 / 17

If a chartered bank raises its loan interest rate from 7% to 9%, what is the percentage increase in the rate?

Your score is

0%

/45

Lesson 6

1 / 45

If Rs. 500 is invested for 4 years at 11% per annum, what is the simple interest?

2 / 45

What is the compound interest formula?

3 / 45

A company declares a 50% dividend on a share with a face value of Rs. 10. What is the dividend per share?

4 / 45

What is the return on investment (ROI) if shares are bought for Rs. 52.25 and sold for Rs. 68 with a 10% dividend and 1% commission rate?

5 / 45

If you buy 100 shares at Rs. 62.50 per share with a 2% commission, what is the total cost?

6 / 45

If you buy 100 shares at Rs. 62.50 per share with a 2% commission, what is the total cost?

7 / 45

If a chartered bank lowers its loan interest rate from 9% to 7%, what is the percentage decrease in the rate?

8 / 45

What is the compound interest on Rs. 750 at 12% per annum for 8 years?

9 / 45

What is the market value of a stock?

10 / 45

What is the market value of a stock?

11 / 45

How is the P/E ratio interpreted in stock valuation?

12 / 45

What is the net cost price of an item with a list price of Rs. 4,500 and a 20% discount?

13 / 45

What does the face value of a stock represent?

14 / 45

What is the net cost price of an item with a list price of Rs. 4,500 and a 20% discount?

15 / 45

What is the formula for simple interest?

16 / 45

What is the compound interest on Rs. 750 at 12% per annum for 8 years?

17 / 45

What is the return on investment (ROI) if shares are bought for Rs. 52.25 and sold for Rs. 68 with a 10% dividend and 1% commission rate?

18 / 45

What is the compound interest formula?

19 / 45

What is the return on investment (ROI) if shares are bought for Rs. 52.25 and sold for Rs. 68 with a 10% dividend and 1% commission rate?

20 / 45

What is the net cost price of an item with a list price of Rs. 4,500 and a 20% discount?

21 / 45

How is dividend per share calculated?

22 / 45

How is dividend per share calculated?

23 / 45

What is the formula for percentage decrease in Excel, if the rates are in cells F4 and F5?

24 / 45

If Rs. 500 is invested for 4 years at 11% per annum, what is the simple interest?

25 / 45

If you buy 100 shares at Rs. 62.50 per share with a 2% commission, what is the total cost?

26 / 45

What is the market value of a stock?

27 / 45

How is the P/E ratio interpreted in stock valuation?

28 / 45

If Rs. 500 is invested for 4 years at 11% per annum, what is the simple interest?

29 / 45

What does the face value of a stock represent?

30 / 45

What is the price-earnings (P/E) ratio for a stock trading at Rs. 43 with earnings of Rs. 1.95 per share?

31 / 45

How is dividend per share calculated?

32 / 45

What does the Net Current Asset Value per Share (NCAVPS) represent?

33 / 45

What is the compound interest on Rs. 750 at 12% per annum for 8 years?

34 / 45

What is the compound interest formula?

35 / 45

If a chartered bank raises its loan interest rate from 7% to 9%, what is the percentage increase in the rate?

36 / 45

A company declares a 50% dividend on a share with a face value of Rs. 10. What is the dividend per share?

37 / 45

What is the price-earnings (P/E) ratio for a stock trading at Rs. 43 with earnings of Rs. 1.95 per share?

38 / 45

What does the face value of a stock represent?

39 / 45

If a chartered bank lowers its loan interest rate from 9% to 7%, what is the percentage decrease in the rate?

40 / 45

What is the formula for percentage decrease in Excel, if the rates are in cells F4 and F5?

41 / 45

If a chartered bank raises its loan interest rate from 7% to 9%, what is the percentage increase in the rate?

42 / 45

What is the formula for simple interest?

43 / 45

What does the Net Current Asset Value per Share (NCAVPS) represent?

44 / 45

How is the P/E ratio interpreted in stock valuation?

45 / 45

A company declares a 50% dividend on a share with a face value of Rs. 10. What is the dividend per share?

Your score is

0%

/20

Lesson 7

1 / 20

What is the simplified result of (48a^2 – 32ab)/8a?

2 / 20

What is the formula for the discount factor for an annuity?

3 / 20

What is the discounted value of an annuity paying Rs. 2000 semiannually for 10 years at a rate of 11%% compounded semiannually?

4 / 20

What is the result of (-x)(2x^2 - 3x -1)?

5 / 20

Which formula calculates the accumulated value (S) of an annuity?

6 / 20

If an annuity pays Rs. 10,000 for 18 periods at a discount rate of 4.25%%, what is the discounted value?

7 / 20

What is the accumulation factor formula?

8 / 20

Which of the following is NOT a component of algebraic expressions?

9 / 20

What is an annuity?

10 / 20

What is the accumulated value of Rs. 10,000 paid annually for 18 years at 4.25%%?

11 / 20

In the expression 2x^2 – 3x - 1, what type of polynomial is it?

12 / 20

What is the discounted factor for 18 periods at a 4.25%% interest rate?

13 / 20

What is the term for multiplying all terms in a polynomial by a monomial?

14 / 20

What does x = 341.25 + 0.025x simplify to?

15 / 20

What is the present value of Rs. 121 after 2 years at an interest rate of 10%%?

16 / 20

If the interest rate i is 4.25%%, the number of periods n is 18, and the amount of annuity R is Rs. 10,000, what is the accumulated value?

17 / 20

If 36x^2y / 60xy^2 is simplified, what is the result?

18 / 20

How is division by a monomial performed?

19 / 20

What is the value of A in A + 9 = 137?

20 / 20

Which of the following best describes a common fraction?

Your score is

0%

/25

Lesson 9

1 / 25

In an identity matrix, the main diagonal elements are:

2 / 25

If A = [[1 2] [3 4]], what is the order of A?

3 / 25

For a matrix M and scalar c, the scalar multiplication cM means:

4 / 25

What does the order of a matrix represent?

5 / 25

A matrix with dimensions n × 1 is a:

6 / 25

Matrices are widely used in:

7 / 25

If A = [[1 0] [0 1]] and B = [[2 3] [4 5]], then A ⋅ B equals:

8 / 25

An identity matrix is denoted as:

9 / 25

Which letter is commonly used to denote a matrix?

10 / 25

Which matrix is its own inverse?

11 / 25

If a matrix T has order 2 × 3, its number of elements is:

12 / 25

Which matrix has 1's on the diagonal and 0's elsewhere?

13 / 25

A real-life example of a matrix is:

14 / 25

A matrix with dimensions 1 × n is called a:

15 / 25

Dimension of matrix A = [[5 7 9] [2 6 4]] is:

16 / 25

A 3 × 3 square matrix has how many diagonal elements?

17 / 25

A matrix with all zero elements is called a:

18 / 25

A 2 × 3 matrix has:

19 / 25

What is a square matrix?

20 / 25

Which matrix concept is useful in network analysis?

21 / 25

What is a matrix?

22 / 25

Which of the following is a valid matrix multiplication rule?

23 / 25

The plural of matrix is:

24 / 25

If the main diagonal of a matrix is zero, the matrix is called:

25 / 25

For matrix A = [[1 2] [3 4]], what is A + A?

Your score is

0%

/19

Lesson 10

1 / 19

If A = [[2, 4], [6, 8]], then 2A = ?

2 / 19

Overproduction in inventory management can be calculated using:

3 / 19

How many columns does the production matrix P have?

4 / 19

Matrix multiplication is defined when the:

5 / 19

What is the result when you subtract S = [[100, 300], [150, 400]] from P = [[300, 700], [300, 700]]?

6 / 19

Two 2 x 2 matrices A and B are inverses if their product is:

7 / 19

The sales data of two companies for different products is best represented using:

8 / 19

The additive identity for matrices is a matrix filled with:

9 / 19

Matrices can represent data for:

10 / 19

What is the total production for medium-sized sweatshirts across both universities based on their orders?

11 / 19

The resulting dimension of a 3 x 2 matrix multiplied by a 2 x 4 matrix is:

12 / 19

What does a matrix represent in a rectangular array of numbers?

13 / 19

What is required for two matrices to be added or subtracted?

14 / 19

The total revenue from sales can be calculated using matrix multiplication if:

15 / 19

Matrix multiplication of A = [[1, 2], [3, 4]] and B = [[5, 6], [7, 8]] gives:

16 / 19

What is the dimension of a matrix with 4 rows and 3 columns?

17 / 19

In scalar multiplication of matrices, each element is:

18 / 19

Dimension of matrix A = [[5 7 9] [2 6 4]] is:

19 / 19

What is the multiplicative inverse of A = [[1, 0], [0, 1]]?

Your score is

0%

Quizes

/50

Quizs

1 / 50

The net price of an electronic item is Rs. 3400 after a trade discount of 80%. What is the list price?

2 / 50

Depreciation for an asset that costs Rs. 10,000 with a salvage value of $8,000, a useful life of 5 years, calculated for the third year with 10 months in the first year:

3 / 50

After the merchant buys merchandise, it is sold at a higher price called the:

4 / 50

Which function calculates depreciation of the same amount each year over an asset’s useful life?

5 / 50

Write a formula to find the simple interest (I) if $5000 is invested at 4% for 2 years:

6 / 50

VDB returns the depreciation of an asset for?

7 / 50

In a friendly cricket match, Pakistan scores 7% more than India's score of 230. What is Pakistan’s score?

8 / 50

A product costing Rs. 400 is sold at 20% profit. Find the selling price.

9 / 50

If A = [1 2 3], then in order to find AB, the number of columns in B should be:

10 / 50

The price of petrol drops from $1.20 per liter to $0.85 per liter. Find the ratio in which the price decreases.

11 / 50

Suppose you are spending 1500 dollars in an investment and the accumulated factor is 15. The accumulated value will be:

12 / 50

The price of a P4 computer was Rs. 12000 last year. What is the price of the computer this year if the price is decreased by 10%?

13 / 50

How many columns does the production matrix P have?

14 / 50

If A is a 2x2 matrix with a determinant of zero, its inverse is:

15 / 50

At break-even point, the net profit or loss is:

16 / 50

Two 2 x 2 matrices A and B are inverses if their product is:

17 / 50

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

18 / 50

What is the total production for medium-sized sweatshirts across both universities based on their orders?

19 / 50

The Break-Even Point is a point where:

20 / 50

What is the Break-Even Point in units if the Break-Even Point in units is 64, and Production Capacity is 200 units per period? What is the Break-Even point as a percentage of capacity?

21 / 50

The formula for the net price if the principal amount is Rs. 100 and discounts are 10%, 15%, and 18% respectively:

22 / 50

Which of the following is the correct formula to find the compound interest?

23 / 50

Which of the following percentages is the Conveyance Allowance of the basic salary?

24 / 50

The formula to calculate Markdown is:

25 / 50

Which is the correct syntax for the determinant of a matrix given by the following array?

26 / 50

What will be the answer of the SUMIF formula?

27 / 50

Given Net Price of a shirt = $20, Discount = 10%. The List Price will be?

28 / 50

In the case of partial payments, the _______ is the partial payment plus the partial cash discount.

29 / 50

What will be the base if the percentage is 25% and the value is 65?

30 / 50

Cost analysis provides the following information: Fixed Costs = Rs. 224, Variable Costs = Rs. 100 per unit, Selling Price = Rs. 150 per unit, Production Capacity = 320 units per period. Determine the BEP in units if Fixed Costs increase to Rs. 5438 and Variable Costs decrease by 10%.

31 / 50

45% of what is 9?

32 / 50

What is the transformation of 3/16 as a percent?

33 / 50

Every percentage can be converted into:

34 / 50

If A = [2, 6; 3, 4] and B = [1, 9; 3, 3], calculate AB.

35 / 50

The amount of discount is obtained as:

36 / 50

Monthly installments of a leased car are calculated by using the techniques of:

37 / 50

If 3(x+2) - 7 = 11, then the value of x is:

38 / 50

Dimension of a matrix means:

39 / 50

One piece of pipe 21 meters long is to be cut into two pieces with lengths in a 2:5 ratio. Calculate the lengths of the pieces.

40 / 50

Four friends take a test. Their scores are 96, 100, 106, and 114. Which of the following statements is true?

41 / 50

Solve the system of equations using the substitution method: -y = -z, y = 4

42 / 50

Convert 0.20% to decimal.

43 / 50

Store A marked down a $50 perfume to $40 with a markdown of $10. The percentage markdown is:

44 / 50

Evaluate (2)^(-2):

45 / 50

A set of equal payments made at equal intervals of time is called:

46 / 50

Which of the following functions is not related to financial analysis?

47 / 50

Calculate the break-even point in rupees given: Fixed Costs = Rs. 500, Contribution Margin = Rs. 250, Expected Sale Price = Rs. 1000 per unit.

48 / 50

What is the answer if we take the zero exponent of 27?

49 / 50

Choose the correct option that returns the present value of an investment that pays Rs. 230 at the end of every month for 2 years. The money paid out will earn 7.5% annually.

50 / 50

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

Your score is

0%

Mid Term

/90

Mid Term

1 / 90

The matrix G represents the average score for tests, quizzes, and homework. a. Write the vector P: P = [0.5 0.3 0.2]. b. Would GP or PG give the final grades?

2 / 90

The formula for compound interest for n periods is:

3 / 90

Find the cost price if an article is sold for Rs. 990, causing a 10% loss.

4 / 90

Present value of Rs. 250 paid monthly for 2 years at 7.5% annually:

5 / 90

If you invest some amount at an interest rate of 8%, what will be the Accumulation Factor at the end of 9 years?

6 / 90

Principal remains constant throughout the agreement period in:

7 / 90

The Basic Salary of an employee is Rs. 17,000. What is the contribution of the company on account of gratuity?

8 / 90

What will be the answer to the SUMIF formula.

9 / 90

Net Cost = 5500 - 850 = 4650 is the correct net cost of an item. What is the correct answer?

10 / 90

Reduction from original selling price is called:

11 / 90

Correct syntax for determinant of a matrix:

12 / 90

Find x if 2x + 6 = 10.

13 / 90

3x² + 5x - 7 is a:

14 / 90

Solve for x: -2x + 6 = 4x - 2

15 / 90

The monthly incomes of A and B are in the ratio 4:5, and their expenses are in the ratio 5:6. If A saves Rs. 25/month and B saves Rs. 50/month, what are their incomes?

16 / 90

What makes the dissolution of a partnership easier compared to a joint stock company?

17 / 90

A square matrix 𝐴 has an inverse if:

18 / 90

What will be the answer of the SUMIF formula?

19 / 90

The formula for finding BEP in units is given by:

20 / 90

In which Trust Fund, the company does not deduct but only contributes 1/11th of the basic salary of the employee per month.

21 / 90

In annuity, interest is charged by the:

22 / 90

The amount of discount is obtained as:

23 / 90

The negative of the negative of an odd number is:

24 / 90

If 𝐼 is an identity matrix, it must also be:

25 / 90

Write a formula to find the simple interest 𝐼 if $5000 is invested at 4% for 2 years.

26 / 90

The determinant of a square matrix is:

27 / 90

Ali improved his typing speed from 40 w/m to 60 w/m. The percentage improvement is:

28 / 90

If 𝐴 and 𝐵 are matrices of order 𝑚×𝑛 and 𝑝×𝑞 respectively, with 𝑚>𝑛 and 𝑝<𝑞, what is the condition for 𝐴𝐵 to exist?

29 / 90

If 𝐴 is a matrix whose determinant is zero, then its inverse is:

30 / 90

Interest paid (earned) on only the original principal borrowed (lent) is often referred to as:

31 / 90

Find x if 3(x + 2) - 7 = 11

32 / 90

Which of the following is the main reason why partnerships are simple to form?

33 / 90

In which trust fund does the company not deduct but contributes 1/11th of the basic salary?

34 / 90

This financial plan involves a _____ problem while working and a _____ problem in retirement:

35 / 90

Which of the following is a linear equation?

36 / 90

For a product with selling price = $45 and unit variable cost = $30, the unit contribution margin is:

37 / 90

Solve x − 16 = 12 for x:

38 / 90

Ali bought a motorcycle on installments: Rs. 2000 for 30 months. If the bike costs Rs. 54,000, what % more will he pay?

39 / 90

Simple interest earned on Rs. 16,800 in 9 months at 1/6.4% p.a is:

40 / 90

Simple interest earned on Rs. 16,800 in 9 months at 6.4% p.a.:

41 / 90

In 2 years, you are to receive $10,000. If the interest rate were to suddenly decrease, the present value of that future amount would:

42 / 90

To convert a number in percent (%) from a fraction, we do which of the following operations:

43 / 90

Function that calculates depreciation equally over time:

44 / 90

Sum of annuity is always:

45 / 90

Store A marked down $20.64 to $14.29. What is the dollar markdown? What is the percentage markdown?

46 / 90

Division symbol / is a type of:

47 / 90

A percentage is a way of expressing a number as:

48 / 90

The value of x for the equation -(-x - 5) = x - 2 is:

49 / 90

If C = Cost price, S = Selling price, then the margin on the cost is equal to:

50 / 90

Store A marked down a $50 perfume to $40 with a markdown of $10. The percentage markdown is:

51 / 90

A percentage is a way of expressing a number as:

52 / 90

Contribution Margin is the Rs. amount that is equal to:

53 / 90

Percentage of a ratio of a given number with a standard number is:

54 / 90

If 𝐴 = [[2, 6], [1, 9]] and 𝐵 = [[3, 4], [3, 3]], find 𝐴𝐵:

55 / 90

Given Old Sale Price = $1.95, Markdown Rate = 13.6%. Find the dollar markdown.

56 / 90

Sale price is the selling price less the:

57 / 90

Interest calculated upon the principal amount added to the interest on it is called:

58 / 90

In which Trust Fund does the company only contribute 11% of the basic salary?

59 / 90

Correct relation among % markup on cost, cost price, and selling price:

60 / 90

The sequence of payments at equal intervals of time is called:

61 / 90

Markdown means a reduction from the:

62 / 90

The text concatenation operator is used to:

63 / 90

The mean of the numbers 10, 7, 9, 2, and x is 11. Find the value of x:

64 / 90

What result will I get when I press Enter in cell D9?

65 / 90

0^1 = ?

66 / 90

Ali has improved his typing speed from 40 w/m to 60 w/m. The percentage improvement is:

67 / 90

0.20% = ?

68 / 90

12.5% of a circular plot as a fraction is:

69 / 90

If the speed of a car is changed from 25 km/h to 40 km/h, what is the percentage change in its speed?

70 / 90

The net price of a computer table is Rs. 2500, and the list price is Rs. 3000. The trade discount is:

71 / 90

According to local laws, allowances are considered tax-free if they are up to:

72 / 90

Net Cost Price is:

73 / 90

12.5% of a circular plot as a fraction is expressed as:

74 / 90

Markup is an amount added to:

75 / 90

If Cost = Rs. 7060 and Markup Rate = 46.7%, find the Selling Price.

76 / 90

The Virtual University had 7113 students last year, increasing to 9242 this year. What is the percentage increase?

77 / 90

By multiplying the following matrices:

78 / 90

The margin is the difference between the selling price and the:

79 / 90

Write which of the given functions is used for the below tasks: RATE: Finds the interest rate per period of an investment. PPMT: Calculates the principal portion of a payment during a specified period.

80 / 90

The Break-Even Point (BEP) in units is 64, and Production Capacity = 320 units per period. What is BEP as a % of capacity?

81 / 90

The Basic salary of an employee is Rs. 7,000. What is the contribution of the company on account of gratuity to the Gratuity Trust Fund?

82 / 90

Total Provident Fund added to the employee’s fund is:

83 / 90

Principal remains constant throughout the agreement period in:

84 / 90

All formulas in Excel start with:

85 / 90

If Cost = 7060 and Markup Rate = 46.7%, find the Selling Price.

86 / 90

The function that returns the cumulative interest paid on a loan between start and end periods is:

87 / 90

Given FC = 8000, VC = 200, S = 190, CM = 10, NI = 8000. Find the units over BEP.

88 / 90

Correct formula for contribution margin:

89 / 90

Which statement is true?

90 / 90

In Excel, how many types of operators exist?

Your score is

0%

/25

Mid Term 2

1 / 25

If Selling Price = Rs. 5890 and Markup Rate = 59.5%, find the Cost Price.:

2 / 25

Find ( x ) if ( 3x + 7 - x = 17 ):

3 / 25

Which function returns the depreciation for an asset purchased at Rs. 3000?:

4 / 25

Find the depreciation for an asset with Cost = 10,000, Salvage Value = 6,000, Life = 4, and Year = 1:

5 / 25

Sum of annuity is an accumulated amount of:

6 / 25

If Cost Price = 12 and Selling Price = 15, find the profit percentage:

7 / 25

If the basic salary is Rs. 6500 and the social charges are Rs. 1820, what percentage of the basic salary are the social charges?.

8 / 25

The text concatenation operator is used to:

9 / 25

The break-even point is when:

10 / 25

The margin is the difference between the selling price and the:

11 / 25

The price at which a business purchases merchandise is called the:

12 / 25

Sale price is the selling price less the:

13 / 25

Which is the correct formula for calculating the selling price?.:

14 / 25

A reduction of the amount due on an invoice is called a:

15 / 25

What is the expression 3x^2 + 5x - 7 called?

16 / 25

If ( Original Price = 3120 ) and ( Markdown Rate = 6.3% ), find the Sale Price.:

17 / 25

What will be the answer of the SUMIF formula?:

18 / 25

What percentage is 10% of 85?.:

19 / 25

If a matrix has four columns and five rows, its dimensions are:

20 / 25

Given FC = 5000, CM = 30, VC = 150, and Capacity = 320, find BEP in units.

21 / 25

Principal remains constant throughout the agreement period in:

22 / 25

Monthly installments of a leased car are calculated using the techniques of:

23 / 25

If you invest some amount at an interest rate of 8%, what will be the Accumulation Factor at the end of 9 years?:

24 / 25

If ( Cost = 7060 ) and ( Markup Rate = 46.7% ), find the Selling Price.:

25 / 25

0.20% is equivalent to:

Your score is

0%

/42

Mid Term 3

1 / 42

What is the net result of rounding 0.128 to 2 decimal places?

2 / 42

The straight line method in depreciation is calculated by the function _______.

3 / 42

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

4 / 42

MINVERSE is the _______ function of Microsoft Excel.

5 / 42

What is the net result of a series of cash flows that represent a loan?

6 / 42

What does EXCEL formula = 2^3 evaluate?

7 / 42

Relation between %markup on cost, cost price and selling price is ______.

8 / 42

What is the percentage markup on cost if the markup is Rs. 300 and cost is Rs. 1500?

9 / 42

It is asked to find 30% of 25. Which of the following is the correct list of given data:

10 / 42

If you buy 100 shares at Rs. 50 per share with a 1% commission, the total commission is:

11 / 42

The break-even point can be defined as:

12 / 42

4% of 400 is ________.

13 / 42

Round 3.1456 to three decimal places.

14 / 42

If a shopkeeper buys an item at Rs. 45 and sells it at Rs. 60, what is the %markup on sale?

15 / 42

If sales = Rs. 2300 and variable cost = Rs. 1500, then contribution margin = _____.

16 / 42

In EXCEL, formulas always:

17 / 42

In the word BALLOONS, the ratio of vowels to consonants is:

18 / 42

What is the formula for simple interest?

19 / 42

If A & B are two square matrices, under what condition are they inverses of each other?

20 / 42

In SLN, the cost is the initial cost of ________.

21 / 42

VDB stands for ____________.

22 / 42

For simple interest for 3 years at a rate of 5% on $2,000, what is the interest?

23 / 42

Which function returns the depreciation of an asset for any period, including partial periods?

24 / 42

What operation _______ returns the product of two numbers.

25 / 42

In EXCEL, the formula “=(1+A18/100)A17” means:

26 / 42

The correct formula for calculating the sale is:

27 / 42

What percentage of 85 is 5?

28 / 42

It is asked to find a number whose 7% is 54. What is required to calculate?

29 / 42

The price of a movie ticket increased from Rs. 100 to Rs. 175. What is the percentage increase?

30 / 42

House rent, conveyance allowance, utilities, gratuity, and provident fund are calculated with respect to:

31 / 42

If FC is Rs. 4500 and contribution margin is Rs. 50, then BEP in units is _____.

32 / 42

If discounts of 10%, 7%, and 5% are offered consecutively, it is:

33 / 42

If x=9 satisfies the equation 5x−2y=21, then the value of y is:

34 / 42

_________ returns the net present value of an investment based on a series of periodic cash flows and a discount rate.

35 / 42

In EXCEL worksheet, cell A2 has 4 and B2 has 8. Which formula is correct for finding the sum of 4 & 8?

36 / 42

If a matrix A is 3x3 and B is 3x2, the product AB exists because:

37 / 42

Markdown refers to a reduction in the ______.

38 / 42

Percentage markup on cost = (markup Rs / ________) x 100%

39 / 42

A square matrix has 1’s on the main diagonal and 0’s elsewhere, it is:

40 / 42

If x/y = u/v, then xv = ____.

41 / 42

What percent of 40 is 400?

42 / 42

If rate = 30 % and percentage = 26 , find the base.

Your score is

0%

/22

Mid Term 4

1 / 22

The formula for calculating trade discount amount is:

2 / 22

If the cost price = Rs 1000 and selling price = Rs 1500, then the markup is:

3 / 22

Which equation has x = 2, y = 3 as a solution?

4 / 22

If the cost of an article is 40 Rs and markup is 25%, then markup in Rs is:

5 / 22

For the XIRR function to work, the series of values must contain at least:

6 / 22

The formula for SYD is (cost - salvage) × (...)/life(life + 1):

7 / 22

A coat costing Rs 1700 needs a 60% markup on cost for desired profit. What is the selling price?

8 / 22

The correct relation among % markup, cost price, and selling price is:

9 / 22

Syntax for SYD (Sum of Years’ Digits Depreciation) is:

10 / 22

Which function returns the internal rate of return for a series of cash flows?

11 / 22

Selling price S = _______.

12 / 22

If x = 2y + 3 and y = 2x + 3, the solution is given by:

13 / 22

Markdown is defined as:

14 / 22

If the cost of a headset is 200 and its markup is Rs. 50, then what is its selling price?

15 / 22

If a shopkeeper buys one item at Rs 45 and sells it at Rs 60, what is his % markup on sale?:

16 / 22

A linear equation is an equation of the ______ degree in any number of variables.

17 / 22

What is the single discount rate equivalent to a series of discounts: 20%, 10%, and 5%?

18 / 22

A stereo that originally sells for $626.99 is reduced by 30%. Find the sale price.

19 / 22

The formula for evaluating net price when list price is P and a discount d% is applied:

20 / 22

An invoice dated June 1 with terms 3/10 offers a 3% discount if paid by June 10. What is the net payment for Rs 50,000 if paid on time?

21 / 22

Complete the syntax of: AMORDEGRC (..., date_purchased, first_period, salvage, period, rate, basis)

22 / 22

An item priced at Rs 5000 is marked down by 20%. What is the sale price?

Your score is

0%

/56

Mid Term 5

1 / 56

Which of the following is true for the calculation of the difference of two matrices?

2 / 56

In Excel function: ROUND(number, num_digits). What does num_digits stand for?

3 / 56

Which of the following is true for the calculation of the sum of two matrices?

4 / 56

Break-even point is a point where the ratio of inflow and outflow is:

5 / 56

For a product, if its list price is Rs. 500 at the discount rate of 25%, then its net cost price is:

6 / 56

Markdown means a reduction from the original ____.

7 / 56

At the break-even point:

8 / 56

Given Net price of a shirt = $20, Discount = 10%. What is the List Price?

9 / 56

A discount given for the prompt payment of the dues is called ____.

10 / 56

More than one discount may be allowed on an item. In such cases, the second discount is allowed _____.

11 / 56

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

12 / 56

What does the Excel formula = (25)(3) evaluate?

13 / 56

The salary of an employee is as follows: Basic Salary = Rs. 25,000; Allowances = Rs. 5,000. What is the taxable income of the employee?

14 / 56

Gratuity fund is included in the gross salary of an employee:

15 / 56

Which of the following is the forecasting technique?

16 / 56

What is the % markup on cost of an item that is equivalent to a 45% markup on the selling price?

17 / 56

For a project to be viable without profit or loss, the BC ratio must be ______ or more.

18 / 56

The series discounts are 10%, 5%, and 3%. What is the single equivalent discount rate?

19 / 56

27 is 3% of which number?

20 / 56

VDB stands for _______:

21 / 56

Discount = _____.

22 / 56

If an article of cost Rs. 50 is sold at a profit of Rs. 10, then the profit percent is:

23 / 56

%Markdown = ?

24 / 56

Equivalent discount rate to the series of discounts 10%, 20%, and 25% is ____.

25 / 56

An item costs $45 and is sold for $115. What is the margin?

26 / 56

The conversion of markup on sale price to markup on cost price is measured as:

27 / 56

The relation between new selling price, % markdown, and current selling price is:

28 / 56

The ratio between present worth of benefit and cost is called the:

29 / 56

If a discount of 2% is offered on an invoice with value Rs. 50,000 paid up to May 10th, what is the net payment of the invoice?

30 / 56

When solving the problem of selling price, the formula entered in Excel as “=(1+A18/100)*A17” implies:

31 / 56

Which of the following function returns the depreciation of an asset for a specified period?

32 / 56

If P is the principal value, I is simple interest, T is the number of years, then what is the rate of interest, R?

33 / 56

If the cost price is Rs. 2000 and selling price is Rs. 3600, then the percentage markup on cost can be found using:

34 / 56

A company has a positive cash flow when:

35 / 56

Gratuity fund is included in the gross salary of an employee:

36 / 56

Fawad’s Appliances bought a sewing machine for Rs. 1500. To make a desired profit, he needs a 60% markup on cost. What is his selling price?

37 / 56

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

38 / 56

A product costing Rs. 500 is sold at 30% profit. Find its selling price.

39 / 56

The Excel formula = (25)(3) evaluate:

40 / 56

VDB returns the depreciation of an asset for:

41 / 56

An item costs Rs. 45 and is sold for Rs. 115. What is the margin?

42 / 56

Find the net price of an item if the list price is Rs. 2000 and there was a discount of 20%.

43 / 56

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

44 / 56

The terms 2/10 mean that 2% discount is offered if invoice is paid up to ______ days.

45 / 56

If a shopkeeper buys one item at Rs. 45 and sells it at Rs. 60, then what is his % markup on sale?

46 / 56

What is an annuity?

47 / 56

A fruit punch recipe requires mango juice, apple juice, and orange juice in the ratio of 3:2:1. To make 2 liters of punch, the quantity of apple juice will be:

48 / 56

If discounts of 10%, 7%, and 5% are offered every consecutive year on an item, it is an example of ______.

49 / 56

Which of the following is the best answer in support of the periods for the buyer to take advantage of discount terms?

50 / 56

A woman’s handbag has a list price of Rs. 30. For a sale, 40% discount is offered followed by a 10% discount. What is the amount of money that has been saved?

51 / 56

Complete the syntax of AMORLINC (……., date_purchased, first_period, salvage, period, rate, basis):

52 / 56

Markup can be expressed as a:

53 / 56

Dividends, payments on installment purchases, rent payments, interest payments on bonds, mortgage payments, and insurance premiums are examples of:

54 / 56

Which is the correct syntax for the determinant of a matrix in Excel?

55 / 56

Internal Rate of Return (IRR) is the discount rate at which the present worth of costs is equal to ____.

56 / 56

Dividends, payments on installment purchases, rent payments, interest payments on bonds, mortgage payments, and insurance premiums are examples of:

Your score is

0%

/75

Mid Term 6

1 / 75

Find the net price of an item if the list price is Rs. 1000 and there is a discount of 10%.

2 / 75

Which of the following ratios is named Price-Earnings ratio?

3 / 75

If a discount of 2% is offered on an invoice with a value of Rs. 50,000 paid up to 10th May, what is the net payment?

4 / 75

The first step in calculating NPV is to find out the --------.

5 / 75

Aslam works in a supermarket for $10.00 per hour. If his pay increases to $12.00, what is the percentage increase in pay?

6 / 75

15% of the price of a shirt is increased. If the change in the price of the shirt is Rs 25, what is the original price?

7 / 75

% Markdown = ?

8 / 75

Interest paid (earned) on only the original principal borrowed (lent) is referred to as:

9 / 75

If a matrix A has a determinant of zero, its inverse is:

10 / 75

Depreciation example: Asset cost = Rs.10,000, Salvage value = $8,000, Life = 5 years, Calculated for 3rd year, 10 months in 1st year. Correct formula is:

11 / 75

Which function helps to calculate the number of periods required to pay off a loan or reach an investment goal through regular periodic payments at a fixed interest rate?

12 / 75

Which of the following best describes a matrix?

13 / 75

The formula for compound interest for n number of periods is:

14 / 75

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

15 / 75

Dividends, payments on installment purchases, rent payments, interest payments on bonds, mortgage payments, and insurance premiums are examples of:

16 / 75

The ratio between the present worth of benefits and costs is called the ----------.

17 / 75

CUMIPMT calculates the cumulative interest paid on a loan. It is calculated for:

18 / 75

In a friendly cricket match, Pakistan is scoring 7% more than India. If India’s score is 230 after 35 overs, what’s Pakistan’s score?

19 / 75

The Excel formula = (25)(3) evaluate:

20 / 75

Monthly installments of a leased car are calculated by using the techniques of:

21 / 75

The formula for finding BEP (Break-Even Point) in units is given by:

22 / 75

What will be the simple interest earned on Rs. 16,800 in 9 months at a rate of 1 6/4 % per annum?

23 / 75

The rate at which the calculations are made while converting the future value into the present one is called the?

24 / 75

The term 2/10 means a 2% discount is offered if an invoice is paid within ------ days.

25 / 75

Find the single discount rate equivalent to a series of discounts: 18%, 12%, and 9%.

26 / 75

The correct relation between %markup on sale, cost price, and selling price is:

27 / 75

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

28 / 75

By multiplying two given matrices, the result is a ______ matrix.

29 / 75

Given: List Price = Rs. 5500, Discount = Rs. 850. What is the Net Cost Price?

30 / 75

Compute the compound interest for Rs. 3500 at 6% per annum for 2 years.

31 / 75

If A and B are matrices of dimensions 2 x 3 and 3 x 2, respectively, which operation is possible?

32 / 75

The value of x in the proportion 2x/5 = (x+1)/10:

33 / 75

Total marks of Saleem in two subjects are 160. If the ratio of marks in the two subjects is 3:5. What will be the marks in two subjects?

34 / 75

(2)^-2 =

35 / 75

What makes the dissolution of a partnership easier compared to a joint stock company?

36 / 75

If there is a -30% change in the price of an item, what does the negative sign indicate?

37 / 75

What is the interest on Rs. 1600 for one year at the rate 3/2%?

38 / 75

According to taxation rules, the amount of allowances is treated tax-free if it is up to:

39 / 75

12/45 is proportional to:

40 / 75

Amount of discount is obtained as:

41 / 75

After the merchant buys merchandise, it is sold at a higher price called the ________.

42 / 75

Every percentage can be converted into:

43 / 75

Which of the following is a polynomial expression of degree 2?

44 / 75

A restaurant paid Rs. 112 for a piece of equipment after receiving a discount of 20%. What was the original price?

45 / 75

If some percentage is given as markup without mentioning whether it is markup on cost or sale, it is evident that % markup on --------- is under consideration.

46 / 75

If 45% of a number is 9, what is the number?

47 / 75

Gratuity fund is included in the gross salary of an employee:

48 / 75

If a discount of 10 percent, 7 percent, and 5 percent are offered consecutively, it is an example of -----------.

49 / 75

Which of the following is the main reason why partnerships are simple to form?

50 / 75

Dividend is -----------.

51 / 75

Dimension of a matrix means:

52 / 75

What is the contribution of a company to the Gratuity Trust Fund for a basic salary of Rs. 7000?

53 / 75

If Cost price = Rs. 2000 and Selling price = Rs. 6500, what will be the % Markup on cost?

54 / 75

What is 0.20% as a decimal?

55 / 75

In which Trust Fund does the company only contribute 1/11th of the employee’s basic salary per month?

56 / 75

If ‘I’ is an identity matrix of order 2x2 and A is any matrix of order 2x2, then which of the following is equal to AI and IA:

57 / 75

The present value of an investment paying Rs. 250 monthly for 2 years, earning 7.5% annually, is:

58 / 75

If A and B are two square matrices, under what condition are they the inverse of each other?

59 / 75

Which of the following is a linear equation?

60 / 75

All formulas in Excel start with:

61 / 75

Ali got 20% of his salary as an increment and 50% as a bonus. If his salary was Rs. 8000, how much salary did he get in July?

62 / 75

If the cost of goods is Rs. 2400 and its selling price is Rs. 4500, the markup rate is:

63 / 75

If the cost of an article is Rs. 40 and the markup is 25%, then the markup in Rs. is ---------.

64 / 75

If a shopkeeper buys one item at Rs. 45 and sells it at Rs. 60, then what is his % markup on sale?

65 / 75

In the case of partial payments, the ______ is the partial payment plus the partial cash discount.

66 / 75

What result will you get when pressing ENTER in cell D9 if the formula =sum(B3, B4, B5, B6) is applied?

67 / 75

Which of the following functions is not related to financial analysis?

68 / 75

Percentage is a ratio of a given number to a standard number. The standard number is:

69 / 75

Suppose that you are spending $1500 in an investment and the accumulated factor is 15. What is the accumulated value?

70 / 75

The simple form of the ratio 5/6 = 7/10 is ---------.

71 / 75

To convert a number in percent (%) from a fraction, which operation is correct?

72 / 75

What will be the List Price if the Net Price is Rs. 20 and Discount = 10%?

73 / 75

When calculating the future value of an annuity, the difference in results is due to:

74 / 75

If Cost Price = Rs. 2000 and Selling Price = Rs. 6500, what is the markup?

75 / 75

The ratio of the weight of Tina’s book to Jean’s book is 5:6. Tina’s book weighs 30 ounces. How much less does it weigh than Jean’s book?

Your score is

0%