OFIICEAUTOMATION_ANILCOMPUTERS

Office Automation

Excel Quiz English 7

Total no of Question = 31

All Questionnaire compulsory to answered

Quiz created by :   Anilcomputersudaipur.com

Add: Anil Computers, 368, Prem Kutir, Univestiy Main Road Nr. Tulsi Garden, Udaipur- 094142 34600

M.S Excel Quiz in English 7

Please enter your email:

1. Syntax of Average function is =Aver ()

 
 

2. In MS Excel, if we set text format in a particular cell, we cannot enter number in the same cell.

 
 

3. Which of the following is not a valid date type in Microsoft Excel?

 
 
 
 

4. Table and Chart option is avalible in —– tab in MS Excel.

 
 
 
 

5. Adjustment of column size in Excel is not possible.

 
 

6. Which of the following options represent an accurate list of default tabs you will find on the Microsoft Excel Ribbon?

 
 
 
 

7. Which of following is not a logical function in Microsoft Excel?

 
 
 
 

8. We cannot hide column in Microsoft Excel.

 
 

9. Print preview option in not available in Microsoft Excel.

 
 

10. It is not possible to save and protect the Microsoft Excel Workbook using a password.

 
 

11. In Microsoft Excel, we can check the conditions against —– when applying conditional formatting.

 
 
 
 

12. Syntax of count function is = Count().

 
 

13. Product function is a —– function in Microsoft Excel.

 
 
 
 

14. Which of the following is not a Math & Trig function in Microsoft Excel?

 
 
 
 

15. Which of the following is a correct file extension of MS Excel?

 
 
 
 

16. Which of the following is a logical function in Microsoft Excel?

 
 
 
 

17. Which of the following is not a valid data format in MS Excel?

 
 
 
 

18. Adjustment of column size in Excel is not possible.

 
 

19. In Microsoft Excel, the shortcut key for creating a chart from the selected cell range in F11.

 
 

20. In Microsoft Excel getting data from a cell located in a different sheet is called is________.

 
 
 
 

21. The default worksheet of MS Excel cannot be renamed.

 
 

22. It is not possible to set printing area in Microsoft Excel.

 
 

23. —– is not a date validation option in Microsoft Excel.

 
 
 
 

24. The software which contains rows and columns is called Microsoft Excel Spreadsheet.

 
 

25. We can save excel file by clicking on file tab.

 
 

26. In Microsoft Excel, the shortcut key to hide the Column is Ctrl+H.

 
 

27. We cannot delete worksheet in MS excel.

 
 

28. We cannot use nested function in Microsoft Excel.

 
 

29. Microsoft Excel Worksheet can be renamed by —–.

 
 
 
 

30. In MS excel Bold, Italic and Underline command is available under —– tab.

 
 
 
 

31. Which of the following is not a cell reference type in Microsoft Excel?

 
 
 
 

Question 1 of 31

Anil Computers

Anil Computers

Best computer Institute in Udaipur

Quiz_Anilcomputers1

सर्टिफिकेट  पाने के लिए अपने रिजल्ट का Screen shot नीचे दिये गये मोबाइल नम्बर पर send करें। साथ ही एक बार काॅल जरूर कर लेवें।


Notice: Undefined index: force_wall in /home/waapsols/public_html/anilcomputersudaipur/wp-content/plugins/ocean-extra/includes/widgets/facebook.php on line 155