Microsoft Excel Quiz

1. To select an entire column in MS-EXCEL, press?

2. You can zoom a worksheet

3. Which of following is Not one of Excel’s what-if function?

4. Press _____ to bring up search box.

5. The auto calculate feature

6. The name box

7. When you insert an Excel file into a Word document, the data are

8. Weight refers to

9. It is acceptable to let long text flow into adjacent cells on a worksheet when

11. If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you:

12. How can you show or hide the gridlines in Excel Worksheet?

13. In MS Excel, Page border option is available under _______ tab.

14. Excel uniquely identifies cells within a worksheet with a cell name

15. When you link data maintained in Excel workbook to a Word document

16. f you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

17. Which of the following is not a valid data type in excel

18. What symbol is used before a number to make it a label?

19. Which of the following programs enables you to calculate numbers related to rows and columns?

20. To edit data in an embedded Excel worksheet object in a Word document

21. Excel displays the current cell address in ______

22. You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

23. You can use the drag and drop method to

24. Ctrl + D shortcut key in Excel will

25. What does the =NBVAL() function do??

26. Which of the not correct method of editing the cell content

27. Which of the following is the purpose of AutoSum?

28. You can create hyperlink from an excel workbook to

29. Which is used to perform what if analysis?

30. What chart can be created in Excel?

31. Which of the following is used to move an active cell to the first column on the current row?

32. A typical worksheet has ________ Number of columns

33. MS Excel 2019 has row limit of __________

34. Comments can be added to cells using

35. What is the best way to reference cell A10 on sheet 3 from sheet 1?

36. When the CPU detects an interrupt, then it saves its

37. What type of chart will you use to compare performance of two employees in the year 2022 ?

38. You can convert existing excel worksheet data an charts to an HTML document by using

39. The cell level F5 refers to

40. You can merge the main document with data source in Excel. In mail merge operation, Word is usually

41. Microsoft Excel is a powerful __________

42. In A3 cell edit = A1 + A2 refers to

43. What is the intersection of a column and a row on a worksheet called ?

44. You can edit a cell by

45. Hyperlinks cannot be

46. What is the address of the cell in the seventh column of the sixth row in an MS-Excel worksheet?

47. Where can you set the shading color for a range of cells in Excel?

48. Which function is not available in the “Consolidate” dialog box ?

49. Which menu option can be used to split windows into two?

50. How can you remove borders applied in cells?