Microsoft Excel Quiz

1. Files created with Lotus 1-2-3 have an extension

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

3. You can check the conditions against __________ when applying conditional formatting

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

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

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

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

8. Gridlines

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

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

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

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

13. When you insert an excel file into a word document. The data are

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

15. Edit > Delete command

16. When creating a vertical page break

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

18. Which of the following is not true about Find and Replace in Excel

19. Concatenation of text in MS Excel can be done using

20. What is the shortcut to select the whole column?

21. Which of the following Excel charts represents only one value for each variable?

22. Which of the cell pointer indicates you that you can make selection?

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

24. In EXCEL, you can add up a wide range of data by simply selecting a button called ________?

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

26. Functions in MS Excel must begin with ___

27. What does COUNTA () function do?

28. You can use the horizontal and vertical scroll bars to

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

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

31. .......... loader is executed, when a system is first turned ON or restarted.

32. Each excel file is called a workbook because

33. Which of the following methods can not be used to edit the contents of a cell?

34. All worksheet formula

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

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

37. What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer.

38. To remove the content of selected cells you must issue ______ command

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

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

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

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

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

44. Which field in Excel is used to enter values and formulas?

45. You can copy data or formulas

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

47. To record a sequence of keyboard strokes and mouse actions to be reproduced later, we use:

48. Concatenation of text can be done using

49. You can auto fit the width of column by

50. To view a cell comment