Microsoft Excel Quiz

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

2. Data can be arranged in a worksheet in a easy to understand manner using

3. Comments can be added to cells using

4. When you group worksheets

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

6. Which of the following is not information you can specify using the solver?

7. Press the ______ key to move the insertion point to the first cell in a row in Excel.

8. The “Spelling” dialog box can be accessed by choosing “Spelling” from the ________.

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

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

11. How are data organized in a spreadsheet?

12. when you use the fill effects in the format data series dialog box, you can not

13. The default file extension of MS Excel is

14. Which of the following describes how to select all the cells in a single column?

15. Which of the following formulas is not entered correctly?

16. How many worksheets can a workbook have?

17. Which of the following is not information you can specify using the solver?

18. A function inside another function is called….

19. Which functionin Excel tells how many numeric entries are there ?

20. What is the shortcut key to insert new sheet in current workbook?

21. You can add an image to a template by clicking the Insert Picture From File button on the ............. Toolbar.

22. To center worksheet titles across a range of cell, you must

23. You can use the format painter multiple times before you turn it off by

24. A worksheet range is a

25. A numeric value can be treated as label value if ……………. precedes it.

26. which function will calculate the number of workdays between 6/9/2004 and 8/12/2004?

27. In a worksheet you can press Shift+ Space to select entire

28. MS Excel file can NOT be directly exported as ______

29. Which of the following shortcuts can be used to insert a new line in the same cell?

30. Press _____ to select all rows and columns in the worksheet.

31. When creating a vertical page break

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

34. A worksheet range is a

35. You can group non-contiguous worksheets with

36. You can select a single range of cells by

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

38. When you want to insert a blank embedded excel object in a word document you can

39. when you work with large worksheets, you may need to

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

41. Data can be arranged in a worksheet in a easy to understand manner using

42. A numeric value can be treated as a label value if it precedes with

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

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

45. To autofit the width of column

46. Macros are “run” or executed from the ….. Menu.

47. The name box

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

49. Which of the cell pointer indicate that you can move the content to other cell?

50. MS Excel provides the default value for step in Fill Series dialog box