Microsoft Excel Questions and Answers

Practice Mode
Showing 10 of 255 questions
Q101
All formula in excel start with
  • A &percent;
  • B +
  • C =
  • D -
Answer: Option D
Q102
In Excel you can use a function to combine text from two cells into one cell. But you can use an operator to do the same thing. Which operator is that ?
  • A & (ampersan (D)
  • B = (equal sign)
  • C (space)
  • D All of the above
Answer: Option A
Q103
In Excel divide symbol is
  • A /
  • B D
  • C \
  • D )
Answer: Option A
Q104
In Excel to add two cells (A1 and A2) together you use the following formula
  • A = A1 + A2
  • B =Add (A1 + A2)
  • C =together(A1:A2)
  • D A1 plus A2
Answer: Option A
Q105
In Excel on an excel sheet the active cell in indicated by
  • A A dark wide boarder
  • B A dotted border
  • C A blinking border
  • D None of above
Answer: Option A
Q106
In Excel on an Excel sheet the active cell in indicated by
  • A A dark wide border
  • B A dotted border
  • C A blinking border
  • D None of above
Answer: Option A
Q107
In Excel using the F11 shortcut key to create a chart on chart sheet creates
  • A A default chart
  • B A 2-dimensional column chart
  • C A 2-dimensional bar chart
  • D A 3-dimensional line chart
Answer: Option B
Q108
In Excel you can print
  • A A range of cells by range name
  • B An entire worksheet
  • C A single worksheet
  • D All of the above
Answer: Option D
Q109
In Excel you can create only a horizontal page break by first selecting
  • A A row below the row where you want the page break to occure
  • B A cell in row 1
  • C A cell in column A
  • D (A) and (C)
Answer: Option D
Q110
In Excel you can create hyperlinks from excel workbook to
  • A A webpage on company internet
  • B A web page on the internet
  • C Other office application documents
  • D All
Answer: Option D
Questions and Answers for Competitive Exams Various Entrance Test