Microsoft Excel MCQ Question and Answer

Microsoft Excel MCQ Question and Answer
221. In  worksheet you can select
  • Etire worksheet
  • Rows
  • Columns
  • All of the above
Show Answer
222. When you print priview a worksheet
  • The entire worksheet is displayed
  • The selected range i displayed
  • The active portion of the worksheet is displayed
  • All of the above
Show Answer
223. In Excel to access the Go To Special feature, you an press
  • Ctrl + G
  • Ctrl + O
  • Ctrl + Shift + G
  • Ctrl + 1
Show Answer
224. In Excel whih do you press to enter the current date in a cell ?
  • Ctrl + Shift + :
  • Ctrl +
  • CTrl + F10
  • All of above
Show Answer
225. In Excel it is acceptable to let long text flow into adjacent cells on a worksheet when
  • Data will be entered in the adjacent cells
  • No data will be entered in the adjacent cells
  • There is n suitable abbreviation for the text
  • There is not time to format the text
Show Answer
226. In Excel you can group noncontguus worksheets with
  • The group button on the standard toolbar
  • The shift key and the mouse
  • The Ctrl key and mouse
  • The alt+enter key
Show Answer
227. In Excel Weight refers to
  • The print density of characters
  • The height of the printed character
  • Upright or santed shape
  • The design and appearance of characters
Show Answer
228. When you link data maintained in Excel workbook to a Word document

  • The Word document cannot be edited
  • The Word doument contains a reference to the original source application
  • The word document must contain a hyperlink
  • The word document contains a copy of the actual data
Show Answer
229. In Excel when you see a cell with a red traingle in the top right corner, what does this signify ?
  • There is an error in the cell
  • There is a comment associated with the cell
  • The font color for text in the cell is red
  • A formula cannot be entered into the cell
Show Answer
230. In Excel to hold row and column titles in places  so that they do not scroll when you scroll a work sheet, click the
  • unfreeze panes command on the window menu
  • Freeze panes command on the window menu
  • Hold titles command on the edit menu
  • Split command on the window menu
Show Answer
Questions and Answers for Competitive Exams Various Entrance Test