Ms excel Solved Question and Answer

Macro helps you to do automation? 

A. True

B. False

When we use power pivot in Ms excel do we need to create raw dump in Table format? 

A. True

B. False

What is the full form of .XLS in Ms Excel? 

A. Xerbia L size

B. Extended large sheet

C  Extended lack sheet

D. Extended large sh

In Ms Excel Which function helps you to create _______ well organized table

A. Table

B. Average

C. Sum

D. B and C both

In MS-Excel which functions will calculate the number of workdays between 6/9/2013 and 8/12/2013

A. workday

B. Today

C. Weekday

D. Yesterday

What is the intersection of a column and a row on a worksheet called ?

A.Column

B.Value

C.Address

D.Cell

features that displays only the data in column (s) according to specified criteria

A.Formula

B.Sorting

C.Fiiltering

D.Pivot

 MS-Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ........... menu

A.Edit

B.Format

C.Tools

D.Alll of the above