MS Excel Practice Session 2

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

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

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

4. To view a cell comment

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

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

7. You can edit a cell by

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

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

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

11. Can we use formula bar to edit formula ?

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

13. An Excel Workbook is a collection of ________

14. Microsoft Excel is a powerful ________

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

16. MS Excel is a ________

17. Excel displays the current cell address in the ________

18. All of the above

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

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

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

22. In a worksheet you can select

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

24. You can activate a cell by

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

26. Comments can be added to cells using

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

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

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

30. Which symbol must all formula begin with?

31. Open “Microsoft Office Excel Help”.

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

33. A typical worksheet has ________ number of rows

34. MS Excel stands for ___________

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

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

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

38. The name box

39. MS-EXCEL is based on ________

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

41. Comments put in cells are called

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

43. Comments can be edited using _____

44. Which key do you press to check spelling?

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

46. Excel files have a extension ___________

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

48. A typical worksheet has ________ number of columns

49. Which Chart can be created in Excel?

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

51. Which shortcut key is used to comment to cell

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

53. Which is used to perform what if analysis?

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

55. The first cell in excel worksheet is _______