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. Adjustment of column size in Excel is not possible.

 
 

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

 
 
 
 

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

 
 
 
 

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

 
 

5. We cannot hide column in Microsoft Excel.

 
 

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

 
 
 
 

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

 
 
 
 

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

 
 

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

 
 

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

 
 

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

 
 

12. We cannot use nested function in Microsoft Excel.

 
 

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

 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 

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

 
 

19. We cannot delete worksheet in MS excel.

 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 

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

 
 

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

 
 
 
 

31. Syntax of Average function is =Aver ()

 
 

Question 1 of 31

Anil Computers

Anil Computers

Best computer Institute in Udaipur

Quiz_Anilcomputers1

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