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