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.

Which one of the following functions is not found in MS Excel?

A. Max
B. Min
C. Mean
D. Median

Explanation:
MEAN is not a built-in function (use AVERAGE instead).

A ____ is a dynamic mathematical calculation that displays a single value for a specific field.

A. Format row
B. Criteria row
C. Aggregate function
D. Format layout

Explanation:
Aggregate functions (SUM, AVERAGE, COUNT, etc.) calculate a single summary value.

In MS Excel, a data series is related to ____.

A. Collection of Series data
B. Collection of formulas
C. Collection of metadata
D. All of these

Explanation:
A data series is a collection of related data points plotted on a chart.

Formatting a cell in Currency, you can specify ____.

A. Decimal Places
B. Currency Symbol
C. Both A & B
D. None of these

Explanation:
Currency formatting lets you set both the symbol and the number of decimal places.

Two common wildcard characters that Excel accepts/recognizes are ____.

A. *And?
B. + and -
C. / and \
D. > and <

Explanation:
Asterisk (*) and question mark (?) are the standard wildcards in Excel.

Which of the following can you paste selectively using the Paste Special Command?

A. Formulas
B. Validation
C. Formats
D. All of these

Explanation:
Paste Special allows the selective pasting of formulas, validation rules, formats, etc.

Two cells are mixed with a ____.

A. Merge cell
B. Combine cell
C. Unify cell
D. None of these

Explanation:
The Merge Cells command combines two or more cells into a single cell.

Border can be applied on____.

A. Paragraph
B. Text
C. Cell
D. All of these

Explanation:
Borders can be applied to paragraphs, text, and cells in MS Office applications.

What does the =Proper(TEXT) function do in MS Excel?

A. First letter of each word is capitalized
B. First letter of the sentence is capitalized
C. All letters are capitalized
D. None of the above

Explanation:
PROPER converts the first letter of each word in a text string to uppercase.

What is the shortcut key to quickly insert a new workbook in Excel?

A. Shift+Enter
B. Alt+Enter
C. Control
D. Shift + A

Explanation:
The document marks Alt+Enter, but the standard shortcut is Ctrl + N.

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.