Excel solved MCQs

1 of 2

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

a. saturday

B. sat

c. 7

d. 6

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

a. august

B. aug

c. 8

d. 7

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

a. 2020

B. 1920

c. 20

d. 2200

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

a. 365

B. 366

c. 360

d. 364

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

a. 20

B. 2020

c. 1920

d. 2200

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

a. 6:00

B. 6:00 am

c. 18:00

d. 0.75

7. TODAY( ) returns current ______

a. date

B. time

c. day

d. date & time

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

a. 365

B. 366

c. 360

d. -360

9. To convert uppercase alphabets to lowercase we use _____

a. lcase( )

B. lower( )

c. upper( )

d. ucase( )

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

a. count( )

B. len( )

c. length( )

d. sum( )

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

a. vllokup( )

B. hlookup( )

c. search( )

d. locate( )

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

a. count( )

B. counta( )

c. countblank( )

d. countnonblank( )

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

a. count( )

B. counta( )

c. sum( )

d. countif( )

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

a. line

B. bar

c. pie

d. graph

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

a. line

B. bar

c. column

d. pie

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

a. line

B. bar

c. column

d. pie

17. Charts are available under _______ Ribbon/Menu.

a. home

B. insert

c. data

d. view

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

a. home

B. insert

c. data

d. view

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

a. 16

B. 32

c. 1

d. 2

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

a. 16

B. 32

c. 1

d. 2

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

a. developer

B. data

c. insert

d. home

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

a. developer

B. data

c. insert

d. home

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

a. a2

B. a

c. co

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

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

a. a2

B. er

c. co

d. com

Tags

Question and answers in Excel,

Excel Multiple choice questions and answers,

Important MCQ of Excel,

Solved MCQs for Excel,

Excel MCQ with answers PDF download

Jump to set ->

Each set has max 25 mcqs

Check your understanding of
Excel

Excel [set-1] solved mcqs PDF download

Share