MS Excel MCQs

Question 1

Which function is not available in the Consolidate dialog box?

Accepted Answer

Pmt

Answer

Average

Answer

Max

Answer

Sum

Question 2

Which is not the function of "Edit, Clear" command?

Accepted Answer

Delete cells

Answer

Delete contents

Answer

Delete notes

Answer

Delete formats

Question 3

Microsoft Excel is a powerful ________

Accepted Answer

Spreadsheet package

Answer

Word processing package

Answer

Communication S/W Package

Answer

DBMS package

Question 4

How do you rearrange the data in ascending or descending order?

Accepted Answer

Data, Sort

Answer

Data, Form

Answer

Data, Table

Answer

Data Subtotals

Question 5

Which Chart can be created in Excel?

Accepted Answer

All of the above

Answer

Area

Answer

Line

Answer

Pie

Question 6

What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ?

Accepted Answer

5436.8

Answer

5430

Answer

6.8

Question 7

How do you display current date and time in MS Excel?

Accepted Answer

Now ()

Answer

Date ()

Answer

Today ()

Answer

Time ()

Question 8

How do you display current date only in MS Excel?

Accepted Answer

Today ()

Answer

Date ()

Answer

Now ()

Answer

Time ()

Question 9

How do you wrap the text in a cell?

Accepted Answer

Format, cells, alignment

Answer

Format, cells, font

Answer

Format, cells, protection

Answer

Format, cells, number