Microsoft Excel Questions and Answers

Practice Mode
Showing 10 of 255 questions
Q191
In Excel which of the following is not a valid data type in excel
  • A Number
  • B Character
  • C Label
  • D Data/time
Answer: Option B
Q192
Excell worksheet cells work very similarly to what ommon element of the windows graphical user interface
  • A Option buttons
  • B List boxes
  • C Text boxes
  • D Combo boxes
Answer: Option C
Q193
In Excel which of the following options is not located in Page Setup Dialog box ?
  • A Page Break Preview
  • B Page Orientation
  • C Margins
  • D Headers and Footers
Answer: Option A
Q194
In excel one want to track the progress of the stck market on a daily basis. which type of charts should  one use ?
  • A Pie chart
  • B Row chart
  • C Line chart
  • D Column chart
Answer: Option C
Q195
In excel without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a speradsheet ?
  • A Press Ctrl + Home
  • B press Home
  • C Press Shift + Home
  • D Press Alt + Home
Answer: Option A
Q196
Which of the following methods cannot be used to edit the contents of a cell in Excel ?
  • A Press the alt Key
  • B Clicking the formula bar
  • C Pressing the F2 key
  • D Double clicking the cell
Answer: Option A
Q197
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
  • A Press the Erase key
  • B Press Esc
  • C Press the Enter button
  • D Press the Edit formula button
Answer: Option B
Q198
In Excel defaut style for new data keyed in a new workbook is
  • A Comma
  • B Currency
  • C Normal
  • D Per cent
Answer: Option C
Q199
In Excel LEN function does what ?
  • A Compares the content in two cells
  • B Counts the numbers of characters in a cell
  • C Deletes extra space in text
  • D All of above
Answer: Option A
Q200
In Excel this function onverts miles to kilometers, kilograms to pounds, and so on
  • A Convert
  • B Product
  • C Change
  • D All of above
Answer: Option A
Questions and Answers for Competitive Exams Various Entrance Test