Table of Contents
This MCQ section contains the computer fundamentals quiz on Microsoft Excel . You can test your IQ on the MCQ Quiz of Microsoft Excel. Each question is a multiple-choice type with a single answer. The section consists of 20 questions with multiple-choice options.
Each question is provided with the correct answer and an explanation for the correct answer. Click on the button named “Answer” just below the question to view the answer and the explanation. You can hide the answer and the explanation by re-clicking the “Answer” button.
Computer Fundamentals MCQ – MS Excel Quiz
1. The intersection of column and rows in Microsoft Excel worksheet is called __________.
Answer: Option B Explanation: The correct option is B. The intersection between column and row in an Excel sheet is called a cell.
|
2. Which of the following features allow the display of only required data in a column as per the specified criteria?
Answer: Option C Explanation: The correct option is C. Filtering is a feature in MS Excel which allows to display the required data of a column according to the specified criteria.
|
3. Any formula or a function in Excel starts with ________ .
Answer: Option B Explanation: The correct option is B. An Equal ( = ) sign is added before any formula or function in Excel.
|
4. Which of the following options are helpful in arranging the data of a column in ascending or descending order?
Answer: Option B Explanation: The correct answer is B. The sorting option will arrange the data in column in ascending or descending order in Excel.
|
5. Which of the following is the basic unit of Excel worksheet?
Answer: Option A Explanation: The correct option is A. The cell is the basic unit of Excel sheet.
|
6. By default, how many worksheet are available in MS Excel?
Answer: Option A Explanation: The correct option is A.
|
7. Row in MS Excel is identified by ________.
Answer: Option A Explanation: The correct answer is option A.
|
8. Column in MS Excel is identified by _________.
Answer: Option B Explanation: The correct answer is option B
|
9. Which of the following represent the group of cells?
Answer: Option A Explanation: The correct answer is option A.
|
10. Which of the following represent the absolute cell reference in Excel ?
Answer: Option B Explanation: The correct answer is option B.
|
11. Which of the following are the valid way of adding the cell value in B1, B2 and B3 ?
Answer: Option D Explanation: The correct answer is option D.
|
12. Which of the following keyboard command will let you go to the last column of the worksheet?
Answer: Option D Explanation: The correct option is D.
|
13. Which of the following keyboard command will let you go to the last row of the worksheet?
Answer: Option D Explanation: The correct answer is option D.
|
14. Which of the following keyboard command is used for creating a chart from the selected cell?
Answer: Option D Explanation: The correct option is D.
|
15. Which of the following is not the function category in MS Excel?
Answer: Option D Explanation: The correct option is D.
|
16. Which of the following short cut command is used to go to the formula tab?
Answer: Option C Explanation: The correct option is C.
|
17. How many characters can fit into the single cell in a worksheet?
Answer: Option D Explanation: The correct answer is D.
|
18. Which of the following option is used with control key to open a new worksheet?
Answer: Option N Explanation: The correct option is N.
|
19. The file extension name for MS Excel 2010 workbook is _______.
Answer: Option C Explanation: The correct option is C.
|
20. Which of the following option will denote the cell range from C5 to C10?
Answer: Option B Explanation: The correct option is B.
|