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

Which operator is used for exponentiation in Excel?

2 / 25

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

3 / 25

Which Excel function can also be used for exponentiation?

4 / 25

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

5 / 25

How is 20% represented as a fraction in Excel?

6 / 25

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

7 / 25

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

8 / 25

How do you correct a mistake in an Excel cell?

9 / 25

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

10 / 25

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

11 / 25

Which operator is used for subtraction in Excel?

12 / 25

What does the range A1:D5 include?

13 / 25

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

14 / 25

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

15 / 25

What is the multiplication operator in Excel?

16 / 25

What is the first step to open Microsoft Excel?

17 / 25

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

18 / 25

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

19 / 25

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

20 / 25

In Excel, which operator is used for multiplication?

21 / 25

What does the range A1:D5 include in Excel?

22 / 25

Which formula multiplies values in cells A60 and B60?

23 / 25

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

24 / 25

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

25 / 25

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

Your score is

0%

/29

Lesson 3

1 / 29

What is the duration of each lecture in this course?

2 / 29

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

3 / 29

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

4 / 29

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

5 / 29

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

6 / 29

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

7 / 29

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

8 / 29

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

9 / 29

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

10 / 29

Convert 20% into a decimal.

11 / 29

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

12 / 29

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

13 / 29

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

14 / 29

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

15 / 29

What is the formula to convert percentage into a fraction?

16 / 29

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

17 / 29

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

18 / 29

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

19 / 29

Convert 0.1 into a percentage.

20 / 29

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

21 / 29

Which of the following best describes a common fraction?

22 / 29

Which of the following is NOT included in gross remuneration?

23 / 29

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

24 / 29

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

25 / 29

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

26 / 29

What percentage is 6% of 40?

27 / 29

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

28 / 29

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

29 / 29

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

Your score is

0%

/30

Lesson 4

1 / 30

What does the ROUND function in Excel do?

2 / 30

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

3 / 30

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

4 / 30

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

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 Excel syntax for the AVERAGE function?

7 / 30

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

8 / 30

What Excel function calculates the average of numbers?

9 / 30

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

10 / 30

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

11 / 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?

12 / 30

What is the syntax of the DSUM function in Excel?

13 / 30

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

14 / 30

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

15 / 30

What is the formula for the weighted average?

16 / 30

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

17 / 30

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

18 / 30

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

19 / 30

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

20 / 30

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

21 / 30

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

22 / 30

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

23 / 30

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

24 / 30

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

25 / 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?

26 / 30

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

27 / 30

What does the $ sign in an Excel formula indicate?

28 / 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?

29 / 30

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

30 / 30

Which function is used to round off values in Excel?

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

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

3 / 17

What does the face value of a stock represent?

4 / 17

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

5 / 17

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

6 / 17

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

7 / 17

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

8 / 17

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

9 / 17

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

10 / 17

How is dividend per share calculated?

11 / 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?

12 / 17

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

13 / 17

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

14 / 17

What is the market value of a stock?

15 / 17

What is the compound interest formula?

16 / 17

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

17 / 17

What is the formula for simple interest?

Your score is

0%

/45

Lesson 6

1 / 45

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

2 / 45

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

3 / 45

What does the face value of a stock represent?

4 / 45

What is the compound interest formula?

5 / 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?

6 / 45

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

7 / 45

How is dividend per share calculated?

8 / 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?

9 / 45

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

10 / 45

How is dividend per share calculated?

11 / 45

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

12 / 45

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

13 / 45

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

14 / 45

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

15 / 45

What is the market value of a stock?

16 / 45

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

17 / 45

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

18 / 45

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

19 / 45

What does the face value of a stock represent?

20 / 45

What is the compound interest formula?

21 / 45

What is the formula for simple interest?

22 / 45

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

23 / 45

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

24 / 45

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

25 / 45

How is dividend per share calculated?

26 / 45

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

27 / 45

What is the market value of a stock?

28 / 45

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

29 / 45

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

30 / 45

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

31 / 45

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

32 / 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?

33 / 45

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

34 / 45

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

35 / 45

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

36 / 45

What is the formula for simple interest?

37 / 45

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

38 / 45

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

39 / 45

What is the market value of a stock?

40 / 45

What is the compound interest formula?

41 / 45

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

42 / 45

What does the face value of a stock represent?

43 / 45

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

44 / 45

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

45 / 45

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

Your score is

0%

/20

Lesson 7

1 / 20

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

2 / 20

What is an annuity?

3 / 20

How is division by a monomial performed?

4 / 20

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

5 / 20

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

6 / 20

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

7 / 20

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

8 / 20

What does x = 341.25 + 0.025x simplify to?

9 / 20

Which of the following best describes a common fraction?

10 / 20

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

11 / 20

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

12 / 20

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

13 / 20

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

14 / 20

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

15 / 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?

16 / 20

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

17 / 20

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

18 / 20

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

19 / 20

What is the accumulation factor formula?

20 / 20

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

Your score is

0%

/25

Lesson 9

1 / 25

A matrix with dimensions n × 1 is a:

2 / 25

In an identity matrix, the main diagonal elements are:

3 / 25

A matrix with dimensions 1 × n is called a:

4 / 25

A 2 × 3 matrix has:

5 / 25

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

6 / 25

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

7 / 25

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

8 / 25

The plural of matrix is:

9 / 25

What is a matrix?

10 / 25

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

11 / 25

What does the order of a matrix represent?

12 / 25

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

13 / 25

Which matrix is its own inverse?

14 / 25

What is a square matrix?

15 / 25

An identity matrix is denoted as:

16 / 25

A matrix with all zero elements is called a:

17 / 25

A real-life example of a matrix is:

18 / 25

Which letter is commonly used to denote a matrix?

19 / 25

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

20 / 25

Which matrix concept is useful in network analysis?

21 / 25

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

22 / 25

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

23 / 25

Which of the following is a valid matrix multiplication rule?

24 / 25

Matrices are widely used in:

25 / 25

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

Your score is

0%

/19

Lesson 10

1 / 19

Matrices can represent data for:

2 / 19

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

3 / 19

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

4 / 19

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

5 / 19

Matrix multiplication is defined when the:

6 / 19

The additive identity for matrices is a matrix filled with:

7 / 19

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

8 / 19

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

9 / 19

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

10 / 19

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

11 / 19

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

12 / 19

How many columns does the production matrix P have?

13 / 19

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

14 / 19

Overproduction in inventory management can be calculated using:

15 / 19

In scalar multiplication of matrices, each element is:

16 / 19

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

17 / 19

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

18 / 19

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

19 / 19

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

Your score is

0%

Quizes

/50

Quizs

1 / 50

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

2 / 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%.

3 / 50

Convert 0.20% to decimal.

4 / 50

Evaluate (2)^(-2):

5 / 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?

6 / 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:

7 / 50

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

8 / 50

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

9 / 50

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

10 / 50

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

11 / 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.

12 / 50

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

13 / 50

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

14 / 50

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

15 / 50

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

16 / 50

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

17 / 50

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

18 / 50

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

19 / 50

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

20 / 50

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

21 / 50

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

22 / 50

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

23 / 50

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

24 / 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%?

25 / 50

The amount of discount is obtained as:

26 / 50

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

27 / 50

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

28 / 50

The Break-Even Point is a point where:

29 / 50

Every percentage can be converted into:

30 / 50

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

31 / 50

45% of what is 9?

32 / 50

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

33 / 50

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

34 / 50

Dimension of a matrix means:

35 / 50

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

36 / 50

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

37 / 50

The formula to calculate Markdown is:

38 / 50

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

39 / 50

VDB returns the depreciation of an asset for?

40 / 50

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

41 / 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.

42 / 50

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

43 / 50

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

44 / 50

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

45 / 50

How many columns does the production matrix P have?

46 / 50

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

47 / 50

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

48 / 50

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

49 / 50

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

50 / 50

What will be the answer of the SUMIF formula?

Your score is

0%

Mid Term

/90

Mid Term

1 / 90

The amount of discount is obtained as:

2 / 90

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

3 / 90

Correct formula for contribution margin:

4 / 90

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

5 / 90

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

6 / 90

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

7 / 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?

8 / 90

In Excel, how many types of operators exist?

9 / 90

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

10 / 90

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

11 / 90

0^1 = ?

12 / 90

Sale price is the selling price less the:

13 / 90

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

14 / 90

12.5% of a circular plot as a fraction is:

15 / 90

The formula for compound interest for n periods is:

16 / 90

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

17 / 90

Function that calculates depreciation equally over time:

18 / 90

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

19 / 90

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

20 / 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?

21 / 90

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

22 / 90

Correct syntax for determinant of a matrix:

23 / 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?

24 / 90

Division symbol / is a type of:

25 / 90

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

26 / 90

A percentage is a way of expressing a number as:

27 / 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?

28 / 90

Which statement is true?

29 / 90

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

30 / 90

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

31 / 90

The formula for finding BEP in units is given by:

32 / 90

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

33 / 90

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

34 / 90

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

35 / 90

The determinant of a square matrix is:

36 / 90

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

37 / 90

All formulas in Excel start with:

38 / 90

0.20% = ?

39 / 90

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

40 / 90

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

41 / 90

Markup is an amount added to:

42 / 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.

43 / 90

A square matrix 𝐴 has an inverse if:

44 / 90

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

45 / 90

Principal remains constant throughout the agreement period in:

46 / 90

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

47 / 90

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

48 / 90

What will be the answer of the SUMIF formula?

49 / 90

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

50 / 90

A percentage is a way of expressing a number as:

51 / 90

The negative of the negative of an odd number is:

52 / 90

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

53 / 90

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

54 / 90

Sum of annuity is always:

55 / 90

Which of the following is a linear equation?

56 / 90

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

57 / 90

Find x if 2x + 6 = 10.

58 / 90

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

59 / 90

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

60 / 90

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

61 / 90

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

62 / 90

By multiplying the following matrices:

63 / 90

What will be the answer to the SUMIF formula.

64 / 90

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

65 / 90

In annuity, interest is charged by the:

66 / 90

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

67 / 90

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

68 / 90

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

69 / 90

The text concatenation operator is used to:

70 / 90

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

71 / 90

Reduction from original selling price is called:

72 / 90

Solve x − 16 = 12 for x:

73 / 90

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

74 / 90

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

75 / 90

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

76 / 90

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

77 / 90

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

78 / 90

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

79 / 90

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

80 / 90

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

81 / 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:

82 / 90

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

83 / 90

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

84 / 90

Net Cost Price is:

85 / 90

Markdown means a reduction from the:

86 / 90

3x² + 5x - 7 is a:

87 / 90

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

88 / 90

Principal remains constant throughout the agreement period in:

89 / 90

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

90 / 90

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

Your score is

0%

/25

Mid Term 2

1 / 25

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

2 / 25

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

3 / 25

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

4 / 25

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

5 / 25

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

6 / 25

The break-even point is when:

7 / 25

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

8 / 25

What will be the answer of the SUMIF formula?:

9 / 25

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

10 / 25

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

11 / 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?.

12 / 25

Sale price is the selling price less the:

13 / 25

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

14 / 25

The text concatenation operator is used to:

15 / 25

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

16 / 25

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

17 / 25

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

18 / 25

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

19 / 25

What percentage is 10% of 85?.:

20 / 25

0.20% is equivalent to:

21 / 25

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

22 / 25

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

23 / 25

Sum of annuity is an accumulated amount of:

24 / 25

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

25 / 25

Principal remains constant throughout the agreement period in:

Your score is

0%

/42

Mid Term 3

1 / 42

MINVERSE is the _______ function of Microsoft Excel.

2 / 42

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

3 / 42

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

4 / 42

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

5 / 42

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

6 / 42

What percent of 40 is 400?

7 / 42

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

8 / 42

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

9 / 42

The break-even point can be defined as:

10 / 42

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

11 / 42

What percentage of 85 is 5?

12 / 42

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

13 / 42

4% of 400 is ________.

14 / 42

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

15 / 42

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

16 / 42

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

17 / 42

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

18 / 42

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

19 / 42

Markdown refers to a reduction in the ______.

20 / 42

What does EXCEL formula = 2^3 evaluate?

21 / 42

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

22 / 42

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

23 / 42

VDB stands for ____________.

24 / 42

The correct formula for calculating the sale is:

25 / 42

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

26 / 42

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

27 / 42

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

28 / 42

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

29 / 42

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

30 / 42

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

31 / 42

What operation _______ returns the product of two numbers.

32 / 42

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

33 / 42

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

34 / 42

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

35 / 42

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

36 / 42

What is the formula for simple interest?

37 / 42

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

38 / 42

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

39 / 42

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

40 / 42

In EXCEL, formulas always:

41 / 42

Round 3.1456 to three decimal places.

42 / 42

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

Your score is

0%

/22

Mid Term 4

1 / 22

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

2 / 22

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

3 / 22

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

4 / 22

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

5 / 22

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

6 / 22

Markdown is defined as:

7 / 22

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

8 / 22

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

9 / 22

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

10 / 22

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

11 / 22

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

12 / 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?

13 / 22

The formula for calculating trade discount amount is:

14 / 22

Selling price S = _______.

15 / 22

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

16 / 22

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

17 / 22

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

18 / 22

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

19 / 22

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

20 / 22

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

21 / 22

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

22 / 22

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

Your score is

0%

/56

Mid Term 5

1 / 56

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

2 / 56

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

3 / 56

Markup can be expressed as a:

4 / 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:

5 / 56

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

6 / 56

A company has a positive cash flow when:

7 / 56

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

8 / 56

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

9 / 56

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

10 / 56

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

11 / 56

What is an annuity?

12 / 56

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

13 / 56

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

14 / 56

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

15 / 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?

16 / 56

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

17 / 56

27 is 3% of which number?

18 / 56

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

19 / 56

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

20 / 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?

21 / 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?

22 / 56

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

23 / 56

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

24 / 56

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

25 / 56

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

26 / 56

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

27 / 56

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

28 / 56

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

29 / 56

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

30 / 56

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

31 / 56

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

32 / 56

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

33 / 56

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

34 / 56

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

35 / 56

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

36 / 56

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

37 / 56

Which of the following is the forecasting technique?

38 / 56

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

39 / 56

%Markdown = ?

40 / 56

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

41 / 56

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

42 / 56

At the break-even point:

43 / 56

VDB returns the depreciation of an asset for:

44 / 56

Discount = _____.

45 / 56

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

46 / 56

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

47 / 56

Markdown means a reduction from the original ____.

48 / 56

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

49 / 56

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

50 / 56

VDB stands for _______:

51 / 56

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

52 / 56

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

53 / 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?

54 / 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?

55 / 56

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

56 / 56

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

Your score is

0%

/75

Mid Term 6

1 / 75

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

2 / 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:

3 / 75

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

4 / 75

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

5 / 75

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

6 / 75

Dimension of a matrix means:

7 / 75

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

8 / 75

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

9 / 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?

10 / 75

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

11 / 75

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

12 / 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?

13 / 75

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

14 / 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.

15 / 75

12/45 is proportional to:

16 / 75

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

17 / 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?

18 / 75

All formulas in Excel start with:

19 / 75

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

20 / 75

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

21 / 75

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

22 / 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?

23 / 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?

24 / 75

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

25 / 75

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

26 / 75

(2)^-2 =

27 / 75

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

28 / 75

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

29 / 75

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

30 / 75

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

31 / 75

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

32 / 75

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

33 / 75

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

34 / 75

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

35 / 75

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

36 / 75

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

37 / 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:

38 / 75

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

39 / 75

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

40 / 75

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

41 / 75

Every percentage can be converted into:

42 / 75

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

43 / 75

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

44 / 75

Amount of discount is obtained as:

45 / 75

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

46 / 75

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

47 / 75

What is 0.20% as a decimal?

48 / 75

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

49 / 75

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

50 / 75

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

51 / 75

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

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 is the markup?

54 / 75

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

55 / 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?

56 / 75

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

57 / 75

Which of the following best describes a matrix?

58 / 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?

59 / 75

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

60 / 75

% Markdown = ?

61 / 75

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

62 / 75

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

63 / 75

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

64 / 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?

65 / 75

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

66 / 75

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

67 / 75

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

68 / 75

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

69 / 75

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

70 / 75

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

71 / 75

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

72 / 75

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

73 / 75

Which of the following is a linear equation?

74 / 75

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

75 / 75

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

Your score is

0%