MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 657 Mcqs, each offering curated multiple-choice questions to sharpen your Testing Subject knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
To search a value in the first row of a given range, we use _______. |
| A. | vllokup( ) |
| B. | hlookup( ) |
| C. | search( ) |
| D. | locate( ) |
| Answer» C. search( ) | |
| 2. |
To find number of characters in a string we use _____ |
| A. | count( ) |
| B. | len( ) |
| C. | length( ) |
| D. | sum( ) |
| Answer» C. length( ) | |
| 3. |
To convert uppercase alphabets to lowercase we use _____ |
| A. | lcase( ) |
| B. | lower( ) |
| C. | upper( ) |
| D. | ucase( ) |
| Answer» C. upper( ) | |
| 4. |
Answer of =DAYS360(“31-Dec-2020â€, “1-Jan-2020â€) will be ________ |
| A. | 365 |
| B. | 366 |
| C. | 360 |
| D. | -360 |
| Answer» E. | |
| 5. |
TODAY( ) returns current ______ |
| A. | date |
| B. | time |
| C. | day |
| D. | date & time |
| Answer» B. time | |
| 6. |
Answer of =TIMEVALUE(“6:00 PMâ€) will be ________ |
| A. | 6:00 |
| B. | 6:00 am |
| C. | 18:00 |
| D. | 0.75 |
| Answer» E. | |
| 7. |
Answer of =YEAR(“15-Aug-20â€) will be |
| A. | 20 |
| B. | 2020 |
| C. | 1920 |
| D. | 2200 |
| Answer» C. 1920 | |
| 8. |
Answer of =DAYS360(“1-Jan-2020â€, “31-Dec-2020â€) will be ________ |
| A. | 365 |
| B. | 366 |
| C. | 360 |
| D. | 364 |
| Answer» D. 364 | |
| 9. |
15-August-2020 was Saturday. Answer of =YEAR(“15-August-2020â€) will be ________ |
| A. | 2020 |
| B. | 1920 |
| C. | 20 |
| D. | 2200 |
| Answer» B. 1920 | |
| 10. |
15-August-2020 was Saturday. Answer of =MONTH(“15-August-2020â€) will be ________ |
| A. | august |
| B. | aug |
| C. | 8 |
| D. | 7 |
| Answer» D. 7 | |
| 11. |
15-August-2020 was Saturday. Answer of =WEEKDAY(“15-August-2020â€) will be_____ |
| A. | saturday |
| B. | sat |
| C. | 7 |
| D. | 6 |
| Answer» D. 6 | |