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. Macros can be executed from which of the following menu?

 
 
 
 

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

 
 
 
 

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

 
 
 
 

4. You can activate a cell by?

 
 
 
 

5. Which types of charts can excel produce?

 
 
 
 

6. A spreadsheet contains?

 
 
 
 

7. Formula palette is used to?

 
 
 
 

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

 
 
 
 

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

 
 
 
 

10. A function inside another function is known as?

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

15. How is data organized in a spreadsheet?

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

20. How can we set Page Border in Excel?

 
 
 
 

21. VLOOKUP function used to?

 
 
 
 

22. Which among following is associated with excel?

 
 
 
 

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

 
 
 
 

24. Which function calculates your monthly mortage payment?

 
 
 
 

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

 
 
 
 

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

 
 
 
 

27. How we can view a cell comment?

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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.