Intro to Excel Quiz

After completing my Intro to Excel class you will be able to answer all of the following questions within 15 minutes.  If you can do so already, than you should review the content of my Intermediate-Advanced Excel class.

1.     An electronic spreadsheet can perform all of the following tasks, except

2.     Each key(s) can be used to confirm cell entries, except

3.     You can get Excel Help any of the following ways, except

4.     Which Formatting toolbar button can be used to shade a cell?

5.     Which tool can be used to format numbers that represent monetary values?

6.     Which feature allows us to copy data or fill cells with a series of numbers, dates, or time periods?

7.     Which key activates the Edit mode so we can change the data in a cell?

8.     Which arithmetic operator do we use for multiplication?

9.     Which feature will display the formula that has been entered into a cell?

10. Which toolbar button can we use to quickly add value in a column or row?

11. Which one of these is an example of the SUM function?

12. Which tab in the Page Setup box contains the margin settings for headers and footers?

13. Which menu is used to access the Spelling command?

14. Which option allows us to see how a Web browser will display a workbook?

15. Which button allows us to adjust column widths while we are using Print Preview?

16. Which feature will display the formula that has been entered into a cell?

17. Which example is the correct way to enter a formula that will add the values in cells B4 and B5?

18. Which button on the Formula bar allows us to access Excel’s functions?

19. Which arithmetic operator do we use for division?

20. Which commands can we use to delete data, but keep the cell shading?

21. Which of the following symbols is always used to begin a formula?

22. Which feature allows us to quickly copy formulas by dragging the mouse?

23. Which key do we hold down when we are dragging a sheet tab to create a copy of the worksheet?

24. How can we quickly select the entire worksheet?

25. Which menu do we use if we want to hide or display the office assistant?

26. Which menu do we use to Delete a worksheet?

27. Which Page Setup option cannot be used while we are in Print Preview?

28.  Which steps do we use to remove a print area that has been set for a worksheet?

29. Which menu is used to access the Spelling command?

30. Which of the following is not an option for accessing the Print Preview feature?

31.  Is it possible to collate copies as they are printed?

32. How do you recognize a negative number on a worksheet when you do not us a color printer?

33.  Name the shortcut key strokes for saving a document?

34.  Name the shortcut key strokes for printing?

35.  Name the shortcut key strokes for opening a new document?

36.  Name the shortcut key strokes for closing a document?

37. Name the intersection of a column and row?

38. Name the shortcut key strokes for creating bold text?

39. Name the shortcut key strokes for creating underlined text?

40. Name the shortcut key strokes to deselect bold text?

41. Describe how many cells are in a range of cells?

42. Name the shortcut key strokes to paste copied cells?

43. Name the shortcut key strokes to copy?

44. What is the default name of a workbook when you open Excel?

45. What symbol do you use to distinguish an absolute cell?

46. How will the number 250.5 display in the formula bar if you set the decimal buttons at zero?

47. How will the number 250.5 display in the cell if you set the decimal buttons at zero?

48. What is an operator in a formula?

49. What is an operand in a formula?

50. Excel will start calculating from the left to the right according to the order of operations.  Name the operations order performed in a formula? 

Send mail to ruthgriffithconsulting@yahoo.com with questions or comments about this web site.
Copyright © 2002 Brenda Dwenger Computerized Accounting