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. To create an interactive pivot table for the web, you use a Microsoft office Web component called?

 
 
 
 

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

 
 
 
 

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

 
 
 
 

4. VLOOKUP function used to?

 
 
 
 

5. How we can view a cell comment?

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

10. Which types of charts can excel produce?

 
 
 
 

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

 
 
 
 

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

 
 
 
 

13. 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?

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

18. A function inside another function is known as?

 
 
 
 

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

 
 
 
 

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

 
 
 
 

21. How is data organized in a spreadsheet?

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

27. Which among following is associated with excel?

 
 
 
 

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

 
 
 
 

29. A spreadsheet contains?

 
 
 
 

30. How can we set Page Border in Excel?

 
 
 
 

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

 
 
 
 

32. Formula palette is used to?

 
 
 
 

33. You can activate a cell by?

 
 
 
 

34. Which function calculates your monthly mortage payment?

 
 
 
 

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

 
 
 
 

Question 1 of 35

Anil Computers

Anil Computers

Best computer Institute in Udaipur

Quiz_Anilcomputers1

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