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.

In Excel, the chart wizard ____.

A. Can place a chart on a new sheet or on any sheet in the workbook
B. Can only place a chart on a new blank worksheet
C. Can only be used to create embedded charts
D. None of these (but document marks A)

Explanation:
The Chart Wizard (or Insert Chart) allows placing the chart either embedded on the current sheet or on a separate new sheet.

The chart wizard term data categories refers to ____.

A. A chart plot area
B. A horizontal axis
C. The organization of the individual values with a chart’s data series
D. The data range that supplies chart data

Explanation:
Data categories in Excel charts refer to the labels along the horizontal (category) axis.

In MS Excel, the Insert tab includes ____.

A. Chart
B. Alignment
C. Style
D. All of these

Explanation:
The Insert tab in Excel primarily provides options for inserting charts, tables, illustrations, and other objects.

To insert a blank embedded Word object in Excel, ____.

A. Click the object command on the Insert menu
B. Click the link button on Format Painter
C. Click the link button on the standard toolbar
D. None of these

Explanation:
The Object command (Insert → Object) lets you embed a blank Word document inside Excel.

If you want to compare the performance of two employees in 2016, which chart will you use?

A. Pivot Chart
B. Pie Chart
C. Line Chart
D. Column Chart

Explanation:
Line charts are ideal for showing trends and comparing performance over time.

A ____ is a representation of a frequency distribution by means of rectangles whose widths represent class intervals and whose areas are proportional to the corresponding frequencies.

A. Pictograph
B. Histogram
C. Pie Chart
D. Bar Chart

Explanation:
A histogram uses adjacent rectangles to show frequency distribution.

How can we view a cell comment?

A. Position the mouse pointer over the cell
B. Click the edit comment command on the Insert menu
C. Click the display comment on the window menu
D. None of these

Explanation:
Hovering the mouse over a cell with a comment shows the comment.

How to duplicate values in a cell range in MS-Excel 2016?

A. Select the range of cells in the worksheet
B. Click the conditional formatting button in the Styles group of the Home tab
C. Both A and B
D. None of these

Explanation:
Duplicate values can be highlighted using Conditional Formatting → Highlight Cells Rules → Duplicate Values.

In MS Excel 2016, the “Conditional Formatting” option is available in the ____ menu.

A. Insert
B. Page Layout
C. Formulas
D. Home

Explanation:
Conditional Formatting is located on the Home tab.

Which button do you click to add up a series of numbers?

A. AutoSum
B. Formula Button
C. Total Button
D. None of these

Explanation:
The AutoSum button (Σ) quickly inserts the SUM function.

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.