This paper based test consists of numerous questions and tests students knowledge about Spreadsheet Software including formula and graphs. Students can achieve up to a total of 47 marks. Answer Key included

Perfect for a sub lesson or as an end of unit test.

Questions range from the following topics:
• Spreadsheet features e.g. cell references
• Interpreting and Analysing Spreadsheet Data
• Charts and Graphs
• Writing Calculations and Formulae in Spreadsheets (Addition, Subtraction, Multiplication, Division)
• =Sum() formula
• =Average formula

Other Microsoft Excel Products Available:
• Microsoft Excel Bundle 1: Click Here
• Microsoft Excel Bundle 2: Click Here
• Grades 1- 4: Microsoft Excel The Bundle: Click Here
• Excel Spreadsheets - Lesson Book & 7 Different Spreadsheets: Click Here
• Introduction to Excel Spreadsheets & Formulae Lesson Plan: Click Here
• Google Sheets & Excel Spreadsheets - Task Cards/Help Cards (Formula Practise): Click Here
• Pocket Money - Activity Spreadsheet: Click Here
• Spreadsheet and Graph Skills - McDonalds Scenario: Click Here
• Million Dollars - Activity Spreadsheet: Click Here
• Christmas Mystery Pictures Fill Color - Computer Lab: Click Here
• Valentine’s Day Mystery Pictures Fill Color - Computer Lab: Click Here
• St. Patricks Day Mystery Pictures Fill Color - Computer Lab: Click Here
• Christmas Mystery Pictures Fill Color 2 - Computer Lab:Click Here
• Seasonal Mystery Pictures Fill Color Bundle - Computer Lab Click Here
• Presidents Day Mystery Pictures Fill Color - Computer Lab: Click Here
• Easter Mystery Pictures Fill Color - Computer Lab: Click Here
• Halloween Mystery Pictures Fill Color - Computer Lab: Click Here
• Excel - Spreadsheets Toolbar: Click Here
• Introduction to Formulae in Excel Lesson Plan: Click Here
• Creating Graphs in Excel: Click Here
• Excel Spreadsheets Word Wall: Click Here
• Excel - Spreadsheets Reminder:Click Here
• Excel - Spreadsheet Test: Click Here
• Supermarket Comparison - Activity Spreadsheet: Click Here
• Excel Spreadsheets - Different Cursor Meanings: Click Here
• Chart Analysis in Excel Spreadsheets: Click Here
• Analyzing Excel Spreadsheets: Click Here
• Mystery Pictures - Excel Spreadsheets Cell References: Click Here
• Excel - Spreadsheets Formulae: Click Here
• Harry's Excel Spreadsheets: Click Here
• Absolute Cell Referencing Worksheet: Click Here
• Bal's Tanning Salon - Activity Spreadsheet: Click Here
• Excel - Introduction to Spreadsheets & Calculations: Click Here
• Mystery Pictures - Excel Spreadsheets Conditional Formatting: Click Here
• Microsoft Excel Spreadsheet and Graph Skills - M&M's Scenario: Click Here
• Microsoft Excel Spreadsheets Paper Test: Click Here
• Microsoft Excel Spreadsheet Features & Chart Task Cards Help Cards: Click Here
• Excel 2010 Toolbar - All Tabs Activity: Click Here


This resource comes complete with an answer key.

Check out the preview file for a glimpse of this resource.

If you don't want to use this resource as a test, each question can be printed individually as a question sheet for students to complete.