Question : What is the formula for adding the value of cell A1, A2 and A3 ?
Option 1: SUM=(A1+A2+A3)
Option 2: SUM (A1,A2,A3)
Option 3: =SUM (A1:A3)
Option 4: None of above
Correct Answer: =SUM (A1:A3)
Solution : Following are the formula for adding the value of cell A1, A2 and A3 -
=SUM (A1:A3)
Hence the Correct answer is option 3.
Question : If A1 and A2 are two distinct prime numbers, then what is the highest common factor of A1 and A2?
Option 1: 3
Option 2: 1
Option 3: 5
Option 4: 2
Question : The value of MPC varies between __ and ___.
Option 1: 1 and 2
Option 2: 0 and 1
Option 3: -1 and 1
Option 4: None of the above.
Question : What is cell referencing in a spreadsheet?
Option 1: cell coordinates in the formula
Option 2: row coordinates in the address bar
Option 3: cell coordinate in the sheet
Option 4: All of the above
Question : The line chart given below shows the cost price and value of profit of 6 articles L, M, N, O, P, and Q. Selling price = Cost price + Profit A1 = The value of the average selling price of all articles. A2 = The value of the average cost price of L, M, N, and O. What is the value of (A1 + A2)?
Option 1: 1875
Option 2: 1425
Option 3: 1675
Option 4: 1025
Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile