Microsoft Excel MCQs with answers Page - 1

Dear candidates you will find MCQ questions of Microsoft Excel here. Learn these questions and prepare yourself for coming examinations and interviews. You can check the right answer of any question by clicking on any option or by clicking view answer button.
Share your questions by clicking Add Question

📊 Microsoft Excel
Q. In Excel 2007, Axes option can be found in
  • (A) Design
  • (B) Layout
  • (C) Format
  • (D) Formulas
💬 Discuss
✅ Correct Answer: (B) Layout
📊 Microsoft Excel
Q. 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
💬 Discuss
✅ Correct Answer: (D) All of the above
📊 Microsoft Excel
Q. Which of the following format you can decide to apply or not in AutoFormat dialog box?
  • (A) Number format
  • (B) Border format
  • (C) Font format
  • (D) All of above
💬 Discuss
✅ Correct Answer: (D) All of above
📊 Microsoft Excel
Q. How can you remove borders applied in cells?
  • (A) Choose None on Border tab of Format cells
  • (B) Open the list on Border tool in Format Cell toolbar then choose first tool (none)
  • (C) Both of above
  • (D) None of above
💬 Discuss
✅ Correct Answer: (C) Both of above
📊 Microsoft Excel
Q. In excel, which one chart type is not available
  • (A) Radar
  • (B) Buble
  • (C) Doughnut
  • (D) Sphere
💬 Discuss
✅ Correct Answer: (D) Sphere
📊 Microsoft Excel
Q. In excel, which chart is also known as X Y chart
  • (A) Pie chart
  • (B) Bar chart
  • (C) Area chart
  • (D) Scatter chart
💬 Discuss
✅ Correct Answer: (D) Scatter chart
📊 Microsoft Excel
Q. In which year, Microsoft released the first version of Excel for Windows version
  • (A) 1983
  • (B) 1985
  • (C) 1987
  • (D) 1989
💬 Discuss
✅ Correct Answer: (C) 1987
📊 Microsoft Excel
Q. Where can you set the shading color for a range of cells in Excel?
  • (A) Choose required color form Patterns tab of Format Cells dialog box
  • (B) Choose required color on Fill Color tool in Formatting toolbar
  • (C) Choose required color on Fill Color tool in Drawing toolbar
  • (D) All of above
💬 Discuss
✅ Correct Answer: (D) All of above
📊 Microsoft Excel
Q. You can set Page Border in Excel from
  • (A) From Border tab in Format Cells dialog box
  • (B) From Border tool in Formatting toolbar
  • (C) From Line Style tool in Drawing toolbar
  • (D) You can not set page border in Excel
💬 Discuss
✅ Correct Answer: (D) You can not set page border in Excel
📊 Microsoft Excel
Q. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
  • (A) Use =if() function to format the required numbers red
  • (B) Apply Conditional Formatting command on Format menu
  • (C) Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
  • (D) All of above
💬 Discuss
✅ Correct Answer: (B) Apply Conditional Formatting command on Format menu

Programming Categories

📱 Download Our App

Learn MCQs on the go with our easy-to-use Android app

Get it on Google Play