MS Excel Practice Session 2

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

2. Can we use table in excel to create filter ?

3. To view a cell comment

4. Microsoft Excel is a powerful ________

5. You can edit a cell by

6. Which Chart can be created in Excel?

7. Excel displays the current cell address in the ________

8. Which of the following is not a term of MS-Excel?

9. A ________ is a grid with labeled columns and rows.

10. Which key do you press to check spelling?

11. To activate Microsoft excel through run command, the keyword is

12. ___________ is a collection of cells organized in rows and columns where you keep and manipulate the data.

13. A typical worksheet has ________ number of columns

14. In MS Excel, keyboard shortcut keys to create a new workbook is _____

15. Comments can be added to cells using

16. Which of the following is not the correct method of editing the cell content?

17. The name box

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

19. A formula in Excel always begins with an ____ Sign

20. In Microsoft Excel spreadsheets, COLUMNS are labelled as _______

21. You can activate a cell by

22. Which of the following methods cannot be used to enter data in a cell

23. Which option is used to join the selected cells into single cell and center the content of cell ?

24. Comments can be edited using _____

25. In Microsoft Excel spreadsheets, rows are labelled as _______

26. Which of the following methods are used to edit cell

27. All of the above

28. Excel is a program that is used to prepare a

29. _____ can be used as a keyboard shortcut key to check spelling in MS Excel.

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

31. Which area in an excel window allows entering values and formulas

32. What is the shortcut key to replace a data with another in sheet?

33. How many worksheets can we added in a workbook?

34. Open “Microsoft Office Excel Help”.

35. The first cell in excel worksheet is _______

36. Which shortcut key is used to comment to cell

37. Which key is used for help in MS excel?

38. In Microsoft Excel spreadsheets, CELLS are labelled as _______

39. MS Excel stands for ___________

40. An Excel Workbook is a collection of ________

41. MS-EXCEL is based on ________

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

43. Can we view gridline and heading in print preview ?

44. MS Excel is a ________

45. Comments put in cells are called

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

47. Excel files have a extension ___________

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

49. Which symbol must all formula begin with?

50. A typical worksheet has ________ number of rows

51. In a worksheet you can select

52. Can we use formula bar to edit formula ?

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

54. Which is used to perform what if analysis?

55. The intersection of a column and a row in MS Excel worksheet is known as _______