Microsoft Excel MCQ Question and Answer

Microsoft Excel MCQ Question and Answer
191. In Excel which of the following is not a valid data type in excel
  • Number
  • Character
  • Label
  • Data/time
Show Answer
192. Excell worksheet cells work very similarly to what ommon element of the windows graphical user interface
  • Option buttons
  • List boxes
  • Text boxes
  • Combo boxes
Show Answer
193. In Excel which of the following options is not located in Page Setup Dialog box ?
  • Page Break Preview
  • Page Orientation
  • Margins
  • Headers and Footers
Show Answer
194. In excel one want to track the progress of the stck market on a daily basis. which type of charts should  one use ?
  • Pie chart
  • Row chart
  • Line chart
  • Column chart
Show Answer
195. In excel without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a speradsheet ?
  • Press Ctrl + Home
  • press Home
  • Press Shift + Home
  • Press Alt + Home
Show Answer
196. Which of the following methods cannot be used to edit the contents of a cell in Excel ?
  • Press the alt Key
  • Clicking the formula bar
  • Pressing the F2 key
  • Double clicking the cell
Show Answer
197. In Excel if you begin typingg and entry into a cell and then realize that you don't want your entry placed into a cell, you
  • Press the Erase key
  • Press Esc
  • Press the Enter button
  • Press the Edit formula button
Show Answer
198. In Excel defaut style for new data keyed in a new workbook is
  • Comma
  • Currency
  • Normal
  • Per cent
Show Answer
199. In Excel LEN function does what ?
  • Compares the content in two cells
  • Counts the numbers of characters in a cell
  • Deletes extra space in text
  • All of above
Show Answer
200. In Excel this function onverts miles to kilometers, kilograms to pounds, and so on
  • Convert
  • Product
  • Change
  • All of above
Show Answer
Questions and Answers for Competitive Exams Various Entrance Test