Excel | Set 1

1. 15-August-2020 was Saturday. Answer of =WEEKDAY(“15-August-2020”) will be_____

A. saturday

B. sat

C. 7

D. 6

Correct : C. 7

2. 15-August-2020 was Saturday. Answer of =MONTH(“15-August-2020”) will be ________

A. august

B. aug

C. 8

D. 7

Correct : C. 8

3. 15-August-2020 was Saturday. Answer of =YEAR(“15-August-2020”) will be ________

A. 2020

B. 1920

C. 20

D. 2200

Correct : A. 2020

4. Answer of =DAYS360(“1-Jan-2020”, “31-Dec-2020”) will be ________

A. 365

B. 366

C. 360

D. 364

Correct : C. 360

5. Answer of =YEAR(“15-Aug-20”) will be

A. 20

B. 2020

C. 1920

D. 2200

Correct : B. 2020

6. Answer of =TIMEVALUE(“6:00 PM”) will be ________

A. 6:00

B. 6:00 am

C. 18:00

D. 0.75

Correct : D. 0.75

7. TODAY( ) returns current ______

A. date

B. time

C. day

D. date & time

Correct : A. date

8. Answer of =DAYS360(“31-Dec-2020”, “1-Jan-2020”) will be ________

A. 365

B. 366

C. 360

D. -360

Correct : D. -360

9. To convert uppercase alphabets to lowercase we use _____

A. lcase( )

B. lower( )

C. upper( )

D. ucase( )

Correct : B. lower( )

10. To find number of characters in a string we use _____

A. count( )

B. len( )

C. length( )

D. sum( )

Correct : B. len( )

11. To search a value in the first row of a given range, we use _______.

A. vllokup( )

B. hlookup( )

C. search( )

D. locate( )

Correct : B. hlookup( )

12. To count non blank cells, we use _____.

A. count( )

B. counta( )

C. countblank( )

D. countnonblank( )

Correct : B. counta( )

13. To count number of cells that contains numbers, we use _____.

A. count( )

B. counta( )

C. sum( )

D. countif( )

Correct : A. count( )

14. Which of the following is not a valid chart type in Excel.

A. line

B. bar

C. pie

D. graph

Correct : D. graph

15. Axis Title is not allowed in this type of graphs.

A. line

B. bar

C. column

D. pie

Correct : D. pie

16. Select odd man out from the following graph types.

A. line

B. bar

C. column

D. pie

Correct : D. pie

17. Charts are available under _______ Ribbon/Menu.

A. home

B. insert

C. data

D. view

Correct : B. insert

18. Goal Seek Option is available under ____ Ribbon/Menu.

A. home

B. insert

C. data

D. view

Correct : C. data

19. Number of changing cells for a Scenario is limited to ____

A. 16

B. 32

C. 1

D. 2

Correct : B. 32

20. Number of changing cells for a Goal Seek is limited to ______

A. 16

B. 32

C. 1

D. 2

Correct : C. 1

21. Solver Option is available under ____ Ribbon/Menu.

A. developer

B. data

C. insert

D. home

Correct : B. data

22. Record Macro option is available under ____ Ribbon/Menu.

A. developer

B. data

C. insert

D. home

Correct : A. developer

23. Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(A2)?

A. a2

B. a

C. co

D. c

Correct : D. c

24. Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(“A2”)?

A. a2

B. a

C. co

D. c

Correct : B. a

25. Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(A2, 3)?

A. a2

B. er

C. co

D. com

Correct : D. com

26. What will be the answer of =DAYS360(“1-Feb-2020”, “1-Mar-2020”)?

A. 28

B. 29

C. 30

D. 31

Correct : C. 30

27. What will be the answer of =DATEVALUE(“1-Feb-1900”)?

A. 1

B. 32

C. 30

D. one

Correct : B. 32

28. What will be the answer of =TIMEVALUE(“12:00 PM”)?

A. 12.00

B. 12

C. 0.5

D. 0.25

Correct : C. 0.5

29. What will be the answer of =MONTH(32)?

A. 2

B. 3

C. 8

D. 9

Correct : A. 2

30. What will be the answer of =DAY(32)?

A. 1

B. 2

C. 3

D. 4

Correct : A. 1

31. What will be the answer of =YEAR(32)?

A. 1932

B. 2032

C. 1990

D. 1900

Correct : D. 1900

32. If cell B1 contains text MUMBAI then what will be the answer of =LOWER(B1)?

A. mumbai

B. mumbai

C. b1

D. b

Correct : B. mumbai

33. What will be the answer of =PROPER(“verus d’sa”)?

A. verus d’sa

B. verus d’sa

C. verus d’sa

D. verus d’sa

Correct : C. verus d’sa

34. What will be the answer of =MID(“COMMERCE”,3,2)?

A. omm

B. mme

C. mm

D. er

Correct : C. mm

35. Excel formula cannot start with ____

A. +

B. -

C. *

D. =

Correct : C. *

36. Which of the following is an invalid arithmetic operator?

A. +

B. -

C. 

D. ^

Correct : C. 

37. If cell A1 contains a number 100, then what will be the answer of =IF(A1< 200, A1+10, A1-10)?

A. 90

B. 110

C. 190

D. 210

Correct : B. 110

38. When we want to hide the records which are not satisfying a given condition, then we use ________ command.

A. sort

B. filter

C. goal seek

D. solver

Correct : B. filter

39. We can add constraints while using __________ command.

A. goal seek

B. solver

C. scenario manager

D. data table

Correct : B. solver

40. By default extension for template file is _______

A. .temp

B. .xltx

C. .tem

D. . xlsx

Correct : B. .xltx

41. Excel macros can be edited using _______ editor.

A. visual basic

B. excel

C. c

D. java

Correct : A. visual basic

42. To make data interesting, attractive and easy to read and evaluate, we use ______

A. graphs

B. filter

C. scenario

D. solver

Correct : A. graphs

43. _____ graph allows only one range of values.

A. bar

B. line

C. column

D. pie

Correct : D. pie

44. Gridlines are not allowed for ___ type of graphs.

A. bar

B. line

C. column

D. pie

Correct : D. pie

45. With Numeric Filters ______ operation is not allowed.

A. top 10

B. above average

C. greater than

D. begins with

Correct : D. begins with

46. With Text Filters _____ operation is not allowed.

A. begins with

B. ends with

C. above average

D. contains

Correct : C. above average

47. Which of the following function is invalid.

A. sumif( )

B. avgif( )

C. countif( )

D. if( )

Correct : B. avgif( )

Quiznetik

Excel | Set 1

1. 15-August-2020 was Saturday. Answer of =WEEKDAY(“15-August-2020”) will be_____

2. 15-August-2020 was Saturday. Answer of =MONTH(“15-August-2020”) will be ________

3. 15-August-2020 was Saturday. Answer of =YEAR(“15-August-2020”) will be ________

4. Answer of =DAYS360(“1-Jan-2020”, “31-Dec-2020”) will be ________

5. Answer of =YEAR(“15-Aug-20”) will be

6. Answer of =TIMEVALUE(“6:00 PM”) will be ________

7. TODAY( ) returns current ______

8. Answer of =DAYS360(“31-Dec-2020”, “1-Jan-2020”) will be ________

9. To convert uppercase alphabets to lowercase we use _____

10. To find number of characters in a string we use _____

11. To search a value in the first row of a given range, we use _______.

12. To count non blank cells, we use _____.

13. To count number of cells that contains numbers, we use _____.

14. Which of the following is not a valid chart type in Excel.

15. Axis Title is not allowed in this type of graphs.

16. Select odd man out from the following graph types.

17. Charts are available under _______ Ribbon/Menu.

18. Goal Seek Option is available under ____ Ribbon/Menu.

19. Number of changing cells for a Scenario is limited to ____

20. Number of changing cells for a Goal Seek is limited to ______

21. Solver Option is available under ____ Ribbon/Menu.

22. Record Macro option is available under ____ Ribbon/Menu.

23. Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(A2)?

24. Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(“A2”)?

25. Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(A2, 3)?

26. What will be the answer of =DAYS360(“1-Feb-2020”, “1-Mar-2020”)?

27. What will be the answer of =DATEVALUE(“1-Feb-1900”)?

28. What will be the answer of =TIMEVALUE(“12:00 PM”)?

29. What will be the answer of =MONTH(32)?

30. What will be the answer of =DAY(32)?

31. What will be the answer of =YEAR(32)?

32. If cell B1 contains text MUMBAI then what will be the answer of =LOWER(B1)?

33. What will be the answer of =PROPER(“verus d’sa”)?

34. What will be the answer of =MID(“COMMERCE”,3,2)?

35. Excel formula cannot start with ____

36. Which of the following is an invalid arithmetic operator?

37. If cell A1 contains a number 100, then what will be the answer of =IF(A1< 200, A1+10, A1-10)?

38. When we want to hide the records which are not satisfying a given condition, then we use ________ command.

39. We can add constraints while using __________ command.

40. By default extension for template file is _______

41. Excel macros can be edited using _______ editor.

42. To make data interesting, attractive and easy to read and evaluate, we use ______

43. _____ graph allows only one range of values.

44. Gridlines are not allowed for ___ type of graphs.

45. With Numeric Filters ______ operation is not allowed.

46. With Text Filters _____ operation is not allowed.

47. Which of the following function is invalid.