Microsoft Excel Quiz

1. In Excel, Columns are labelled as ___

2. What is the best way to reference cell A10 on sheet 3 from sheet 1?

3. Which of the following function is MS-Excel returns TRUE result if all of its arguments are true and otherwise false ?

4. When a row of data is to be converted into columns

5. Which of the cell pointer indicate that you can move the content to other cell?

6. Tab scrolling button

7. When you link data maintained in Excel workbook to a Word document

8. Which types of charts can excel produce?

9. Charts tips can

10. Excel displays the current cell address in ______

11. Shortcut key for line break is

12. What do you mean by a Workspace?

13. Edit > Delete command

14. Which function is used to calculate the loan’s amortization, rates of return and repayment amounts?

15. Which language is used to create macros in Excel?

16. _____ are equations that perform calculations on values in your worksheet.

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

18. The ____ feature of MS Excel quickly completes a series of data

19. The cell reference M$4 is a..........

20. Which of the following is invalid statement?

21. What does COUNTA () function do?

22. This type of software is similar to an accountants worksheet

23. How can you show or hide the gridlines in Excel Worksheet?

24. o return the remainder after dividing a number, we use the ________ function.

25. Which of the following shortcuts can be used to insert a new line in the same cell?

26. Which of the following formulas will Excel Not be able to calculate?

27. In EXCEL, you can sum a large range of data by simply selecting a tool button called ________.

28. What is the short cut key to highlight the entire column?

29. When you see a cell with a red triangle in the top right corner, what does this signify?

30. In EXCEL, you can add up a wide range of data by simply selecting a button called ________?

31. Multiple calculations can be made in a single formula using ________

32. To insert three columns between columns D and E you would

33. To record a sequence of keyboard strokes and mouse actions to be reproduced later, we use:

35. Which of the cell pointer indicates that you can fill series?

36. How do you delete a column?

37. Macros are “run” or executed from the ….. Menu.

38. You can convert existing excel worksheet data an charts to an HTML document by using

39. Which of the following is not a valid data type in excel

40. How can you remove borders applied in cells?

41. What type of chart is useful for showing trends or changes over time ?

42. In MS-Excel which function enters today's data in a cell?

43. Cuts the selected cells

44. To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the

45. ______ specify the type of calculation that you want to perform on the elements of a formula.

46. A typical worksheet has …. Number of columns

47. Excel worksheet cells work very similarly to what common element of the windows graphical user interface

48. Which of the cell pointer indicates you that you can make selection?

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

50. Comments can be added to cells using