Microsoft Excel Quiz

1. The Paste Special command lets you copy and paste:

2. Press _____ to create a chart.

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

4. Press the ______ key to move the insertion point to the first cell in a row in Excel.

5. You can enter which types of data into worksheet cells?

6. The auto calculate feature

7. Which of the following identifies a cell in Excel?

8. which function will calculate the number of workdays between 6/9/2004 and 8/12/2004?

9. In MS Excel, Page border option is available under _______ tab.

10. Multiple calculations can be done in a single formula using _______

11. MS-EXCEL is based on _____?

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

13. Tab scrolling button

14. The command Edit > Fill Across Worksheet is active only when

15. You can set Page Border in Excel from

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

17. Which of the following is not true regarding Conditional Formatting?

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

19. A numeric value can be treated as a label value if it precedes with

20. You can zoom a worksheet

21. How to sort the data in ascending or descending order?

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

23. Shortcut for Auto sum function in excel is

24. Which Chart can be created in Excel?

25. Which one of the following software applications would be the most appropriate for performing numerical and statistical calculations?

26. Microsoft Excel uses the _________ function to calculate the results in the data table

27. When a range is selected, how can you activate the previous cell?

28. When you open a new Excel workbook 2013, how many worksheets are there by default at the time of opening?

29. Select correct statement

30. What term refers to a specific set of values saved with the workbook?

31. Which of the following Excel screen components can NOT be turned on or off?

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

33. You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?

34. Which functionin Excel checks whether a condition is true or not ?

35. You can add an image to a template by clicking the Insert Picture From File button on the ............. Toolbar.

36. The auto calculate feature

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

39. Data can be arranged in a worksheet in a easy to understand manner using

40. What function displays row data in a column or column data in a row?

41. When you insert an Excel file into a Word document, the data are

42. What setting do you need to change to print a spreadsheet with the header?

43. Cuts the selected cells

44. You can create hyperlink from an excel workbook to

45. You can open the scenario Manager dialog box by choosing scenarios from the .......... menu.

46. How do you wrap the text in a cell?

47. What does COUNTA () function do?

48. The chart wizard term data series refers to

49. Which of the following is not true regarding Conditional Formatting?

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