Accounting Trainig Unlimited Excel Practice, Exercises of MS Microsoft Excel skills

Download Accounting Trainig Unlimited Excel Practice and more Exercises MS Microsoft Excel skills in PDF only on Docsity!

Excel Practice Test

Table of Contents

Excel Practice Test......................................................................................................................................... 3 Excel Practice Test Answer Sheet ................................................................................................................. 7

9. You can cut and paste data from one cell into another. Instead of using the mouse to do the cut and paste, you can use the keyboard. To cut press _________; to paste, press __________. A) CTRL+X and CTRL+V B) CTRL+C and CTRL+V C) CTRL+A and CTRL+V D) CTRL+V and CTRL+X 10. Which function can you use to capture the contents of an open window? A) Icon Set B) Clip Art C) SmartArt D) Screenshot 11. A SmartArt graphic provides an audible representation of information. A) True B) False 12. “Values” can include numbers, formulas, and functions. A) True B) False 13. The “Fill handle” is a small square in the lower-left corner of a selected cell or range of cells. A) True B) False 14. =A7+A9 will subtract the two cells? A) True B) False 15. The shortcut key to “undo” an action in Excel 2010 is: A) CTRL+PAGE UP B) CTRL+HOME C) CTRL+Z D) CTRL+C

16. What is the default file extension when you save a workbook for Excel 2010? A) .xls B) .xlsx C) .excel D) .xlav 17. When you have selected a range of cells and then you press CTRL+P. Excel will automatically print the selected range. A) True B) False 18. Excel offers the “Spell Check” function. A) True B) False 19. To use the Spell check function you go to the “View” tab on the ribbon. A) True B) False 20. Excel provides the following functions to be used except: A) AVERAGE B) MIN C) MAX D) HIGH 21. You can move a chart in a workbook from one sheet to another. A) True B) False 22. You can add Axis titles to a chart. A) True B) False

Excel Practice Test Answer Sheet Name: (Please Print)

1. A 16. B
2. C 17. B
3. B 18. A
4. A 19. B
5. A 20. D
6. B 21. A
7. A 22. A
8. B 23. A
9. A 24. A
10. D 25. B
11. B 26. A
12. A 27. B
13. B 28. A
14. B 29. B
15. C 30. A