Microsoft Excel Questions and Answers

Practice Mode
Showing 10 of 255 questions
Q51
In Excel which of the following is not an option in the spelling dialog box
  • A Edit
  • B Ignore
  • C Ignore all
  • D Change
Answer: Option A
Q52
In Excel you can quickly change the appearance of your work by choosing Auto Format from the...............menu
  • A Edit
  • B View
  • C Format
  • D Tools
Answer: Option C
Q53
In Excel ................is a group of cells that form a rectangle on the screen
  • A Calculation
  • B Formula
  • C Range
  • D Range address
Answer: Option C
Q54
In Excel following term describes explanatory text attached to a cell
  • A Callout
  • B Comment
  • C Dialog
  • D Extension
Answer: Option B
Q55
In Excel the drag and drop method of copying or moving
  • A Can be used between worksheets but not workbooks
  • B Can be used between workbooks but not worksheets
  • C Can be used between workbooks but not worksheets
  • D None
Answer: Option C
Q56
In Excel 3-D reference in a formula
  • A Cannot be modified
  • B Only appears on summary worksheets
  • C Limits the formatting options
  • D Spans worksheets
Answer: Option D
Q57
In Excel the auto calculate feature
  • A Can only add values in a range of cells
  • B Provides a quick way to view the results of an arithmetic operation on a range of cells
  • C Automatically creates formulas and adds them to a worksheet
  • D None of the above
Answer: Option B
Q58
In Excel to protect  a worksheet, you can choose protection and the protect sheet from the ...................... menu.
  • A Edit
  • B Format
  • C Tools
  • D Data
Answer: Option C
Q59
In Excel you can open the Highlight Changes dialog box by choosing Track Changes from the ..............menu.
  • A Edit
  • B Insert
  • C Format
  • D Tools
Answer: Option D
Q60
In Excel which of the following is not a worksheet design criterion
  • A Effciency
  • B Auditability
  • C Description
  • D Clarity Correct Answer.
Answer: Option C
Questions and Answers for Competitive Exams Various Entrance Test