Basic Formulas and Functions- Excel MCQs

By: Prof. Dr. Fazal Rehman | Last updated: July 30, 2024

1. Which formula is used to calculate the sum of cells A1 through A10?
  • A) =SUM(A1:A10)
  • B) =TOTAL(A1:A10)
  • C) =ADD(A1:A10)
  • D) =SUM(A1,A2,A3,A4,A5,A6,A7,A8,A9,A10)
Answer: A) =SUM(A1:A10) 2. What does the formula =AVERAGE(B1:B5) compute?
  • A) The sum of values in cells B1 to B5
  • B) The average of values in cells B1 to B5
  • C) The maximum value in cells B1 to B5
  • D) The number of values in cells B1 to B5
Answer: B) The average of values in cells B1 to B5 3. How can you find the smallest value in a range of cells from C1 to C20?
  • A) =MIN(C1:C20)
  • B) =SMALLEST(C1:C20)
  • C) =LOWEST(C1:C20)
  • D) =MINIMUM(C1:C20)
Answer: A) =MIN(C1:C20) 4. To count the number of cells containing numbers in the range D1 to D10, which function is used?
  • A) =COUNT(D1:D10)
  • B) =COUNTA(D1:D10)
  • C) =COUNTIF(D1:D10, “>0”)
  • D) =SUM(D1:D10)
Answer: A) =COUNT(D1:D10) 5. What does the formula =IF(E1>50, "Pass", "Fail") do?
  • A) Checks if E1 is greater than 50 and returns “Pass” if true, otherwise “Fail”
  • B) Adds 50 to the value in E1 and returns “Pass”
  • C) Subtracts 50 from E1 and returns “Fail” if the result is less than zero
  • D) Multiplies E1 by 50 and returns “Pass” if the result is greater than 50
Answer: A) Checks if E1 is greater than 50 and returns “Pass” if true, otherwise “Fail” 6. How do you find the number of characters in cell F1?
  • A) =LENGTH(F1)
  • B) =CHARCOUNT(F1)
  • C) =LEN(F1)
  • D) =COUNTCHARS(F1)
Answer: C) =LEN(F1) 7. Which function would you use to concatenate the values in cells G1 and G2?
  • A) =JOIN(G1, G2)
  • B) =COMBINE(G1, G2)
  • C) =CONCATENATE(G1, G2)
  • D) =MERGE(G1, G2)
Answer: C) =CONCATENATE(G1, G2) 8. To compute the compound interest using the future value function, you use:
  • A) =FV(rate, nper, pmt, [pv], [type])
  • B) =PV(rate, nper, pmt, [fv], [type])
  • C) =IRR(rate, nper, pmt, [pv], [type])
  • D) =NPV(rate, nper, pmt, [pv], [type])
Answer: A) =FV(rate, nper, pmt, [pv], [type]) 9. What is the function to calculate the total value of cells H1 to H10 excluding errors?
  • A) =SUMIF(H1:H10, "<>#N/A")
  • B) =SUM(H1:H10)
  • C) =AGGREGATE(9, 6, H1:H10)
  • D) =SUMIF(H1:H10, "<>")
Answer: C) =AGGREGATE(9, 6, H1:H10) 10. How do you apply a formula to multiple cells at once?
  • A) Use the Fill Handle to drag the formula to other cells
  • B) Copy the formula and paste it into other cells
  • C) Manually enter the formula in each cell
  • D) Use the AutoSum feature
Answer: A) Use the Fill Handle to drag the formula to other cells
All Copyrights Reserved 2025 Reserved by T4Tutorials