OFIICEAUTOMATION_ANILCOMPUTERS

M.S. Excel Quiz in 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 a logical function in Microsoft Excel?

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 

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

 
 
 
 

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

 
 

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

 
 

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

 
 
 
 

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

 
 

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

 
 

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

 
 
 
 

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

 
 

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

 
 

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

 
 
 
 

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

 
 
 
 

16. We cannot use nested function in Microsoft Excel.

 
 

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

 
 

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

 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

22. We cannot delete worksheet in MS excel.

 
 

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

 
 
 
 

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

 
 
 
 

25. Syntax of Average function is =Aver ()

 
 

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

 
 
 
 

27. We cannot hide column in Microsoft Excel.

 
 

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

 
 

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

 
 
 
 

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

 
 

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

 
 

Question 1 of 31

Anil Computers

Anil Computers

Best computer Institute in Udaipur

Quiz_Anilcomputers1

सर्टिफिकेट  पाने के लिए अपने रिजल्ट का Screen shot नीचे दिये गये मोबाइल नम्बर पर send करें। Strictly call not allowed.