No. of questions - 20
Time - 10 min
Negative marking : -0.25 mark
1.
What is the keyboard shortcut to insert a SUM formula in MS Excel ?
2.
The total number of columns in a worksheet?
3.
Microsoft Excel is used for?
4.
What is the extension of a Microsoft Excel file?
5.
The total number of characters that a cell contains is?
6.
What is the collection of worksheets called?
7.
What is the keyboard shortcut to copy the value from the cell above the active cell into the cell or the Formula Bar in MS Excel ?
8.
Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not ?
9.
Which logical function returns TRUE if one or more arguments evaluates to TRUE; FALSE if all arguments evaluate to FALSE ?
10.
What is the keyboard shortcut to switch between open Excel windows ?
11.
How many users can open the Excel file at the same time ?
12.
What is the default file name of Microsoft Excel file?
13.
Excel is a ____ program developed by Microsoft.
14.
What is the keyboard shortcut to display the Format Cells dialog box in MS Excel ?
15.
What is the column width in a worksheet?
16.
The intersection of a column and a row in a worksheet is called ____.
17.
The total number of rows in a worksheet?
18.
Shortcut key CTRL + D is used to ____.
19.
How many times undo levels can be used in a worksheet ?
20.
How many hyperlinks can be there in a worksheet ?
