Microsoft Excel MCQs with answers Page - 1

Here, you will find a collection of MCQ questions on Microsoft Excel. Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 799.53K Points
Coach

Q. In Excel 2007, Axes option can be found in

  • (A) Design
  • (B) Layout
  • (C) Format
  • (D) Formulas

A

Admin • 799.53K Points
Coach

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

A

Admin • 799.53K Points
Coach

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

A

Admin • 799.53K Points
Coach

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

A

Admin • 799.53K Points
Coach

Q. In excel, which one chart type is not available

  • (A) Radar
  • (B) Buble
  • (C) Doughnut
  • (D) Sphere

A

Admin • 799.53K Points
Coach

Q. In excel, which chart is also known as X Y chart

  • (A) Pie chart
  • (B) Bar chart
  • (C) Area chart
  • (D) Scatter chart

A

Admin • 799.53K Points
Coach

Q. In which year, Microsoft released the first version of Excel for Windows version

  • (A) 1983
  • (B) 1985
  • (C) 1987
  • (D) 1989

A

Admin • 799.53K Points
Coach

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

A

Admin • 799.53K Points
Coach

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

A

Admin • 799.53K Points
Coach

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

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.