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. Which of the following is not a valid data format in MS Excel?

 
 
 
 

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

 
 
 
 

3. Syntax of Average function is =Aver ()

 
 

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

 
 
 
 

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

 
 

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

 
 
 
 

7. We cannot use nested function in Microsoft Excel.

 
 

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

 
 

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

 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 

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

 
 

17. We cannot hide column in Microsoft Excel.

 
 

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

 
 

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

 
 

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

 
 
 
 

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

 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 

26. We cannot delete worksheet in MS excel.

 
 

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

 
 
 
 

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

 
 

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

 
 

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

 
 

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

 
 
 
 

Question 1 of 31

Anil Computers

Anil Computers

Best computer Institute in Udaipur

Quiz_Anilcomputers1

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