QUIZ Time Starts !

5 minutes

Thanks you have successfully attempted the quiz.

Excel Intermediate Quiz

Fill out the form to attempt test.

 

 

 

1 / 15

Question 1 of 25:

1. Which of the following is the shortcut key to insert a new worksheet in Excel?

2 / 15

Question 2 of 25:

2. What does the VLOOKUP function do in Excel?

3 / 15

Question 3 of 25:

3. Which of the following functions is used to count the number of cells that are not empty?

4 / 15

Question 4 of 25:

4. Which of the following is the shortcut key to insert a new worksheet in Excel?

5 / 15

Question 5 of 25:

5. How can you freeze the top row of an Excel worksheet?

6 / 15

Question 6 of 25:

6. What is the maximum number of columns available in Excel 2016?

7 / 15

Question 7 of 25:

7. Which of the following is not a valid Excel data type?

8 / 15

Question 8 of 25:

8. How do you remove duplicates from a dataset in Excel?

9 / 15

Question 9 of 25:

9. In Excel, which of the following symbols is used for absolute reference?

10 / 15

Question 10 of 25:

10. How do you apply a filter in Excel?

11 / 15

Question 11 of 25:

11. Which of the following is true about a PivotTable?

12 / 15

Question 12 of 25:

12. What is the purpose of the COUNTIF function in Excel?

13 / 15

Question 13 of 25:

13. How do you add a comment to a cell in Excel?

14 / 15

Question 14 of 25:

14. How do you split the Excel window into multiple panes?

15 / 15

Question 15 of 25:

15. How do you change the font color of a cell in Excel?

Your score is

Learn DA-DS Course in Hindi

Welcome to DADS Course

Email : info@techpratham.com

Phone (India) : +91-8882178896

WhatsApp : +91-8384036614