Computer Class Test 13

0

MS Excel Class Test

Welcome to your MS Excel Class Test Hope you understand the class & now it's time to examine yourself through test. Remember you have only 10 minutes to complete the class test ,after 10 minutes Class test will be automatically submit.MS Excel क्लास टेस्ट में आपका स्वागत है। आशा है कि आपको क्लास समझ में आ गई होगी और अब टेस्ट के ज़रिए खुद को परखने का समय आ गया है। याद रखें कि आपके पास क्लास टेस्ट पूरा करने के लिए सिर्फ़ 10 मिनट हैं, 10 मिनट के बाद क्लास टेस्ट अपने आप सबमिट हो जाएगा।

1 / 50

1. What is the default file extension for Excel 2016 and later?

2 / 50

2. Which function is used to find the average in Excel?

3 / 50

3. Which of the following is a valid cell reference?

4 / 50

4. Which key is used to edit the active cell?

5 / 50

5. Which function returns the current date and time?

6 / 50

6. What does the SUM function do?

7 / 50

7. How do you start a formula in Excel?

8 / 50

8. Which symbol is used for absolute cell reference?

9 / 50

9. What does Ctrl + Z do in Excel?

10 / 50

10. Which tab contains the Chart options?

11 / 50

11. What is the shortcut for saving a workbook?

12 / 50

12. What does the CONCATENATE function do?

13 / 50

13. What does VLOOKUP stand for?

14 / 50

14. Which function checks for logical conditions?

15 / 50

15. Which chart is best for showing trends over time?

16 / 50

16. What type of chart shows proportions of a whole?

17 / 50

17. How can you freeze the top row in Excel?

18 / 50

18. What is the use of conditional formatting?

19 / 50

19. What does COUNT function do?

20 / 50

20. Which function counts all non-empty cells?

21 / 50

21. Which of the following is a logical function?

22 / 50

22. Which of the following is used to remove duplicate values?

23 / 50

23. What is the maximum number of rows in Excel 2016?

24 / 50

24. What is the shortcut key to insert a new worksheet?

25 / 50

25. What is the keyboard shortcut for AutoSum?

26 / 50

26. Which function finds the largest number in a range?

27 / 50

27. Which function finds the smallest number in a range?

28 / 50

28. What is the default number of worksheets in a new Excel workbook?

29 / 50

29. How do you apply a filter in Excel?

30 / 50

30. What does Ctrl + Arrow Key do?

31 / 50

31. Which of these is a text function?

32 / 50

32. What does the IFERROR function do?

33 / 50

33. What is the default alignment for numbers in Excel?

34 / 50

34. What is the use of the Wrap Text feature?

35 / 50

35. Which tool helps to fill series automatically?

36 / 50

36. What is a cell in Excel?

37 / 50

37. What does Ctrl + F do in Excel?

38 / 50

38. What is a formula in Excel?

39 / 50

39. What does the Merge & Center feature do?

40 / 50

40. What is a Pivot Table used for?

41 / 50

41. Which formula is used for counting cells with a condition?

42 / 50

42. Which function extracts year from a date?

43 / 50

43. Which function extracts text from the beginning of a string?

44 / 50

44. What does the TRIM function do?

45 / 50

45. What does Ctrl + P do?

46 / 50

46. How do you create a chart in Excel?

47 / 50

47. What is the formula to calculate percentage?

48 / 50

48. What is the shortcut to open format cells dialog?

49 / 50

49. What is the fill handle used for?

50 / 50

50. How to remove gridlines in Excel?

Your score is

LinkedIn Facebook Twitter VKontakte

Related Courses

Computer Class Test 11

Computer Class Test 10

Computer Class Test 05

Computer Class Test 09

Computer Class Test 14

Computer Class Test 03