MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 32 Mcqs, each offering curated multiple-choice questions to sharpen your Data Mining knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Which of the following addressing modes can be used for writing formulas in a cell in a worksheet in Microsoft Excel |
| A. | Relative |
| B. | Absolute |
| C. | Mixed |
| D. | All of the above |
| Answer» E. | |
| 2. |
Which of the following alignments will apply by default when some text is entered in a cell in a worksheet of Microsoft Excel |
| A. | Centre |
| B. | Left |
| C. | Right |
| D. | None of the above |
| Answer» C. Right | |
| 3. |
Which function is use to display the current date and time in a cell |
| A. | today |
| B. | now |
| C. | day |
| D. | current |
| Answer» C. day | |
| 4. |
Which chart displays values as percentages of the whole |
| A. | Scatter Chart |
| B. | Bar Chart |
| C. | Surface Chart |
| D. | Doughnut Chart |
| Answer» E. | |
| 5. |
The function that counts the number of cells in a range that are not blank is known as __ function |
| A. | COUNTA |
| B. | COUNTB |
| C. | COUNT |
| D. | COUNTIF |
| Answer» B. COUNTB | |
| 6. |
In Excel all styles are __ styles |
| A. | cell |
| B. | tab |
| C. | sheet |
| D. | data |
| Answer» B. tab | |
| 7. |
The Chart title option is available in |
| A. | Format |
| B. | Design |
| C. | Developer |
| D. | Layout |
| Answer» E. | |
| 8. |
What is the syntax of Minimum function () |
| A. | |
| B. | |
| C. | |
| D. | |
| Answer» C. | |
| 9. |
The process of keep the top row visible while scrolling through the rest of the worksheet is known as |
| A. | Freeze Panes |
| B. | Page Breaks |
| C. | Margins |
| D. | Sorting |
| Answer» B. Page Breaks | |
| 10. |
Maximum column width in Excel sheet is |
| A. | 226 Characters |
| B. | 254 Characters |
| C. | 255 Characters |
| D. | 256 Characters |
| Answer» D. 256 Characters | |
| 11. |
Where you can change the "number of Recent Documents" shown option in Excel Office button |
| A. | Save |
| B. | Customize |
| C. | Add-Ins |
| D. | Advanced |
| Answer» E. | |
| 12. |
Which function returns the most common value in a data set |
| A. | LOGINV function |
| B. | INDIRECT function |
| C. | COVAR function |
| D. | MODE function |
| Answer» E. | |
| 13. |
A function inside another function is known as |
| A. | Nested function |
| B. | Mode function |
| C. | HLOOKUP function |
| D. | Indirect function |
| Answer» B. Mode function | |
| 14. |
In Excel Options, the Auto Correct Option can be found in |
| A. | Popular |
| B. | Formulas |
| C. | Proofing |
| D. | Advanced |
| Answer» D. Advanced | |
| 15. |
Zoom slider option is available in |
| A. | Status bar |
| B. | Formula bar |
| C. | Standard bar |
| D. | Quick Access Toolbar |
| Answer» B. Formula bar | |
| 16. |
Strikethrough, Superscript and Subscript are the __ in Excel |
| A. | Design |
| B. | Text Control |
| C. | Effects |
| D. | Style |
| Answer» D. Style | |
| 17. |
Which one is not available in print area selection option when you print a Excel document |
| A. | Entire workbook |
| B. | Columns |
| C. | Active Sheet(s) |
| D. | Table |
| Answer» C. Active Sheet(s) | |
| 18. |
In Excel 2007, Axes option can be found in |
| A. | Design |
| B. | Layout |
| C. | Format |
| D. | Formulas |
| Answer» C. Format | |
| 19. |
Which one/are the Chart Tool tab/tabs that adds in the ribbon when you display a chart |
| A. | Design |
| B. | Layout |
| C. | Format |
| D. | All of the above |
| Answer» E. | |
| 20. |
In excel, which one chart type is not available |
| A. | Radar |
| B. | Buble |
| C. | Doughnut |
| D. | Sphere |
| Answer» E. | |
| 21. |
In excel, which chart is also known as X Y chart |
| A. | Pie chart |
| B. | Bar chart |
| C. | Area chart |
| D. | Scatter chart |
| Answer» E. | |
| 22. |
In which year, Microsoft released the first version of Excel for Windows version |
| A. | 1983 |
| B. | 1985 |
| C. | 1987 |
| D. | 1989 |
| Answer» D. 1989 | |
| 23. |
Which command need to execute from "run window" to open a new excel file |
| A. | ms excel |
| B. | win excel |
| C. | office excel |
| D. | excel |
| Answer» E. | |
| 24. |
If "A1" is displayed in Name Box, then is indicates which one |
| A. | First column (by A) and first row (by 1) |
| B. | First column (by 1) and first row (by A) |
| C. | First sheet |
| D. | None of the above |
| Answer» B. First column (by 1) and first row (by A) | |
| 25. |
All formulas in MS Excel is start with __ sign |
| A. | $ |
| B. | |
| C. | () |
| D. | ! |
| Answer» C. () | |
| 26. |
Which function key generates a bar graph from the values entered in excel |
| A. | F9 |
| B. | F10 |
| C. | F11 |
| D. | F12 |
| Answer» D. F12 | |
| 27. |
Total number of characters that a cell can contain |
| A. | 24,221 |
| B. | 27,685 |
| C. | 32,767 |
| D. | 39,802 |
| Answer» D. 39,802 | |
| 28. |
VBA in MS-Excel was used from which version |
| A. | Excel 4 |
| B. | Excel 5 |
| C. | Excel 6 |
| D. | Excel 7 |
| Answer» C. Excel 6 | |
| 29. |
What is the default extension of Microsoft Excel 2003 saved file |
| A. | .xls |
| B. | .xsl |
| C. | .xlsx |
| D. | .xlxs |
| Answer» B. .xsl | |
| 30. |
What is the maximum number of columns supported in a Excel 2007 worksheet |
| A. | 12,357 |
| B. | 16,384 |
| C. | 21,783 |
| D. | 26,263 |
| Answer» C. 21,783 | |
| 31. |
What is the maximum number of rows supported in a Excel 2007 worksheet |
| A. | 65,357 |
| B. | 78,487 |
| C. | 1,028,176 |
| D. | 1,048,576 |
| Answer» E. | |
| 32. |
The intersection of rows and columns are called |
| A. | Sheet |
| B. | Cell |
| C. | Workbook |
| D. | None of the above |
| Answer» C. Workbook | |