No. of questions - 30
Time - 15 min
1.
Which feature in Excel is used to sort data in a specific order?
2.
Which function is used to find the largest integer less than or equal to a given number in Excel?
3.
Which feature in Excel allows you to view and edit formulas instead of their calculated results?
4.
What does the COUNT function do in Excel?
5.
What does the PMT function do in Excel?
6.
Which keyboard shortcut is used to insert a new worksheet in Excel?
7.
Which of the following is NOT a valid chart type in Excel?
8.
Which of the following is NOT a valid data type in Excel?
9.
What does the SUMIF function do in Excel?
10.
Which keyboard shortcut is used to insert the current time in Excel?
11.
Which keyboard shortcut is used to select the entire column in Excel?
12.
Which function is used to find the highest value in a range of cells in Excel?
13.
What is the shortcut key to undo the last action in Excel?
14.
What does the IFERROR function do in Excel?
15.
Which keyboard shortcut is used to paste the contents of the clipboard in Excel?
16.
What does the VLOOKUP function do in Excel?
17.
What does the CONCATENATE function do in Excel?
18.
What does the IF function do in Excel?
19.
Which keyboard shortcut is used to insert a new column in Excel?
20.
Which function is used to find the average value in a range of cells in Excel?
21.
Which function is used to calculate the square root of a number in Excel?
22.
Which of the following is used to change the width of a column in Excel?
23.
What does the CONCAT function do in Excel?
24.
What does the COUNTBLANK function do in Excel?
25.
Which of the following is used to change the font color of a cell in Excel?
26.
Which function is used to convert a text string to uppercase in Excel?
27.
Which keyboard shortcut is used to save a workbook in Excel?
28.
Which of the following is used to add a new row in Excel?
29.
Which of the following is used to find the average value in a range of cells in Excel?
30.
What does the COUNTA function do in Excel?
