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( )
| Answers: 1-c, 2-c, 3-a, 4-c, 5-b, 6-d, 7-a, 8-d, 9-b, 10-b |
