Microsoft Excel Quiz

1. When you copy a formula

2. Which of the following is invalid statement?

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

4. Edit > Delete command

5. The cell level F5 refers to

6. What setting do you need to change to print a spreadsheet with the header?

7. To view a cell comment

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

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

10. Gridlines

11. What tabs show up at the bottom of each workbook?

12. Charts tips can

13. Which term is used to join the selected cells in to one cell?

14. Which of the following setup options can not be set in the page setup dialog box?

15. Shortcut for Auto sum function in excel is

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

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

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

19. You can open the scenario Manager dialog box by choosing scenarios from the .......... menu.

21. You can set Page Border in Excel from

22. Hyperlinks cannot be

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

24. Which of the following is an absolute cell reference in MS Excel?

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

26. How do you wrap the text in a cell?

27. Tab scroll buttons are place on Excel screen

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

29. Which of the following is not a valid function in MS Excel?

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

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

32. What is the quickest way to select entire worksheet?

33. To delete an embedded objects, first

34. Microsoft Excel is a powerful __________

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

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

37. How can you delete a record?

38. Which one would you choose to create a bar chart?

39. To insert three columns between columns D and E you would

40. How many characters can be typed in a single cell in Excel?

41. Another name for a pre-programmed formula in Excel is

42. While selecting multiple worksheets in Excel, the following key must also be used when clicking the sheet tab.

43. How can you remove borders applied in cells?

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

45. Status indicators are located on the

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

47. Repeats the last command or action

48. when working in the page break preview, you can

49. How are data organized in a spreadsheet?

50. You can move a sheet from one workbook into new book by