MCQ Practice

Computer & IT MCQs

Practice MCQs with Confidence - Our Platform Filters Out Duplicate MCQs so You Always Get Fesh and Unique Questions for Smart Preparation.

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).

Practice Important Questions

This section provides important MCQs with answers and explanations to help candidates prepare effectively for CSS, PMS, and other competitive exams.

Improve Conceptual Understanding

Each MCQ is designed to strengthen your understanding of key concepts and improve analytical thinking required in exams.

Exam-Oriented Preparation

These MCQs follow actual exam patterns, helping aspirants practice relevant questions and improve performance.

Useful for CSS and PMS Exams

This collection is highly beneficial for CSS, PMS, and other competitive exams, improving accuracy and confidence.