Microsoft Excel Quiz

1. Formatting a cell in currency, you can specify

2. How are data organized in a spreadsheet?

3. Excel uniquely identifies cells within a worksheet with a cell name

4. Tab scrolling button

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

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

7. What does COUNTA () function do?

8. What will be the output if you format the cell containing 5,436.8 as ‘#,##0.00’ ?

9. Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?

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

11. ______ of the worksheet appear vertically and are identified by letters at the top of the worksheet window.

12. Documentation should include

13. If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you:

14. When you enter text in a cell in Excel. It also appears in the

15. How can you efficiently display all your chart values in a tabular format on the chart page?

16. You can zoom a worksheet

17. Which command will you choose to convert a column of data into row?

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

19. The view that puts a blue line around each page that would be printed is the

20. While selecting multiple worksheets in Excel, the following key must also be used when clicking the sheet tab.

21. when working in the page break preview, you can

22. MS Excel provides the default value for step in Fill Series dialog box

23. What is the shortcut to select the whole column?

24. Which of the following is an absolute cell reference?

25. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?

26. You can select a single range of cells by

28. The Chart wizard term data categories refers to;

29. If 10/2 entered in a cell without applying any formats, excel will treat this as

30. You can create hyperlink from an excel workbook to

31. Comments put in cells are called

32. Hyperlinks cannot be

33. The cell level F5 refers to

34. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply

35. In which tab wrap text feature is present in MS Excel 2007?

36. In a formula, which symbol specifies the fixed columns or rows?

37. When creating a vertical page break

38. To select an entire column in MS-EXCEL, you click on ________?

39. Which of the following is not information you can specify using the solver?

40. What chart can be created in Excel?

41. Another name for a pre-programmed formula in Excel is

42. To edit data in an embedded Excel worksheet object in a Word document

43. You can check the conditions against __________ when applying conditional formatting

44. Which of the following action removes a sheet from workbook?

45. Which of the following setup options can not be set in the page setup dialog box?

46. Weight refers to

47. To drag a selected range of data to another worksheet in the same workbook, use the

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

49. How do you change column width to fit the contents?

50. Statistical calculations and preparation of tables and graphs can be done using