McqMate
These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: Bachelor of Commerce (B Com) , MCQ on Computer Softwares .
| 1. |
15-August-2020 was Saturday. Answer of =WEEKDAY(“15-August-2020”) will be_____ |
| A. | saturday |
| B. | sat |
| C. | 7 |
| D. | 6 |
| Answer» C. 7 | |
| 2. |
15-August-2020 was Saturday. Answer of =MONTH(“15-August-2020”) will be ________ |
| A. | august |
| B. | aug |
| C. | 8 |
| D. | 7 |
| Answer» C. 8 | |
| 3. |
15-August-2020 was Saturday. Answer of =YEAR(“15-August-2020”) will be ________ |
| A. | 2020 |
| B. | 1920 |
| C. | 20 |
| D. | 2200 |
| Answer» A. 2020 | |
| 4. |
Answer of =DAYS360(“1-Jan-2020”, “31-Dec-2020”) will be ________ |
| A. | 365 |
| B. | 366 |
| C. | 360 |
| D. | 364 |
| Answer» C. 360 | |
| 5. |
Answer of =YEAR(“15-Aug-20”) will be |
| A. | 20 |
| B. | 2020 |
| C. | 1920 |
| D. | 2200 |
| Answer» B. 2020 | |
| 6. |
Answer of =TIMEVALUE(“6:00 PM”) will be ________ |
| A. | 6:00 |
| B. | 6:00 am |
| C. | 18:00 |
| D. | 0.75 |
| Answer» D. 0.75 | |
| 7. |
TODAY( ) returns current ______ |
| A. | date |
| B. | time |
| C. | day |
| D. | date & time |
| Answer» A. date | |
| 8. |
Answer of =DAYS360(“31-Dec-2020”, “1-Jan-2020”) will be ________ |
| A. | 365 |
| B. | 366 |
| C. | 360 |
| D. | -360 |
| Answer» D. -360 | |
| 9. |
To convert uppercase alphabets to lowercase we use _____ |
| A. | lcase( ) |
| B. | lower( ) |
| C. | upper( ) |
| D. | ucase( ) |
| Answer» B. lower( ) | |
| 10. |
To find number of characters in a string we use _____ |
| A. | count( ) |
| B. | len( ) |
| C. | length( ) |
| D. | sum( ) |
| Answer» B. len( ) | |
| 11. |
To search a value in the first row of a given range, we use _______. |
| A. | vllokup( ) |
| B. | hlookup( ) |
| C. | search( ) |
| D. | locate( ) |
| Answer» B. hlookup( ) | |
| 12. |
To count non blank cells, we use _____. |
| A. | count( ) |
| B. | counta( ) |
| C. | countblank( ) |
| D. | countnonblank( ) |
| Answer» B. counta( ) | |
| 13. |
To count number of cells that contains numbers, we use _____. |
| A. | count( ) |
| B. | counta( ) |
| C. | sum( ) |
| D. | countif( ) |
| Answer» A. count( ) | |
| 14. |
Which of the following is not a valid chart type in Excel. |
| A. | line |
| B. | bar |
| C. | pie |
| D. | graph |
| Answer» D. graph | |
| 15. |
Axis Title is not allowed in this type of graphs. |
| A. | line |
| B. | bar |
| C. | column |
| D. | pie |
| Answer» D. pie | |
| 16. |
Select odd man out from the following graph types. |
| A. | line |
| B. | bar |
| C. | column |
| D. | pie |
| Answer» D. pie | |
| 17. |
Charts are available under _______ Ribbon/Menu. |
| A. | home |
| B. | insert |
| C. | data |
| D. | view |
| Answer» B. insert | |
| 18. |
Goal Seek Option is available under ____ Ribbon/Menu. |
| A. | home |
| B. | insert |
| C. | data |
| D. | view |
| Answer» C. data | |
| 19. |
Number of changing cells for a Scenario is limited to ____ |
| A. | 16 |
| B. | 32 |
| C. | 1 |
| D. | 2 |
| Answer» B. 32 | |
| 20. |
Number of changing cells for a Goal Seek is limited to ______ |
| A. | 16 |
| B. | 32 |
| C. | 1 |
| D. | 2 |
| Answer» C. 1 | |
| 21. |
Solver Option is available under ____ Ribbon/Menu. |
| A. | developer |
| B. | data |
| C. | insert |
| D. | home |
| Answer» B. data | |
| 22. |
Record Macro option is available under ____ Ribbon/Menu. |
| A. | developer |
| B. | data |
| C. | insert |
| D. | home |
| Answer» A. developer | |
| 23. |
Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(A2)? |
| A. | a2 |
| B. | a |
| C. | co |
| D. | c |
| Answer» 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 |
| Answer» B. a | |
| 25. |
Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(A2, 3)? |
| A. | a2 |
| B. | er |
| C. | co |
| D. | com |
| Answer» D. com | |
| 26. |
What will be the answer of =DAYS360(“1-Feb-2020”, “1-Mar-2020”)? |
| A. | 28 |
| B. | 29 |
| C. | 30 |
| D. | 31 |
| Answer» C. 30 | |
| 27. |
What will be the answer of =DATEVALUE(“1-Feb-1900”)? |
| A. | 1 |
| B. | 32 |
| C. | 30 |
| D. | one |
| Answer» B. 32 | |
| 28. |
What will be the answer of =TIMEVALUE(“12:00 PM”)? |
| A. | 12.00 |
| B. | 12 |
| C. | 0.5 |
| D. | 0.25 |
| Answer» C. 0.5 | |
| 29. |
What will be the answer of =MONTH(32)? |
| A. | 2 |
| B. | 3 |
| C. | 8 |
| D. | 9 |
| Answer» A. 2 | |
| 30. |
What will be the answer of =DAY(32)? |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» A. 1 | |
| 31. |
What will be the answer of =YEAR(32)? |
| A. | 1932 |
| B. | 2032 |
| C. | 1990 |
| D. | 1900 |
| Answer» D. 1900 | |
| 32. |
If cell B1 contains text MUMBAI then what will be the answer of =LOWER(B1)? |
| A. | mumbai |
| B. | mumbai |
| C. | b1 |
| D. | b |
| Answer» B. mumbai | |
| 33. |
What will be the answer of =PROPER(“verus d’sa”)? |
| A. | verus d’sa |
| B. | verus d’sa |
| C. | verus d’sa |
| D. | verus d’sa |
| Answer» C. verus d’sa | |
| 34. |
What will be the answer of =MID(“COMMERCE”,3,2)? |
| A. | omm |
| B. | mme |
| C. | mm |
| D. | er |
| Answer» C. mm | |
| 35. |
Excel formula cannot start with ____ |
| A. | + |
| B. | - |
| C. | * |
| D. | = |
| Answer» C. * | |
| 36. |
Which of the following is an invalid arithmetic operator? |
| A. | + |
| B. | - |
| C. | |
| D. | ^ |
| Answer» C. | |
| 37. |
If cell A1 contains a number 100, then what will be the answer of =IF(A1< 200, A1+10, A1-10)? |
| A. | 90 |
| B. | 110 |
| C. | 190 |
| D. | 210 |
| Answer» B. 110 | |
| 38. |
When we want to hide the records which are not satisfying a given condition, then we use ________ command. |
| A. | sort |
| B. | filter |
| C. | goal seek |
| D. | solver |
| Answer» B. filter | |
| 39. |
We can add constraints while using __________ command. |
| A. | goal seek |
| B. | solver |
| C. | scenario manager |
| D. | data table |
| Answer» B. solver | |
| 40. |
By default extension for template file is _______ |
| A. | .temp |
| B. | .xltx |
| C. | .tem |
| D. | . xlsx |
| Answer» B. .xltx | |
| 41. |
Excel macros can be edited using _______ editor. |
| A. | visual basic |
| B. | excel |
| C. | c |
| D. | java |
| Answer» A. visual basic | |
| 42. |
To make data interesting, attractive and easy to read and evaluate, we use ______ |
| A. | graphs |
| B. | filter |
| C. | scenario |
| D. | solver |
| Answer» A. graphs | |
| 43. |
_____ graph allows only one range of values. |
| A. | bar |
| B. | line |
| C. | column |
| D. | pie |
| Answer» D. pie | |
| 44. |
Gridlines are not allowed for ___ type of graphs. |
| A. | bar |
| B. | line |
| C. | column |
| D. | pie |
| Answer» D. pie | |
| 45. |
With Numeric Filters ______ operation is not allowed. |
| A. | top 10 |
| B. | above average |
| C. | greater than |
| D. | begins with |
| Answer» D. begins with | |
| 46. |
With Text Filters _____ operation is not allowed. |
| A. | begins with |
| B. | ends with |
| C. | above average |
| D. | contains |
| Answer» C. above average | |
| 47. |
Which of the following function is invalid. |
| A. | sumif( ) |
| B. | avgif( ) |
| C. | countif( ) |
| D. | if( ) |
| Answer» B. avgif( ) | |
Done Studing? Take A Test.
Great job completing your study session! Now it's time to put your knowledge to the test. Challenge yourself, see how much you've learned, and identify areas for improvement. Don’t worry, this is all part of the journey to mastery. Ready for the next step? Take a quiz to solidify what you've just studied.