No. of questions - 25
Time - 10 min
Negative marking : -0.25 mark
1.
Which keyboard shortcut is used to apply 'Wrap Text' on the selected text?
2.
What is the keyboard shortcut to display the Format Cells dialog box in MS Excel ?
3.
What is the keyboard shortcut to insert a SUM formula in MS Excel ?
4.
Under which menu, we can insert Header and Footer on the sheet ?
5.
Which option allows you to display all numbers which are less than 0 (negative numbers) in red color in MS Excel?
6.
What is the keyboard shortcut to switch between open Excel windows ?
7.
Which chart type is used to show the proportions of a while?
8.
Which Excel function is used to get the discount rate for security?
9.
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 ?
10.
Show/Hide Gridlines option is available in the ____ Menu.
11.
Which function is used to find the sum of complex numbers in MS Excel?
12.
What is the keyboard shortcut to insert a new sheet in the current workbook in MS Excel?
13.
Which feature is used to rotate the text diagonally or vertically of the selected cells in MS Excel?
14.
Under which Tab, the chart options are available in MS Excel?
15.
The currently selected cell address is displayed in ____.
16.
Which option displays the total number of cells, formulas, charts, tables, sheets, etc. in a Workbook?
17.
What is the correct value of the function? =ROUND (1.9867,2)
18.
Which function is used to remove extra spaces from the text in MS Excel?
19.
Which feature is used to wrap extra-long text into multiple lines in MS Excel?
20.
In MS Excel, 'Merge and Center' is used to ____.
21.
What is the keyboard shortcut to insert a new comment in a cell in MS Excel?
22.
Steps for protecting a sheet by password in MS Excel?
23.
What is the correct value of the function? =ROUND (1.2345,2)
24.
What is the keyboard shortcut to copy a formula from the cell above the active cell into the cell or the Formula Bar in MS Excel?
25.
Which chart type is used to visually compare values across a few categories?
