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.

When you move to the same row but to other columns?

A. To perform a vertical lookup and return a value based on a specified criterion
B. To perform a horizontal lookup and return a value based on a specified criterion
C. To add up a range of cells
D. To find the average of a range of cells

Explanation:
This describes the HLOOKUP function (horizontal lookup).

In Excel, from which tab can you write DOB like this YYYY/MM/DD?

A. View Menu
B. Format Menu
C. Data Menu
D. Insert Menu

Explanation:
Custom date formats (YYYY/MM/DD) are set in the Format Cells dialog under the Number tab.

If a formula references a cell that contains text instead of a numerical value, what error does Excel display?

A. #NUM!
B. #VALUE!
C. #REF!
D. #DIV/0!

Explanation:
#VALUE! An error appears when the formula expects numbers but receives text.

In Excel we added ____ before fraction for not to enter date.

A. S
B. &
C. Space
D. None of these

Explanation:
A leading space forces Excel to treat the entry as text/fraction.

Which is used for fractions, so data in MS-Excel doesn’t read it as a date?

A. S
B. @
C. /
D. Space

Explanation:
Prefixing a fraction with a space prevents Excel from interpreting it as a date.

Which area in an Excel window allows entering values and formulas?

A. Title bar
B. Menu bar
C. Formula bar
D. Standard toolbar

Explanation:
The Formula Bar is the dedicated area for entering and editing content.

In MS Excel, which bar is used for formula and data writing?

A. Menu bar
B. Title bar
C. Formula bar
D. None of these

Explanation:
The Formula Bar is where you view and edit formulas and cell data.

To add Equation in the cell of the MS-Excel, we put ____ first.

A. Addition sign
B. Subtraction sign
C. Equal sign
D. Parenthesis sign

Explanation:
All formulas begin with the equal sign (=).

In Excel, the error message “#Value!” typically means:

A. Invalid Input
B. Calculation Error
C. Data Corruption
D. Low Memory

Explanation:
#VALUE! indicates a problem with the data type used in the formula.

In MS Excel, to create a formula, you can use ____.

A. Cell references, although not both at the same time
B. Cell references with values but not values
C. Values but not cell references
D. Both value and cell references

Explanation:
Formulas can combine cell references and literal values.

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.