Microsoft Excel 2016 Student Tests/Answer Keys- 2 Tests Included

Microsoft Excel 2016 Student Tests/Answer Keys- 2 Tests Included
Resource Type
Product Rating
File Type

Compressed Zip File

Be sure that you have an application to open this file type before downloading and/or purchasing.

304 KB|17 pages
Product Description
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!

Total Pages
17 pages
Answer Key
Teaching Duration
Report this Resource
Digital Download
More products from Twin Business Teachers
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail
Teachers Pay Teachers

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.

Learn More

Keep in Touch!

Sign Up