No. of questions - 26
Time - 15 min
1.
Which ribbon tab in Excel contains options for formatting cells?
2.
Which function is used to find the sum of complex numbers in MS Excel?
3.
Which of the following is NOT a valid data type in Excel?
4.
Show/Hide Gridlines option is available in the ____ Menu.
5.
Which option is used to hide/show the Headings in MS Excel?
6.
Which option displays the total number of cells, formulas, charts, tables, sheets, etc. in a Workbook?
7.
Which function is used to determine the number of days between two dates in Excel?
8.
Which function is used to round a number up to the nearest integer in Excel?
9.
Which of the following is NOT a valid reference type in Excel?
10.
What does the VLOOKUP function do in Excel?
11.
Which of the following is used to add a new worksheet in Excel?
12.
Which feature is used to filter and sort data in Excel?
13.
Which function is used to remove extra spaces from the text in MS Excel?
14.
Which function can be used to find the highest value in a range of cells?
15.
Which feature is used to highlight cells based on specified criteria in Excel?
16.
Which keyboard shortcut is used to insert the current date in Excel?
17.
Which keyboard shortcut is used to copy cell contents in Excel?
18.
Which of the following is NOT a valid Excel chart type?
19.
What is the file extension for a Microsoft Excel workbook?
20.
Under which menu, we can insert Header and Footer on the sheet?
21.
What does the COUNTIF function do in Excel?
22.
Which of the following is used to freeze panes in Excel?
23.
Which of the following is used to perform calculations in Excel?
24.
Which function is used to count the number of cells that meet a specific condition in Excel?
25.
Which of the following is NOT a valid data analysis tool in Excel?
26.
What does the CONCATENATE function do in Excel?
