Microsoft Excel Quiz

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

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

3. How to sort the data in ascending or descending order?

5. Tab scroll buttons are place on Excel screen

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

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

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

9. What happens when you press Ctrl + X after selecting some cells in Excel?

10. In which tab wrap text feature is present in MS Excel 2007?

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

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

13. Long text can be broken down into many lines within a cell. You can do this through

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

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

16. All worksheet formula

17. Excel displays the current cell address in ______

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

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

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

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

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

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

24. Which of the following is not a valid data type in Excel?

25. Tab scrolling button

26. Functions in MS Excel must begin with ___

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

28. Which is used to perform what if analysis?

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

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

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

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

33. In ______ tab you will find AutoSum button.

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

35. Press _____ to create a chart.

36. The Chart wizard term data categories refers to;

37. A worksheet range is a

38. 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.

39. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply

40. Documentation should include

41. Microsoft Excel uses the _________ function to calculate the results in the data table

42. In MS-Excel which function enters today's data in a cell?

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

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

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

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

47. Which of the following is the latest version of Excel

48. The autofill feature

49. Which of the following is not true regarding Conditional Formatting?

50. To view a cell comment