Simplified guide of MCQs for Exams, Interviews

Sub Topic: Excel

1 .  What is the intersection of a column and a row on a worksheet called ?

  • A. Column
  • B. Value
  • C. Cell
  • D. Address

Correct Answer:

Cell


2 .  What type of chart is useful for comparing values over categories ?

  • A. Pie Chart
  • B. Line Chart
  • C. Column Chart
  • D. Dot Graph

Correct Answer:

Column Chart


3 .  Which function in Excel tells how many numeric entries are there ?

  • A. NUM
  • B. COUNT
  • C. CHKNUM
  • D. SUM

Correct Answer:

COUNT


4 .  A features that displays only the data in column (s) according to specified criteria

  • A. Sorting
  • B. Pivot
  • C. Formula
  • D. Filtering

Correct Answer:

Filtering


5 .  Statistical calculations and preparation of tables and graphs can be done using

  • A. Adobe Photoshop
  • B. Excel
  • C. Power Point
  • D. Notepad

Correct Answer:

Excel


6 .  What type of chart will you use to compare performance of two employees in the year 2016 ?

  • A. Column Chart
  • B. Line Chart
  • C. Pie Chart
  • D. Dot Chart

Correct Answer:

Line Chart


7 .  Which one is not a Function in MS Excel ?

  • A. SUM
  • B. AVG
  • C. MAX
  • D. MIN

Correct Answer:

AVG


8 .  Functions in MS Excel must begin with ___

  • A. An () sign
  • B. An Equal Sign
  • C. A Plus Sign
  • D. A > Sign

Correct Answer:

An Equal Sign


9 .  Which function in Excel checks whether a condition is true or not ?

  • A. SUM
  • B. COUNT
  • C. IF
  • D. AVERAGE

Correct Answer:

IF


10 .  In Excel, Columns are labelled as ___

  • A. A, B, C, etc
  • B. 1,2,3 etc
  • C. A1, A2, etc.
  • D. $A$1, $A$2, etc.

Correct Answer:

A, B, C, etc