MS Excel MCQs

In a new workbook in MS Excel, which one appears on the topmost of the screen?

1. Status Bar
2. Title Bar
3. Vertical Scroll bar
4. Horizontal scroll bar

In MS Excel ready-made templates are available under __ tab in new option.

1. file
2. Count
3. Table
4. none

Which function is not available in the consolidate dialogue box ?

1. Average
2. Max
3. Pmt
4. None

What is the main function of MS Excel?

1. organized data
2. loss data
3. gain data
4. none of these

Excel is a---------program developed by Microsoft.

1. spreadsheet
2. document
3. data management
4. all of the above

MS-Excel uses the _____ function when creating a data table.

1. Average
2. count
3. Both A and B
4. Table

MOD () function is used in MS excel to get

1. Dividend
2. Remainder
3. Quotient
4. None of these

In MS Excel, which function automatically total a column or row of values?

1. SUM
2. ADD
3. TOTAL
4. None

Columns in MS Excel are called?

1. Fields
2. Chart
3. Both
4. None

Constant value in excel also called ?

1. Number
2. words
3. mark
4. None