MS Excel Practice Session 2

1. A typical worksheet has ________ number of columns

2. Comments put in cells are called

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

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

5. All of the above

6. You can edit a cell by

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

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

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

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

11. Which is used to perform what if analysis?

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

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

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

15. Comments can be edited using _____

16. Which Chart can be created in Excel?

17. Open “Microsoft Office Excel Help”.

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

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

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

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

22. In a worksheet you can select

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

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

25. Comments can be added to cells using

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

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

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

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

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

31. Excel displays the current cell address in the ________

32. MS Excel stands for ___________

33. Can we use formula bar to edit formula ?

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

35. To view a cell comment

36. Excel files have a extension ___________

37. A typical worksheet has ________ number of rows

38. MS Excel is a ________

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

40. The name box

41. Microsoft Excel is a powerful ________

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

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

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

45. The first cell in excel worksheet is _______

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

47. An Excel Workbook is a collection of ________

48. Which symbol must all formula begin with?

49. Which shortcut key is used to comment to cell

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

51. MS-EXCEL is based on ________

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

53. You can activate a cell by

54. Which key do you press to check spelling?

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