Microsoft Excel MCQs with answers Page - 3

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

Q. Which of the following is invalid statement?

  • (A) Sheet tabs can be colored
  • (B) Some picture can be applied as a background of a sheet
  • (C) You can set the column width automatically fit the amount of text
  • (D) The width of a row and be specified manually or fit automatically

M

Mr. Dubey • 52.91K Points
Coach 

Q. What is the maximum number of columns supported in a Excel 2007 worksheet

  • (A) 12,357
  • (B) 16,384
  • (C) 21,783
  • (D) 26,263

M

Mr. Dubey • 52.91K Points
Coach 

Q. What is the maximum number of rows supported in a Excel 2007 worksheet

  • (A) 65,357
  • (B) 78,487
  • (C) 1,028,176
  • (D) 1,048,576

M

Mr. Dubey • 52.91K Points
Coach 

Q. The intersection of rows and columns are called

  • (A) Sheet
  • (B) Cell
  • (C) Workbook
  • (D) None of the above

M

Mr. Dubey • 52.91K Points
Coach 

Q. Which of the following is not true about Find and Replace in Excel

  • (A) You can search for bold and replace with italics
  • (B) You can decide whether to look for the whole word or not
  • (C) You can search in formula too
  • (D) You can search by rows or columns or sheets

M

Mr. Dubey • 52.91K Points
Coach 

Q. You can move a sheet from one workbook into new book by

  • (A) From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK
  • (B) From Edit menu choose Move of Copy then choose (Move to end) and click OK
  • (C) From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
  • (D) None of above

M

Mr. Dubey • 52.91K Points
Coach 

Q. Comments can be added to cells using ________

  • (A) Home > Comments
  • (B) Insert > Comment
  • (C) Data > Comments
  • (D) Review > Comments

M

Mr. Dubey • 52.91K Points
Coach 

Q. Which menu option can be used to split windows into two?

  • (A) Review > Window
  • (B) View > Window > Split
  • (C) Window > Split
  • (D) View > Split

M

Mr. Dubey • 52.91K Points
Coach 

Q. Which one is not available in print area selection option when you print a Excel document

  • (A) Entire workbook
  • (B) Columns
  • (C) Active Sheet(s)
  • (D) Table

M

Mr. Dubey • 52.91K Points
Coach 

Q. Strikethrough, Superscript and Subscript are the _______ in Excel

  • (A) Design
  • (B) Text Control
  • (C) Effects
  • (D) Style

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.