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