Microsoft Excel Quiz

1. In Excel, a data set is defined as?

2. MS-EXCEL is based on _____?

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

4. ......... appear at the bottom of the Excel window.

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

6. Which one is not a Function in MS Excel ?

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

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

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

10. The auto calculate feature

11. How are data organized in a spreadsheet?

12. Which area in an Excel window allows entering values and formulas?

13. Which key do you press to check spelling?

14. Status indicators are located on the

15. Which of the following formulas will Excel Not be able to calculate?

16. You can use drag-and-drop to embed excel worksheet data in a word document

17. Weight refers to

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

19. In Excel, Columns are labelled as ___

20. To autofit the width of column

21. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

22. A typical worksheet has ________ Number of columns

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

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

26. Which of the following function is MS-Excel returns TRUE result if all of its arguments are true and otherwise false ?

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

28. Concatenation of text can be done using

29. While Finding and Replacing some data in Excel, which of the following statement is valid?

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

31. This dialog box specifies or modifies the worksheet cell range containing data to be charted.

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

33. Which tool you will use to join some cells and place the content at the middle of joined cell?

34. The auto calculate feature

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

36. You can group non-contiguous worksheets with

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

39. 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?

40. Which sentence is false for Microsoft Excel 2010?

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

42. What type of chart is useful for showing trends or changes over time ?

43. Gridlines

44. What are the basic rectangular building blocks of a spreadsheet?

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

46. Press _____ to bring up search box.

47. Multiple calculations can be made in a single formula using ________

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

49. Tab scrolling button