Microsoft Excel Quiz

1. Which shortcut key is used to copy the selected cells in MS Excel ?

2. Which command is used to close the window of Excel?

3. Press _____ to bring up search box.

4. Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?

5. An Excel workbook is a collection of ______

6. What function do you use to display the current date only in MS Excel?

7. How do you change the number 200 into $200?

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

9. Comments put in cells are called

10. Comments can be added to cells using ________

11. The first cell of the EXCEL worksheet is labelled as __

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

13. A typical worksheet has ________ Number of columns

14. Ctrl + D shortcut key in Excel will

16. Select correct statement

17. When the formula bar is activated, you can see

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

19. Which of the following options is not located in the Page Setup dialog box?

20. Which of the following identifies a cell in Excel?

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

22. You can edit a cell by

23. A data map is helpful

24. Statistical calculations and preparation of tables and graphs can be done using

25. Edit > Delete command

26. ______ specify the type of calculation that you want to perform on the elements of a formula.

27. Which of the following software applications would be the most appropriate for performing numerical and statistical calculations?

28. The command Edit > Fill Across Worksheet is active only when

29. You can open the consolidate dialog box by choosing Consolidate from the ….. Menu.

30. A function inside another function is called….

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

32. You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?

33. Which of the following series type is not valid for Fill Series dialog box?

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

35. Tab scrolling button

36. What will be the output if you format the cell containing 5,436.8 as ‘#,##0.00’ ?

37. The  default Row height MS excel worksheet is ............. point

38. You can create hyperlink from an excel workbook to

39. Which setting you must modify to print a worksheet using letterhead?

40. When a row of data is to be converted into columns

41. In ______ tab you will find AutoSum button.

42. How can you remove borders applied in cells?

43. Which of the following action removes a sheet from workbook?

44. Which of the following absolute cell reference

45. What is the extension of saved file in MS Excel?

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

47. Excel worksheet cells work very similarly to what common element of the windows graphical user interface

48. You can copy data or formulas

49. The default file extension of MS Excel is

50. Which of the following format you can decide to apply or not in AutoFormat dialog box?