Microsoft Excel MCQs with answers Page - 2

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.58K Points
Coach

Q. Which command need to execute from "run window" to open a new excel file

  • (A) ms excel
  • (B) win excel
  • (C) office excel
  • (D) excel

M

Mr. Dubey • 52.58K Points
Coach

Q. If "A1" is displayed in Name Box, then is indicates which one

  • (A) First column (by A) and first row (by 1)
  • (B) First column (by 1) and first row (by A)
  • (C) First sheet
  • (D) None of the above

M

Mr. Dubey • 52.58K Points
Coach

Q. All formulas in MS Excel is start with _______ sign

  • (A) $
  • (B) =
  • (C) ()
  • (D) !

M

Mr. Dubey • 52.58K Points
Coach

Q. Which function key generates a bar graph from the values entered in excel

  • (A) F9
  • (B) F10
  • (C) F11
  • (D) F12

M

Mr. Dubey • 52.58K Points
Coach

Q. Total number of characters that a cell can contain

  • (A) 24,221
  • (B) 27,685
  • (C) 32,767
  • (D) 39,802

M

Mr. Dubey • 52.58K Points
Coach

Q. You can check the conditions against __________ when applying conditional formatting

  • (A) Cell value
  • (B) Formula
  • (C) Both of above
  • (D) None of above

M

Mr. Dubey • 52.58K Points
Coach

Q. When a range is selected, how can you activate the previous cell?

  • (A) Press the Alt key
  • (B) Press Tab
  • (C) Press Enter
  • (D) None of above

M

Mr. Dubey • 52.58K Points
Coach

Q. You can use the formula palette to

  • (A) Format cells containing numbers
  • (B) Create and edit formula containing functions
  • (C) Enter assumptions data
  • (D) Copy a range of cells

M

Mr. Dubey • 52.58K Points
Coach

Q. VBA in MS-Excel was used from which version

  • (A) Excel 4
  • (B) Excel 5
  • (C) Excel 6
  • (D) Excel 7

M

Mr. Dubey • 52.58K Points
Coach

Q. What is the default extension of Microsoft Excel 2003 saved file

  • (A) .xls
  • (B) .xsl
  • (C) .xlsx
  • (D) .xlxs

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.