OFIICEAUTOMATION_ANILCOMPUTERS

M.S. Excel Quiz in English 1

Total no of Question = 35

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 1

Please enter your email:

1. What function displays row data in a column or column data in a row?

 
 
 
 

2. To create an interactive pivot table for the web, you use a Microsoft office Web component called?

 
 
 
 

3. You can convert existing excel worksheet data and charts to HTML document by using the?

 
 
 
 

4. How can we set Page Border in Excel?

 
 
 
 

5. A spreadsheet contains?

 
 
 
 

6. With which of the following all formulas in excel starts?

 
 
 
 

7. How do you change column width to fit the contents?

 
 
 
 

8. Which among following is associated with excel?

 
 
 
 

9. Which of these will not select all the cell in a document?

 
 
 
 

10. You can check the conditions against…..When applying conditional Formatting?

 
 
 
 

11. How is data organized in a spreadsheet?

 
 
 
 

12. Which function is used for creating a data table?

 
 
 
 

13. Formula palette is used to?

 
 
 
 

14. In MS-EXCEL, for Moves the current selected range down a row, you will press:

 
 
 
 

15. How we can view a cell comment?

 
 
 
 

16. Which of the following is not a valid Zoom percentage in Excel?

 
 
 
 

17. What excel feature can you use if you want to work with one record at a time?

 
 
 
 

18. Which among following is not associated with spelling dialogue box?

 
 
 
 

19. A value used in a formula that does not change is called a?

 
 
 
 

20. Which function calculates your monthly mortage payment?

 
 
 
 

21. To open an existing workbook, click the open button on the …….toolbar?

 
 
 
 

22. Which types of charts can excel produce?

 
 
 
 

23. VLOOKUP function used to?

 
 
 
 

24. On an excel sheet the active cell indicated by?

 
 
 
 

25. You can activate a cell by?

 
 
 
 

26. Which of the following keyboard shortcut can be used for creating a chart from the selected cells?

 
 
 
 

27. The cell reference for a range of cells that start in cell C1 and goes over to column H and down to row 10 is?

 
 
 
 

28. What term describes a background that appears as a grainy, non-smooth surface?

 
 
 
 

29. To insert three columns between columns A and B you would

 
 
 
 

30. To drag a selected range of data to another worksheet in the same workbook, use the?

 
 
 
 

31. What term describes explanatory text attached to a cell?

 
 
 
 

32. Protection and the Protect Sheet options can be selected from?

 
 
 
 

33. A function inside another function is known as?

 
 
 
 

34. Macros can be executed from which of the following menu?

 
 
 
 

35. The default style for new data keyed in new workbooks is?

 
 
 
 

Question 1 of 35

Anil Computers

Anil Computers

Best computer Institute in Udaipur

Quiz_Anilcomputers1

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


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