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