Welcome to your Microsoft Excel Set - 2
1.
Show/Hide Gridlines option is available in the ____ Menu.
2.
Under which Tab, the chart options are available in MS Excel?
3.
Which Excel function is used to get the discount rate for security?
4.
Which option allows you to display all numbers which are less than 0 (negative numbers) in red color in MS Excel?
5.
What is the correct value of the function? =ROUND (1.9867,2)
6.
Which feature is used to rotate the text diagonally or vertically of the selected cells in MS Excel?
7.
In MS Excel, 'Merge and Center' is used to ____.
8.
Which chart type is used to show trends over time and categories?
9.
What is the keyboard shortcut to insert a new sheet in the current workbook in MS Excel?
10.
Which function is used to remove extra spaces from the text in MS Excel?
11.
The currently selected cell address is displayed in ____.
12.
What is the correct value of the function? =ROUND (1.2345,2)
13.
Which keyboard shortcut is used to apply 'Wrap Text' on the selected text?
14.
Which is not a Text function in MS Excel?
15.
Which function is used to get the location of text in a string in MS Excel?
16.
Under which menu, we can insert Header and Footer on the sheet?
17.
Which function is used to match multiple values and returns the first match?
18.
Steps for protecting a sheet by password in MS Excel?
19.
Which programming language is used to write a Macro in MS Excel?
20.
Which chart type is used to visually compare values across a few categories?
21.
The ____ function is used to convert to text in a number format in MS Excel.
22.
Which feature is used to wrap extra-long text into multiple lines in MS Excel?
23.
Which function is used to create a date with year, month, and day?
24.
Which chart type is used to show the proportions of a while?
25.
What is the keyboard shortcut to insert a new comment in a cell in MS Excel?
