Microsoft Excel MCQ Question and Answer

Microsoft Excel MCQ Question and Answer
101. All formula in excel start with
  • &percent;
  • +
  • =
  • -
Show Answer
102. 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 ?
  • & (ampersan (D)
  • = (equal sign)
  • (space)
  • All of the above
Show Answer
103. In Excel divide symbol is
  • /
  • D
  • \
  • )
Show Answer
104. In Excel to add two cells (A1 and A2) together you use the following formula
  • = A1 + A2
  • =Add (A1 + A2)
  • =together(A1:A2)
  • A1 plus A2
Show Answer
105. In Excel on an excel sheet the active cell in indicated by
  • A dark wide boarder
  • A dotted border
  • A blinking border
  • None of above
Show Answer
106. In Excel on an Excel sheet the active cell in indicated by
  • A dark wide border
  • A dotted border
  • A blinking border
  • None of above
Show Answer
107. In Excel using the F11 shortcut key to create a chart on chart sheet creates
  • A default chart
  • A 2-dimensional column chart
  • A 2-dimensional bar chart
  • A 3-dimensional line chart
Show Answer
108. In Excel you can print
  • A range of cells by range name
  • An entire worksheet
  • A single worksheet
  • All of the above
Show Answer
109. In Excel you can create only a horizontal page break by first selecting
  • A row below the row where you want the page break to occure
  • A cell in row 1
  • A cell in column A
  • (A) and (C)
Show Answer
110. In Excel you can create hyperlinks from excel workbook to
  • A webpage on company internet
  • A web page on the internet
  • Other office application documents
  • All
Show Answer
Questions and Answers for Competitive Exams Various Entrance Test