# 50+ MCQ’s On MS-Excel | Computer Systems and Applications

## MCQ’s On MS-Excel

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 extract 3 characters starting from 2nd character of a string “EXCEL” we use _______
(a) =MID(“EXCEL”,3,2)
(b) =MID(“EXCEL”,2,3)
(c) =MID(“EXCEL”,2,5)
(d) =MID(“EXCEL”,5,2)

10. To convert uppercase alphabets to lowercase we use _____
(a) LCASE( )
(b) LOWER( )
(c) UPPER( )
(d) UCASE( )