🏠 Home
← Back Start Quiz
MCQ Practice

Computer & IT MCQs

MS Excel will not be able to calculate which of the following formulae?

  • A. =SUM(Sales)-A5
  • B. =SUM(A1:A5)/5
  • C. =SUM(A1:A5)*(10)
  • D. =SUM(A1:A5)-10
Explanation:
“Sales” is not a valid cell reference or defined name, so Excel cannot calculate it.

To create a formula, you first ____

  • A. Select the cell you want to place the formula into
  • B. Type the equals sign (=) to tell Excel that you are about to enter a formula
  • C. Enter the input values and the appropriate operators that make up your formula
  • D. Choose the new command from the file menu
Explanation:
Every Excel formula must begin with an equals sign (=).

In MS Excel, a mathematical formula contains ____.

  • A. Label
  • B. Numeric Value
  • C. Both A & B
  • D. None of these
Explanation:
Excel formulas can use both labels (cell references) and numeric values.

The best orientation to fit maximum columns on a single sheet for print is ____.

  • A. Portrait
  • B. Landscape
  • C. Both portrait and Landscape
  • D. None of these
Explanation:
Landscape orientation provides more horizontal space for columns.

In MS Excel 2016, mainly ____ types of “Page Orientation” are available.

  • A. 2
  • B. 3
  • C. 4
  • D. None of these
Explanation:
There are only two page orientations: Portrait and Landscape.

In MS Excel 2016, one has to go to which option for setting or clearing the print area?

  • A. Insert
  • B. Page Layout
  • C. Data
  • D. Review
Explanation:
Print Area settings are found under the Page Layout tab.

In MS Excel 2016, the “Pivot Tables” option is available in the ____ menu.

  • A. Review
  • B. View
  • C. Insert
  • D. Page Layout
Explanation:
PivotTables are inserted from the Insert tab.

The graph used to show data on a nominal scale is called ____.

  • A. Line graph
  • B. Pie graph
  • C. Speed graph
  • D. None of these
Explanation:
Pie graphs are ideal for showing parts of a whole on a nominal/categorical scale.

Which type of chart is for categorical data ____.

  • A. Pie chart
  • B. Histogram
  • C. Maps
  • D. Vertical bar
Explanation:
Vertical bar (column) charts are best suited for comparing categorical data.

Graphical representation of data is called ____.

  • A. Pie chart
  • B. Scatter plot
  • C. Line chart
  • D. Bar Chart
Explanation:
All listed options are types of charts; the general term for a graphical representation is "chart" (Bar Chart is one example, but the document selects D as representative).