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

M

Mr. Dubey • 52.31K Points
Coach

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

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

M

Mr. Dubey • 52.31K 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

M

Mr. Dubey • 52.31K 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

M

Mr. Dubey • 52.31K 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

M

Mr. Dubey • 52.31K Points
Coach

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

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

M

Mr. Dubey • 52.31K 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

M

Mr. Dubey • 52.31K Points
Coach

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

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

M

Mr. Dubey • 52.31K 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

M

Mr. Dubey • 52.31K 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

M

Mr. Dubey • 52.31K 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

Loding content...

Download our easy to use, user friendly Android App from Play Store. And learn MCQs with one click.

Image

Login

Forgot username? click here

Forgot password? Click here

Don't have account? Register here.