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

Which one is an example of spreadsheet software?

1. MS Word
2. MS Excel
3. MS PowerPoint
4. MS Power BI

A worksheet in Excel is divided into:

1. Height & Width
2. Layers & Planes
3. Columns & Rows
4. Lines & Spaces

The column heading in the spreadsheet are identified by ____?

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