Microsoft Excel Mcqs

In a computer spreadsheet, first part of number format describes __________ ?

A. Positive number
B. Negative number
C. Zero values
D. Text values

In a computer spreadsheet, value of formula (7-3)x(1+6)/4 is __________ ?

A. 7
B. 1.5
C. 2
D. 12

In a computer, element which is not a part of chart is ___________ ?

A. Plot area
B. Fill handler
C. Series
D. Chart area

Computer spreadsheet capability to allow a pie chart to be generated from data in spreadsheet cells is termed as __________ ?

A. Decoration
B. Data appearance
C. Functions
D. Charting

The term chart wizard data in MS is refer to_________?

A. Vertical axis
B. Horizontal axis 
C. Bar data
D. None of these

which of the following is not a valid Zoom percentage in Excel?A. 10
B. 100
C. 300
D. 500

Minimum zooming is 10% and Maximum zooming allowed is 400%. So, 500% is invalid zoom percentage in Excel

 

in MS-Excel__________ short cut key is used for hiding rows.A. Ctrl+H
B. Ctrl+7
C. Ctrl+9
D. None of the above

There are several dedicated keyboard shortcuts to hide and unhide rows and columns.
Ctrl+9 to Hide Rows.
Ctrl+0 (zero) to Hide Columns.
Ctrl+Shift+( to Unhide Rows.
Ctrl+Shift+) to Unhide Columns – If this doesn’t work for you try Alt,O,C,U (old Excel 2003 shortcut that still works).

 

In Ms Excel, which of the following special function keys allow the content in cell?A. Shift
B. Esc
C. Tab
D. Space

 

Which Operation can’t be performed by Queue?A. Insertion
B. Deletion
C. Retrieving
D. Traversing 

 

In excel columns are labelled as____________?A. A, B, C, etc.
B. 1, 2, 3, etc.
C. A1, A2, A3, etc.
D. $A$1, $A$2, etc.