Computer Science MCQs

MS Excel Questions with solutions MCQs

1. Which of the following statements is correct regarding the `Number` type formatting of cells in MS-Excel 2007?

A

30 is the maximum value for decimal places.

B

4 is the default value for decimal places.

C

The 1000 separator is a feature that places a comma after each digit.

D

1 is the minimum value for decimal places.

MS Excel Data Entry Operator 2023
Correct Answer : B
Explanation :

Default decimal places in Excel=2 (check mismatch).

Correct Answered :

Wrong Answered :

2. What is the function of =COUNTIF( ) in Excel?

A

Counts cells as specified

B

Counts blank cells in a range

C

Returns values based on a TRUE or FALSE condition

D

Counts cells with numbers in a range

MS Excel Junior Assistant 2024
Correct Answer : A
Explanation :

COUNTIF counts cells meeting a specific condition.

Correct Answered :

Wrong Answered :

3. _____ is the programming language used to write a Macro in MS Excel.

A

VB Script

B

Python

C

C++

D

Java

MS Excel Junior Assistant 2024
Correct Answer : A
Explanation :

Macros in Excel are written in VBA (VB Script).

Correct Answered :

Wrong Answered :

CONTACT US

  • J & K

  • admin@prepmart.in

  • VISITORS COUNT 1 1 2 8 9 8 3
    Developed By : PrepMart