Microsoft Excel MCQ Questions with Answer

In this MS Excel Multiple Choice Questions (MCQ) with Answer, you will find all the relevant topics of MS Excel subject. These MCQs will help you to prepare for any interviews, exams, certification, quiz & online test. There are multiple sets of questions are available in this MS Excel MCQ. These MCQs have 10 questions in each set. You will find the most relevant and accurate topics to enhance your MS Excel knowledge. You should take all the quiz 1 by 1 to increase your skills or get better opportunities in your current role.

MS Excel MCQ Questions and Answers:

Below are the Microsoft Excel MCQs that will test your proficiency in the world’s most popular spreadsheet software.

Q1. Which of the following will not cut information?

1. Pressing Ctrl + C
2. Selecting Edit>Cut from the menu
3. Clicking the Cut button on the standard
4. Pressing Ctrl+X

Q2. To activate the previous cell in a pre-selected range, press

1. The Alt key
2. The Tab key
3. The Enter key
4. None of the above

Q3. Which wizard lets you convert existing Excel worksheet data and charts into HTML documents?

1. FTP wizard
2. Internet assistant wizard
3. Intranet wizard
4. Import wizard

Q4. You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

1. Pie chart
2. Row chart
3. Line chart
4. Column chart

Q5. Which of the following should include during data documentation?

1. Destination and users of the output data
2. Source of input data
3. Information on the purpose of the workbook
4. all of these

Q6. Getting data from a cell located in a different sheet is called?

1. Accessing
2. Referencing
3. Updating
4. Functioning

Q7. The default header for a worksheet is?

1. Your name
2. The date and time
3. None
4. The sheet tab name

Q8. Which of the following describes how to select all the cells in a single column?

1. Right click on column and select Pick from list
2. Use data – text to columns menu item
3. Left click on the gray column title button
4. Pressing Ctrl + A on the keyboard

Q9. You can add an image to a template by clicking the Insert Picture From File button on the ______________ Toolbar.

1. Standard
2. Formatting
3. Drawing
4. Picture

Q10. Which of the following is not a worksheet design criterion?

1. Efficiency
2. Auditability
3. Description
4. Clarity

MS Excel MCQ Quiz and Online Test:

These MS Excel MCQ practice sets gives you the feeling of reality and a clue to the questions asked in the actual Microsoft Excel related exams. When you solve these MCQ questions practically, you come across many difficulties that give you an opportunity to improve.