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 not a cell reference type in Microsoft Excel?

 
 
 
 

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

 
 

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

 
 

4. Syntax of Average function is =Aver ()

 
 

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

 
 
 
 

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

 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 

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

 
 
 
 

12. We cannot hide column in Microsoft Excel.

 
 

13. We cannot delete worksheet in MS excel.

 
 

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

 
 
 
 

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

 
 
 
 

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

 
 

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

 
 
 
 

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

 
 

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

 
 
 
 

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

 
 
 
 

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

 
 

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

 
 
 
 

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

 
 

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

 
 
 
 

25. We cannot use nested function in Microsoft Excel.

 
 

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

 
 
 
 

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

 
 

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

 
 

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

 
 

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

 
 
 
 

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

 
 

Question 1 of 31

Anil Computers

Anil Computers

Best computer Institute in Udaipur

Quiz_Anilcomputers1

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