Top 50+ Solved Excel MCQ Questions Answer
Q. 15-August-2020 was Saturday. Answer of =WEEKDAY(“15-August-2020”) will be_____
a. saturday
b. sat
c. 7
d. 6
Q. 15-August-2020 was Saturday. Answer of =MONTH(“15-August-2020”) will be ________
a. august
b. aug
c. 8
d. 7
Q. 15-August-2020 was Saturday. Answer of =YEAR(“15-August-2020”) will be ________
a. 2020
b. 1920
c. 20
d. 2200
Q. To convert uppercase alphabets to lowercase we use _____
a. lcase( )
b. lower( )
c. upper( )
d. ucase( )
Q. To find number of characters in a string we use _____
a. count( )
b. len( )
c. length( )
d. sum( )
Q. To search a value in the first row of a given range, we use _______.
a. vllokup( )
b. hlookup( )
c. search( )
d. locate( )
Q. To count non blank cells, we use _____.
a. count( )
b. counta( )
c. countblank( )
d. countnonblank( )
Q. To count number of cells that contains numbers, we use _____.
a. count( )
b. counta( )
c. sum( )
d. countif( )