MS Excel MCQs

Which function in excel tells how many numeric entries are there?

1. NUM
2. COUNT
3. SUM
4. CHKNUM​

In a computer spreadsheet, cell range A3 through G3 should be keyed is as?

1. A3-G3
2. A3:G3
3. A3: G3
4. A3 to G3

in a computer spreadsheet, SUM, AVERAGE, MIN and MAX are examples of?

1. calculation
2. formulas
3. functions
4. relative addressing

How columns are numbered in MS Excel ?

1. numeric
2. alphabetic
3. roman
4. None

The actual working area of the Computer's Microsoft Excel is?

1. workbook
2. worksheet
3. note sheet
4. notebook

How are data organized in a spreadsheet ?

1. Lines and spaces
2. Layers and planes
3. Rows and columns
4. Height and width

What term describes explanatory text attached to a cell?

1. Context
2. Callout
3. Comment
4. Dialog

The column heading in the spreadsheet are identified by:

1. Alphabets
2. Numbers
3. Symbels
4. None of these