MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 21 Mcqs, each offering curated multiple-choice questions to sharpen your Computer Science knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Which one is not a Function in MS Excel ? |
| A. | SUM |
| B. | AVG |
| C. | MAX |
| D. | MIN |
| Answer» C. MAX | |
| 2. |
Which functionin Excel checks whether a condition is true or not ? |
| A. | SUM |
| B. | COUNT |
| C. | IF |
| D. | AVERAGE |
| Answer» D. AVERAGE | |
| 3. |
Which functionin Excel tells how many numeric entries are there ? |
| A. | NUM |
| B. | COUNT |
| C. | SUM |
| D. | CHKNUM |
| Answer» C. SUM | |
| 4. |
What type of chart will you use to compare performance of two employees in the year 2016 ? |
| A. | Column Chart |
| B. | Line Chart |
| C. | Pie Chart |
| D. | Dot Chart |
| Answer» C. Pie Chart | |
| 5. |
What type of chart will you use to compare performance of sales of two products ? |
| A. | Column Chart |
| B. | Line Chart |
| C. | Pie Chart |
| D. | Both A and B |
| Answer» B. Line Chart | |
| 6. |
What type of chart is useful for showing trends or changes over time ? |
| A. | Pie Chart |
| B. | Column Chart |
| C. | Line Chart |
| D. | Dot Graph |
| Answer» D. Dot Graph | |
| 7. |
What type of chart is good for single series of data ? |
| A. | Column Chart |
| B. | Line Chart |
| C. | Pie Chart |
| D. | Cone Chart |
| Answer» D. Cone Chart | |
| 8. |
What type of chart is useful for comparing parts of a whole ? |
| A. | Pie Chart |
| B. | Column Chart |
| C. | Line Chart |
| D. | Dot Graph |
| Answer» B. Column Chart | |
| 9. |
What type of chart is useful for comparing values over categories ? |
| A. | Pie Chart |
| B. | Column Chart |
| C. | Line Chart |
| D. | Dot Graph |
| Answer» C. Line Chart | |
| 10. |
The process of arrenging the items of a column in some sequence or order is known as : |
| A. | Arrengin |
| B. | Autofill |
| C. | Sorting |
| D. | Filtering |
| Answer» D. Filtering | |
| 11. |
The Greater Than sign (>) is an example of _____ operator. |
| A. | Arithmatic |
| B. | Logical |
| C. | Conditional |
| D. | Greater |
| Answer» C. Conditional | |
| 12. |
The ____ feature of MS Excel quickly completes a series of data |
| A. | Auto Complete |
| B. | Auto Fill |
| C. | Fill Handle |
| D. | Sorting |
| Answer» C. Fill Handle | |
| 13. |
It is a collection of data that is stored electronically as a series of records in a table. |
| A. | spreadsheet |
| B. | presentation |
| C. | database |
| D. | MS Word |
| Answer» D. MS Word | |
| 14. |
In Excel, which one denoted a range from B1 through E5 |
| A. | B1 - E5 |
| B. | B1:E5 |
| C. | B1 to E5 |
| D. | B1$E5 |
| Answer» C. B1 to E5 | |
| 15. |
In Excel, Rows are labelled as ______ |
| A. | A, B, C, etc |
| B. | 1,2,3 etc |
| C. | A1, A2, etc. |
| D. | $A$1, $A$2, etc. |
| Answer» C. A1, A2, etc. | |
| 16. |
In Excel, Columns are labelled as ___ |
| A. | A, B, C, etc |
| B. | 1,2,3 etc |
| C. | A1, A2, etc. |
| D. | $A$1, $A$2, etc. |
| Answer» B. 1,2,3 etc | |
| 17. |
How will you graphically represent expenditure in different departments ? |
| A. | Column Chart |
| B. | Line Chart |
| C. | Pie Chart |
| D. | Dot Chart |
| Answer» D. Dot Chart | |
| 18. |
How many sheets are there, by default, when we create a new Excel file ? |
| A. | 1 |
| B. | 3 |
| C. | 5 |
| D. | 10 |
| Answer» C. 5 | |
| 19. |
Functions in MS Excel must begin with ___ |
| A. | An () sign |
| B. | An Equal Sign |
| C. | A Plus Sign |
| D. | A > Sign |
| Answer» C. A Plus Sign | |
| 20. |
An Excel file is generally called a / an : |
| A. | E-Spreadsheet |
| B. | Woorksheet |
| C. | Workbook |
| D. | Sheet |
| Answer» D. Sheet | |
| 21. |
A features that displays only the data in column (s) according to specified criteria |
| A. | Formula |
| B. | Sorting |
| C. | Filtering |
| D. | Pivot |
| Answer» D. Pivot | |