Ms Excel Formulas MCQs Questions And Answers ll Part 1

 

1. What is the result of the formula =IF(H3>35,"pass","fail") if H3 contains the value 40?

A) "fail"

B) "pass"

C) #ERROR

D) #N/A

Answer: B) "pass"

2. Which formula will return "pass" if the value in H3 is 30?

A) =IF(H3>35,"pass","fail")

B) =IF(H3<35,"fail","pass")

C) =IF(H3>=35,"pass","fail")

D) =IF(H3<=35,"pass","fail")

Answer: D) =IF(H3<=35,"pass","fail")

3. What is the result of the formula =IF(H3<35,"fail","pass") if H3 contains the value 20?

A) "pass"

B) "fail"

C) #ERROR

D) #N/A

Answer: B) "fail"

4. Which formula will return "fail" if the value in H3 is 40?

A) =IF(H3>35,"pass","fail")

B) =IF(H3<35,"fail","pass")

C) =IF(H3>=35,"pass","fail")

D) =IF(H3<=35,"fail","pass")

Answer: B) =IF(H3<35,"fail","pass")

5. What is the result of the formula =IF(H3>=35,"pass","fail") if H3 contains the value 35?

A) "fail"

B) "pass"

C) #ERROR

D) #N/A

Answer: B) "pass"

6. Which formula will return "pass" if the value in H3 is 35?

A) =IF(H3>35,"pass","fail")

B) =IF(H3<35,"fail","pass")

C) =IF(H3>=35,"pass","fail")

D) =IF(H3<=35,"pass","fail")

Answer: C) =IF(H3>=35,"pass","fail")

7. What is the result of the formula =IF(H3<=35,"fail","pass") if H3 contains the value 30?

A) "pass"

B) "fail"

C) #ERROR

D) #N/A

Answer: B) "fail"

 8. Which formula will return "fail" if the value in H3 is 20?

A) =IF(H3>35,"pass","fail")

B) =IF(H3<35,"fail","pass")

C) =IF(H3>=35,"pass","fail")

D) =IF(H3<=35,"fail","pass")

Answer: B) =IF(H3<35,"fail","pass")

9. What is the result of the formula =IF(H3>35,"pass","fail") if H3 contains the value 25?

A) "pass"

B) "fail"

C) #ERROR

D) #N/A

Answer: B) "fail"

 10. Which formula will return "pass" if the value in H3 is 40?

A) =IF(H3>35,"pass","fail")

B) =IF(H3<35,"fail","pass")

C) =IF(H3>=35,"pass","fail")

D) =IF(H3<=35,"pass","fail")

Answer: A) =IF(H3>35,"pass","fail")

11. What is the result of the formula =LEN("Hello World")?

A) 10

B) 11

C) 12

D) 13

Answer: B) 11

12. What is the result of the formula =PROPER("hello world")?

A) "hello world"

B) "Hello World"

C) "HELLO WORLD"

D) "HeLlO WoRlD"

Answer: B) "Hello World"

13. What is the result of the formula =SMALL({1, 2, 3, 4, 5}, 2)?

A) 1

B) 2

C) 3

D) 4

Answer: B) 2

14. What is the result of the formula =LARGE({1, 2, 3, 4, 5}, 2)?

A) 1

B) 2

C) 4

D) 5

Answer: C) 4

15. What is the result of the formula =COUNT({1, 2, 3, 4, 5})?

A) 4

B) 5

C) 6

D) 7

Answer: B) 5

16. What is the result of the formula =COUNTA({"apple", "banana", "cherry"})?

A) 2

B) 3

C) 4

D) 5

Answer: B) 3

17. What is the result of the formula =COUNTBLANK({"apple", "", "cherry"})?

A) 0

B) 1

C) 2

D) 3

Answer: B) 1

18. What is the result of the formula =UPPER("hello world")?

A) "hello world"

B) "Hello World"

C) "HELLO WORLD"

D) "HeLlO WoRlD"

Answer: C) "HELLO WORLD"

19. What is the result of the formula =LOWER("HELLO WORLD")?

A) "hello world"

B) "Hello World"

C) "HELLO WORLD"

D) "HeLlO WoRlD"

Answer: A) "hello world"

20. What is the result of the formula =MAX({1, 2, 3, 4, 5})?

A) 1

B) 2

C) 3

D) 5

Answer: D) 5

Click here for more

The Microsoft Excel MCQs Marathon: How Far Can You G?

Advanced Excel MCQs Questions and Answers Pdf 

21. What is the result of the formula =MIN({1, 2, 3, 4, 5})?

A) 1

B) 2

C) 3

D) 5

Answer: A) 1

22. What is the result of the formula =LEN("")?

A) 0

B) 1

C) 2

D) 3

Answer: A) 0

23. What is the result of the formula =PROPER("HELLO WORLD")?

A) "hello world"

B) "Hello World"

C) "HELLO WORLD"

D) "HeLlO WoRlD"

Answer: B) "Hello World"

24. What is the result of the formula =SMALL({1, 2, 3, 4, 5}, 1)?

A) 1

B) 2

C) 3

D) 4

Answer: A) 1

25. What is the result of the formula =LARGE({1, 2, 3, 4, 5}, 1)?

A) 1

B) 2

C) 3

D) 5

Answer: D) 5

26. What is the result of the formula =COUNT({"apple", "banana", ""})?

A) 2

B) 3

C) 4

D) 5

Answer: B) 3

27. What is the result of the formula =COUNTA({"apple", "banana", ""})?

A) 2

B) 3

C) 4

D) 5

Answer: B) 3

28. What is the result of the formula =COUNTBLANK({"apple", "banana", ""})?

A) 0

B) 1

C) 2

D) 3

Answer: B) 1

29. What is the result of the formula =UPPER("hello")?

A) "hello"

B) "Hello"

C) "HELLO"

D) "HeLlO"

Answer: C) "HELLO"

30. What is the result of the formula =LOWER("HELLO")?

A) "hello"

31. What is the result of the formula =CONCATENATE("Hello", " ", "World")?

A) "Hello World"

B) "HelloWorld"

C) "Hello World "

D) #ERROR

Answer: A) "Hello World"

32. What is the result of the formula =ROMAN(2022)?

A) MMXXII

B) 2022

C) Roman numeral for 2022

D) #ERROR

Answer: A) MMXXII

33. What is the result of the formula =LEFT("Hello World", 5)?

A) "Hello"

B) "World"

C) "Hello World"

D) #ERROR

Answer: A) "Hello"

34. What is the result of the formula =RIGHT("Hello World", 5)?

A) "Hello"

B) "World"

C) "Hello World"

D) #ERROR

Answer: B) "World"

35. What is the result of the formula =NOW()?

A) Current date and time

B) Current date only

C) Current time only

D) #ERROR

Answer: A) Current date and time

36. What is the result of the formula =TODAY()?

A) Current date

B) Current date and time

C) Current time only

D) #ERROR

Answer: A) Current date

37. What is the result of the formula =MONTH(TODAY())?

A) Current month as a number

B) Current month as text

C) Current date

D) #ERROR

Answer: A) Current month as a number

38. What is the result of the formula =CONCATENATE("Hello", " ", "World")?

A) "Hello World"

B) "HelloWorld"

C) "H

ello World "

D) #ERROR

Answer: A) "Hello World"

39. What is the result of the formula =ROMAN(1000)?

A) M

B) 1000

C) Roman numeral for 1000

D) #ERROR

Answer: A) M

40. What is the result of the formula =LEFT("Hello World", 3)?

A) "Hel"

B) "World"

C) "Hello World"

D) #ERROR

Answer: A) "Hel"