Microsoft Excel 2016 Student Tests/Answer Keys- 2 Tests Included
This a zipped folder that contains two student 2016 Microsoft Excel test files with detailed answer keys. 4 files altogether. Answer keys are very detailed. Tests are suitable for grades 7-12. Test 1 is made up of 3 parts- Part 1 there is a picture of an Excel window and students need to label the parts. An answer bank is provided. In Part 2 they need to answer 11 short answer questions and in Part 3 they need to create a spreadsheet and perform various tasks dealing with Christmas Blockbusters. It covers topics such as editing content in cells, inserting columns and rows, resizing columns and rows, hiding and unhiding columns and rows, using the AutoSum button, inserting worksheets, Find and Select command button, Merge and Center, Print Area Settings, Comments, Formulas, Series and AutoFill, wrap text, freeze and unfreeze panes, and lots more. Test 2 contains 20 short-answer questions in which students have to identify various command buttons and their function and give step-by-step directions on how to complete various tasks. It covers topics such as using Excel templates, creating charts/graphs, using formulas and functions, naming ranges, using hyperlinks, applying borders to cells, and lots more. The tests are Word documents so you can edit it to your liking- add things, cut out things, use parts for your own tests, etc.
These tests go perfectly with the Microsoft Excel 2016 Study-Reference Guide product available in out store. It can be found by selecting our Microsoft Office custom category. The first test covers the study guide up to the freezing and splitting window panes and the 2nd test covers the rest of the guide.
Please see our Microsoft Office custom category link for other great Microsoft Office products.
Please visit our store for great keyboarding/typing materials, Microsoft Office materials, business-related materials, icebreaker activities, holiday word searches/word scrambles/trivia, birthday/award certificates, etc.
Thanks for looking! Please leave feedback and follow us!