Microsoft Excel Mcqs

In a computer spreadsheet, block of cells is called __________ ?

A. Workbook
B. Function
C. Column
D. Range

In a computer spreadsheet, which is true if current or active cell is B4 and you pressed Enter key?

A. you will be in the cell A1
B. you will be in the cell B5
C. you will be in the cell B3
D. you will be in the cell B6

Title bar in MS-Excel displays name of the __________ ?

A. Worksheet
B. Workbook
C. Formula
D. Location

In a computer spreadsheet, function which is used to count numbers of entries in given range is called __________ ?

A. Length
B. Counter
C. Counting
D. Count

Main window in a computer spreadsheet is called ___________ ?

A. Work book
B. Work
C. Account book
D. Work sheet

Which of the following will not enter data in a cell?A. Pressing the Esc key
B. Pressing the Tab Key
C. Both of these
D. None of above

 

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

A. A3-G3
B. A3:G3
C. A3?.G3
D. A3 to G3

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

A. Calculations
B. Formulas
C. Functions
D. Relative addressing

In a computer spreadsheet, each cell contain a __________ ?

A. label
B. Value
C. Formula
D. All of these

Actual working area of Computer’s Microsoft Excel is ________ ?

A. Workbook
B. Worksheet
C. Notesheet
D. Notebook