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