MS Excel Practice Session 2

1. MS Excel is a ________

2. The name box

3. To view a cell comment

4. Excel displays the current cell address in the ________

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

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

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

8. In a worksheet you can select

9. Can we use formula bar to edit formula ?

10. Excel files have a extension ___________

11. The first cell in excel worksheet is _______

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

13. Which Chart can be created in Excel?

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

15. You can edit a cell by

16. Comments put in cells are called

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

18. Comments can be edited using _____

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

20. You can activate a cell by

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

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

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

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

25. All of the above

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

27. A typical worksheet has ________ number of columns

28. Open “Microsoft Office Excel Help”.

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

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

31. Which is used to perform what if analysis?

32. Comments can be added to cells using

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

34. Which key do you press to check spelling?

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

36. Which shortcut key is used to comment to cell

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

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

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

40. A typical worksheet has ________ number of rows

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

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

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

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

45. Which symbol must all formula begin with?

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

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

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

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

50. MS Excel stands for ___________

51. MS-EXCEL is based on ________

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

53. Microsoft Excel is a powerful ________

54. An Excel Workbook is a collection of ________

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