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.

A reference that remains unchanged after copying is called ____.

A. Absolute Reference
B. Relative Reference
C. Static Reference
D. Dynamic Reference

Explanation:
Absolute references do not change when the formula is copied.

Which of the following is an absolute cell reference?

A. L$A1
B. $A$1
C. #A1
D. None of these

Explanation:
$A$1 is the standard absolute cell reference format.

$ sign in excel formula to ____ row and column.

A. update
B. new
C. fixed
D. duplicate

Explanation:
The $ sign fixes (makes absolute) the row or column reference.

In Excel, if you want to reference a cell in the same column but a different row on another sheet, what type of reference should you use?

A. Absolute reference
B. Relative reference
C. Mixed reference
D. Circular reference

Explanation:
Absolute reference ($A$1) keeps the cell fixed across sheets.

Which symbol is used for an Excel cell reference?

A. +
B. $
C. !
D. None of these

Explanation:
The dollar sign ($) is used to create absolute cell references.

Getting data from a cell located in a different sheet is called ____.

A. Accessing
B. Updating
C. Cell Referencing
D. Functioning

Explanation:
Referring to a cell in another sheet is called external cell referencing.

When you insert an Excel file to a Word document, the Data are ____.

A. Embedded
B. Linked
C. Hyperlinked placed in a Word table
D. None of these

Explanation:
The inserted Excel data is usually linked or embedded; document marks B.

In MS Excel you can use the horizontal and vertical scroll bars to ____.

A. Split a worksheet into two panes
B. View different rows and columns
C. Edit the contents of a cell
D. View different worksheets

Explanation:
Scroll bars allow navigation through rows and columns.

The thin black cross-shaped pointer in MS Excel is used to ____.

A. Complete lists and fill patterns
B. Move a group of cells
C. Resize
D. Highlight duplicate cells

Explanation:
The fill handle (black cross) is used for AutoFill and copying patterns.

In MS Excel, if a numeric value starts with ____ then this value is treated as a label.

A. Hash
B. Equal Sign
C. Apostrophe
D. Title

Explanation:
Prefixing with an apostrophe (') forces Excel to treat the entry as text/label.

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.