MS Excel Practice Session 2

1. Excel files have a extension ___________

2. Open “Microsoft Office Excel Help”.

3. The name box

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

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

6. In a worksheet you can select

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

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

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

10. Which Chart can be created in Excel?

11. Which shortcut key is used to comment to cell

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

13. MS-EXCEL is based on ________

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

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

16. MS Excel stands for ___________

17. A typical worksheet has ________ number of rows

18. Which symbol must all formula begin with?

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

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

21. The first cell in excel worksheet is _______

22. You can edit a cell by

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

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

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

26. MS Excel is a ________

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

28. Which is used to perform what if analysis?

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

30. Comments can be added to cells using

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

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

33. Comments can be edited using _____

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

35. Which key do you press to check spelling?

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

37. You can activate a cell by

38. Can we use formula bar to edit formula ?

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

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

41. Excel displays the current cell address in the ________

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

43. Comments put in cells are called

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

45. A typical worksheet has ________ number of columns

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

47. To view a cell comment

48. All of the above

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

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

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

52. Microsoft Excel is a powerful ________

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

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

55. An Excel Workbook is a collection of ________