MCQ

# MS Excel MCQ Questions and Answers – Part 2

MS Excel MCQ questions and answers for the preparation of tests, exams, and certifications. So you will find questions about the Workbook, Menu bar, Toolbar, Column headings, Row headings, Name box, Formula bar, and much more. This systematic learning method will easily prepare anyone to pass their exam.

A Fill in

B Correction

C AutoSum

D Format

C

###### 2. To select an entire column in MS-EXCEL, you click on ________?

A CTRL + C

B CTRL + Arrow

C CTRL + S

D None of the above

D
Select the letter at the top to select the entire column. Or click on a cell in the column and press Ctrl + Space.

###### 3. To return the remainder after dividing a number, we use the ________ function.

A ROUND()

B FACT()

C MOD()

D DIV()

C
Example: =MOD(3;2) returns the remainder of the division of 3 by 2.

A Pmt

B Average

C Max

D Sum

A

###### 5. Microsoft Excel is a powerful __________

A Word processing software

B Mathematical visualization tool

C Communication package

D DBMS Package

B

###### 6. How to sort the data in ascending or descending order?

A Data -> Sort

B Data -> form

C Data -> table

D Subtotal of data

A

###### 7. What chart can be created in Excel?

A Zone

B Line

C Pie

D All the answers are true

D

A =DATE()

B =TODAY()

C =NOW()

D =TIME()

C

A =DATE()

B =TODAY()

C =NOW()

D =TIME()

B

###### 10. What does the =NBVAL() function do??

A Count cells with alphabets

B Count empty cells

C Count cells with numbers

D Count non-empty cells

D

MCQPractice competitive and technical Multiple Choice Questions and Answers (MCQs) with simple and logical explanations to prepare for tests and interviews.Read More