Microsoft Excel Quiz

1. Which of following is Not one of Excel’s what-if function?

2. What are the basic rectangular building blocks of a spreadsheet?

3. How can you remove borders applied in cells?

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

5. Concatenation of text can be done using

6. Which of the following is not an example of a value?

7. Which types of charts can excel produce?

8. A worksheet range is a

9. How can you arrange to get a quick alert if a cell contains a value below a specific amount?

10. Which of the following you can paste selectively using Paste Special command?

11. Documentation should include

12. When the formula bar is activated, you can see

13. Which elements of a worksheet can be protected against accidental changes?

14. You can use drag-and-drop to embed excel worksheet data in a word document

15. In A3 cell edit = A1 + A2 refers to

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

17. When integrating Ms-Word and Excel, Word is usually the

18. Press _____ to bring up search box.

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

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

21. Formatting a cell in currency, you can specify

22. You can use the format painter multiple times before you turn it off by

23. When you group worksheets

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

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

26. when you print preview a worksheet

27. In ______ tab you will find AutoSum button.

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

29. How do you change the number 200 into $200?

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

31. What is the shortcut key to insert new sheet in current workbook?

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

33. Which of the following is the purpose of AutoSum?

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

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

36. __________ is a grid with labeled columns and rows.

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

38. Press _____ to select all rows and columns in the worksheet.

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

40. What's a quick way to extend these numbers to a longer sequence, for instance 1 through 20.

41. What tabs show up at the bottom of each workbook?

42. This dialog box specifies or modifies the worksheet cell range containing data to be charted.

43. You can not link Excel worksheet data to a Word document

44. Documentation should include

45. __________is NOT a Function in Microsoft Excel spreadsheets.

46. A circular reference is

47. Which is used to perform what if analysis?

48. To delete an embedded objects, first

49. You can use the drag and drop method to

50. How can you view two workbooks simultaneously to compare sales figures?