# Computer Fundamentals MCQ – MS Excel Quiz

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 __________. Column Cell Address Schema 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? Sorting Pivot Filtering Searching  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 ________ . ( ) Sign = Sign  ; Sign  # sign  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? Arranging Sorting Sequencing Filtering 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? Cell Table Row Column 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? 3 5 7 10 Answer: Option A Explanation: The correct option is A.
 7. Row in MS Excel is identified by ________. Numbers Letters Both numbers and letters All of the above Answer: Option A Explanation: The correct answer is option A.
 8. Column in MS Excel is identified by _________. Numbers Letters Both numbers and letters All of the above Answer: Option B Explanation: The correct answer is option B
 9. Which of the following represent the group of cells? Cell range Multi cell Cell cluster Chart Answer: Option A Explanation: The correct answer is option A.
 10. Which of the following represent the absolute cell reference in Excel ? #B#2 \$B\$2 B2 B:2 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 ? =B1+B2+B3 =SUM(B1:B3) Select B1, B2 and B3 together and then Auto sum All of the above 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? Alt + left arrow key Alt + right arrow key Control + left arrow key Control + right arrow key 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? Alt + up arrow key Alt + down arrow key Control + up arrow key Control + down arrow key 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? F3 F5 F7 F11 Answer: Option D Explanation: The correct option is D.
 15. Which of the following is not the function category in MS Excel?  Logical Text Financial Data series 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? Control + C Control + M Alt +   F Alt + M Answer: Option C Explanation: The correct option is C.
 17. How many characters can fit into the single cell in a worksheet? 255 1024 2048 32767 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? M O P N Answer: Option N Explanation: The correct option is N.
 19. The file extension name for MS Excel 2010 workbook is _______. .excel .xls .xlsx .xlcs Answer: Option C Explanation: The correct option is C.
 20. Which of the following option will denote the cell range from C5 to C10? (C5-C10) (C5:C10) (C10-C5) (C10:C5) Answer: Option B Explanation: The correct option is B.

## You may like to try other  MCQ Quizzes

MCQ – Computer Networking

MCQ – Computer Hardware

MCQ – Network Security

MCQ – CCNA 200-301 Practice Quiz