excel assignments for high school students pdf

Excel Practice Exercises PDF with Answers

In this article, we will provide you with 11 Excel practice exercises in PDF format with answers. Additionally, you will get an Excel file where you can try to solve these problems yourself. These problems are mostly beginner friendly. However, a little bit of intermediate knowledge is required to solve a few problems. You will need to know about the SUM , AVERAGE , IF , VLOOKUP , INDEX , MATCH , ROUNDUP , UNIQUE , COUNTIF , LEFT , SEARCH , MID , RIGHT , LEN , FIND , SUBSTITUTE , AND , and SUMIF functions and the Data Bars feature of Excel. If you have Excel 2010 or later, you can solve these problems, except for the UNIQUE function, which is only available in Excel 2021 .

Download Practice Files

You can download the PDF and Excel files by filling out this form:

Eleven Practice Exercises with Solutions.pdf [/wpsm_box] [wpsm_box type="download" float="none" textalign="left"] Eleven Practice Exercises.xlsx [/wpsm_box] -->

Problem Overview

There are eleven problems in this PDF file, and the solutions to those problems are given after each problem. Here is a snapshot of the first two problems. The solutions to all problems are given in a separate sheet of Excel file.

Now, the eleven exercise problems are as follows:

• Exercise 01. Class Performance Evaluation . You will find these values –
• The total number for each student,
• Their average on those subjects,
• Based on the average score, you will return a GPA. For GPA calculation, less than 60 is B and higher is A .
• You need to find the employee salary in the lookup table on the right side.
• Exercise 03: Lookup Values (Any Direction) .
• Here your task is the same as the second task. However, this time the lookup range is on the right side. Therefore, you cannot use the VLOOKUP function here.
• You will need to round the sales generated values in this exercise.
• You will need to add the first name and last name.
• Your task is to create a Data Bar for the salary values and hide the salary values.
• Firstly, you need to find the unique values in a list of names.
• Then, you will find how many times that value occurred in that lis
• You need to separate the three parts of a name from a given list.
• You will need to find the total sales for a particular country.
• Your objective is to ensure that users cannot type less than 0 in a column.
• Your target is to determine whether a date is between two dates or not.

Here is a screenshot of the solutions to the first two problems. The solutions to these problems are provided in the PDF and Excel files.

Thank you for reading this article. We hope that with these practice exercises in PDF format with answers, you can test your Excel skills. You can find more articles similar to this on the ExcelDemy website. If you have any questions or suggestions, feel free to comment below. However, remember that our website implements comment moderation. Therefore, your comment may not be instantly visible. So, have a little bit of patience, and we will solve your query as soon as possible. Keep excelling!

What is ExcelDemy?

Rafiul Haq worked as an Excel and VBA Content Developer in Exceldemy for over two years and published almost 200 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Mechanical and Production Engineering (MPE) from the Islamic University of Technology. Rafiul furthered his education by obtaining an MBA in Finance from the Institute of Business Administration (IBA) at the University of Dhaka. Apart from creating... Read Full Bio

You really help me alot thanks

Hello, Aleem!

Thanks for your appreciation. stay in touch with ExcelDemy .

Regards ExcelDemy

Thanks a lot

Dear Rashmi ,

You are most welcome.

This is very helpful. You are God send

Thanks for your appreciation.

Leave a reply Cancel reply

ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems.

Contact  |  Privacy Policy  |  TOS

• User Reviews
• List of Services
• Service Pricing

• Create Basic Excel Pivot Tables
• Excel Formulas and Functions
• Excel Charts and SmartArt Graphics
• Advanced Excel Training
• Data Analysis Excel for Beginners

Advanced Excel Exercises with Solutions PDF

Subject Explorer

School Subjects

Math & Science

Business & Technology

Electives & Health

Board & Administration

Teaching & Learning

Audio/Video Lectures

Books & Documents

Classifieds

Jobs & Resources

Discussions

Language & Literature

Practice Projects for Excel

Excel Project C9: Grades and Averages

Instructions for students to “create a spreadsheet that shows all of your classes and automatically averages all of your test grades for each subject and then shows an overall average of your test …

Excel Project C8: Attendance Record

In this practice project for Excel and similar spreadsheets, students create a spreadsheet that automatically adds up all of the Sunday School classes each Sunday, gives an average attendance for …

Excel Project C7: Loan Payment

In this practice project for Excel and similar spreadsheet programs, students replicate a record of loan payments. They format columns to make each payment automatically subtract from the balance …

Excel Project C6: Treasurer’s Report

In this practice project for Excel and similar spreadsheet programs, students replicate a treasurer’s report at an imaginary church. They also format a column to find the total at the bottom. …

Excel Project C5: Parent Directory

In this practice project for Excel and similar spreadsheet programs, students replicate a parent directory with empty spaces for parent contact information. …

Excel Project C4: School Directory

In this practice project for Excel and similar spreadsheet programs, students replicate a school directory with title and four columns of information. …

Excel Project C3: Sign Up Sheet

In this practice project for Excel and similar spreadsheet programs, students replicate a weekly sign up sheet with a title and two columns. …

Excel Project C2: Chapel Schedule

In this practice project for Excel and similar spreadsheet programs, students replicate a weekly chapel schedule including date, speaker, topic, and song leader. …

Excel Project C10: Invoice

In this practice project for Excel and similar spreadsheets, students create an invoice template like the sample shown, entering the formulas for all of the cells so that the numbers total correctly …

Excel Project C1: Bible Memory Chart

In this practice project for Excel and similar spreadsheet programs, students replicate a Bible memory chart. …

Resource Type:

Pass it on:

Leave a Reply

Notable Children's Digital Media

To find out about more great digital media for children, visit the page for ALSC's Excellence in Early Learning Digital Media Award .

This list represents the titles selected by the committee for 2023-2024.

GLOBE Observer . App: iOS & Android. Middle, Older. Science, Nature, Environment. https://observer.globe.gov/about/get-the-app

This citizen science app is available in more than 120 countries. It allows users to make environmental observations that complement NASA satellite observations, helping scientists study Earth and the global environment. By using the GLOBE Observer app, you can contribute important scientific data to NASA and GLOBE, your local community, and students and scientists worldwide. (Available in numerous languages. See app for list.)

Goally . App: iOS, Amazon, Android, and tablets. Younger, Middle, Older. Cost : starting at $15/mo. https://getgoally.com/

Provides neurodiverse children with the tools to build life and language skills needed to reach their potential. These include visual schedules, interactive video classes, emotional regulation games, and augmentative and alternative communication. Available in English.

Google Arts and Culture . Website/App: iOS & Android. Older, Educators, Parents. Arts, Visual Arts. https://artsandculture.google.com/explore

Google Arts & Culture is a non-commercial initiative that works with cultural institutions and artists from around the world. There are various topics to aid students in projects with excellent visuals for a heightened experience. Available in English.

Katoa . App: iOS & Android. Middle, Older. Science, Nature, Environment. https://www.sankaristudios.com/

This mobile farm-sim game incorporates strategy and environmental awareness as players build, nurture, and defend virtual ocean habitats from pollution. Players collect fauna and attract flora in a series of biomes, unlocking real photos of and facts about the species and locations depicted in the game's high-quality art. Additional reading and learning components come from short quest storylines and scripted conversations with fish and marine mammals. Game play points count toward real world donations from the developer and their sponsors to conservation organizations; players select their preferred organizations from a curated list. Available in English.

OctoStudio . App: iOS and Android. Elementary, Middle. Coding. https://octostudio.org/en/

This mobile coding app was created by the Lifelong Kindergarten research group at MIT, the same people who created Scratch. Children learn logic and develop programming skills by using block coding to create stories and games. Once it's downloaded, the app is able to function offline, which means that children with limited or no access to internet connectivity can enjoy it. OctoStudio is available in over 20 languages and is compatible with screen readers.

Seek by iNaturalist . App: iOS and Android. Younger, Middle. Nature. https://www.inaturalist.org/pages/seek_app

Citizen scientists, ages four and up, can snap photos of wildlife, plants, and fungi in order to have them identified. App users are able to take on challenges and unlock badges for photographing different organisms and species in their neighborhoods. Available in English, Afrikaans, Arabic, Basque, Bulgarian, Catalan, Croatian, Czech, Danish, Dutch, Finnish, French, German, Greek, Hebrew, Indonesian, Italian, Japanese, Norwegian Bokmål, Polish, Portuguese, Romanian, Russian, Singhalese, Spanish, Swedish, Traditional Chinese, Turkish, and Ukrainian.

SkySci for Kids . Website. Younger, Middle. Science, Weather, Climate. https://scied.ucar.edu/kids

This website allows children ages 5-10 to explore weather wonders, stuff in the sky, and climate change in fun and interactive ways using short articles, games, storybooks, and videos. The materials are designed to allow kids to explore either independently or with a parent or caregiver. Available in English.

Starfall . Website/App: iOS & Android. Younger, Parents/Caregivers. Language Arts, Math, Music. https://www.starfall.com/h/index.php

This resource, for Prek-Grade 5, provides exploration, play, and positive reinforcement for children as they learn and practice reading and math skills through interactive and multisensory games and music. A Parent-Teacher Center provides additional resources such as worksheets, books, projectables, music, and curriculum to help parents extend learning. Available in English

Notable Children's Digital Media Committee

Melanie A. Lyttle, Chair, Madison Public Library, Madison, OH Dr. Danilo M. Baylen, Co-Chair, University of West Georgia, Carrollton, GA Lauren E. Antolino, Cranford Public Library, Cranford, NJ Kirsten Caldwell, Onalaska, WI Angelica Candelaria, Bloomington, IN Jaclyn C. Fulwood, Allen County Public Library, Fort Wayne, IN Elizabeth M. Gray, Yolo County Library, Woodland, CA Bethni King, Georgetown, TX Trina C. Smith, Saint John the Baptist Parish Library, Laplace, LA Erin Warnick, NCDM Administrative Assistant, Pleasant Grove, UT

Share This Page

• Kindergarten QTR. 1 Lesson Plans
• Kindergarten QTR. 2 Lesson Plans
• Kindergarten QTR. 3 Lesson Plans
• Kindergarten QTR. 4 Lesson Plans
• Kindergarten QTR. 4 Word Processing
• First Grade Qtr 1. Lesson Plans
• First Grade Qtr 2. Lesson Plans
• First Grade Qtr 3. Lesson Plans
• First Grade Qtr 4. Lesson Plans
• Second Grade Qtr. 1 Lesson Plans
• Second Grade Qtr. 2 Lesson Plans
• Second Grade Qtr. 3 Lesson Plans
• Second Grade Qtr. 4 Lesson Plans
• Third Grade Qtr. 1 Lesson Plans
• Third Grade Qtr. 2 Lesson Plans
• Third Grade Qtr. 3 Lesson Plans
• Fourth Grade Qtr. 1 Lesson Plans
• Fourth Grade Qtr. 2 Lesson Plans
• Fifth Grade Qtr. 1 Lesson Plans
• Fifth Grade Qtr. 2 Lesson Plans

Me, Me, Me , Page Generators

• All About Me Page Generator
• Autobiographical Poem Generator
• All About Me - Fun Facts Generator
• All About Me Pennant Generator
• I Am Poem Generator
• Back to School - How I Feel
• Math About Me Page Generator
• My Vacation Page Generator
• Same Same! We have something in common!

Fun Fall / Thanksgiving Poem Generators

• I am Thankful | Acrostic Generator
• Celebrate Fall | Pumpkin Acrostic Generator
• Thanksgiving Poem Generator
• Turkey Acrostic Poem Generator
• Thanksgiving Turkey Personification Poem Generator
• Thanksgiving Diamante Poem Generator
• Thanksgiving Cinquain Poem Generator

Halloween Poem Generators

• Halloween Acrostic Poem Generator
• Halloween 'Candy' Acrostic Poem Generator
• Halloween 'Ghost' Acrostic Poem Generator
• Halloween Poem Generator
• Halloween Pumpkin Personification Poem Generator
• Halloween Diamante Poem Generator

Hanukkah Poem Generators

• Hannukah Diamante Poem Generator
• Hannukah Poem Generator
• Shalom Acrostic Generator

Winter Holiday Poem Generators

• Holiday Poem Generator
• Christmas Diamante Poem Generator
• Christmas Cinquain Poem Generator
• 'Holiday' Acrostic Generator
• Holiday 'Sleigh' Acrostic Generator
• Holiday 'Reindeer' Acrostic Generator

MLK / Black History Poem Generators

• MLK - I Have a Dream Poem Generator
• MLK - 'Equality' Acrostic Generator
• MLK - 'Freedom' Acrostic Generator
• Black History Biography Banner Generator

Valentine's Poem Generators

• Valentine's Day - Poem Generator
• Valentine 'Hearts' Acrostic Generator
• "Valentine" Acrostic Generator

Research Poem Generators

• Biography Research Page Generator
• Insect Research Page Generator
• Animal Research Page Generator

Awesome Poem Generators

• If I Were President - Poem Generator
• "Veteran" Acrostic Poem Generator
• Veterans Day Card Generator
• Earth Day Acrostic Poem Generator
• "Recycle" Acrostic Poem Generator
• "Ocean" Personification Poem Generator
• Friendly Letter Generator
• Sentence Stretching Page Generator
• Personal Narrative Page Generator
• OREO Opinion Writing Generator
• Hamburger Paragraph Generator
• Short Biography Generator
• Mother's Day Poem Generator

Teacher Tools Page Generators

• Classroom Jobs Generator
• Class Schedule Cards Generator
• Reward "Brag" Tag Generator
• Toolbox Large Label Generator 4.25 x 2
• Toolbox Small Label Generator 1 5/8 x 1 1/2
• Newsletter Generator
• Copy and Paste Telling Time Online Practice
• Copy and Paste Fraction Images Online Practice
• Copy and Paste Positional Words Online Practice
• Copy and Paste Technology Words Online Practice
• Copy and Paste Push and Pull Online Practice
• Copy and Paste Animal Words Online Practice
• Copy and Paste Ladybug Math Online Practice
• Copy and Paste Solids, Liquids, Gases Online Practice
• Copy and Paste Classifying Animals Online Practice
• Copy and Paste Living Things Online Practice
• A+ Attendance
• Above and Beyond
• Academic Excellence
• Amazing Attendance
• AR All Star
• Aspiring Author
• Best Attitude
• Best Handwriting
• Best Listener
• Best Singer
• Best Team Player
• Best Vocabulary
• Bold Innovator
• Caring Classmate
• Class Comedian
• Coding Whiz
• Day Brightener
• Extraordinary Effort
• Fantastic Friend
• Fashion Forward
• Good Citizen
• Great Athlete
• Great Googler
• Great Idea Girl
• Great Video Gamer
• Handwriting Hero
• Hardest Worker
• Heart of Gold
• Homework Hero
• Kindness King
• Kindness Queen
• Leadership Award
• Makerspace Master
• Miss Manners
• Mr. Manners
• Most Artistic
• Most Athletic
• Most Caring
• Most Cheerful
• Most Curious
• Most Energy
• Most Improved
• Most Organized
• Most Responsible
• Most Thoughtful
• Musical Maestro
• Neatest Desk
• Participant Award
• Perseverance Award
• Personality Plus
• Quiet Strength
• Remarkable Reader
• Skillful Searcher
• Social Butterfly
• Social Studies Star
• Spelling Improvement
• Sportsmanship
• Star Performer
• Star Reader
• Strong Work Ethic
• Student of the Month
• Student of the Month 2
• Student of the Year
• Super Citizen
• Super Public Speaker
• Super Scientist
• Superb Speller
• Technology Whiz
• Terrific Helper
• Terrific Typing
• Writing Wizard
• Weekly Paragraph-Opinion The Best Pet
• Weekly Paragraph-Opinion Fly or Read Minds?
• Weekly Paragraph-Opinion Famous Singer or Actor?
• Weekly Paragraph-Opinion 10 Brothers or 10 Sisters?
• Weekly Paragraph-Opinion Smartest Kid or Best Player?
• Weekly Paragraph-Opinion Robot or Helper Monkey?
• Weekly Paragraph-Opinion Alien or SuperHero?
• Weekly Paragraph-Opinion Invisibility or Get Really Big?
• Weekly Paragraph-Opinion Best School Subject
• Weekly Paragraph-Opinion Best Fruit
• Weekly Paragraph-Narrative How I Did It
• Weekly Paragraph-Narrative The Treasure Chest
• Weekly Paragraph-Narrative A New Place
• Weekly Paragraph-Narrative I Found a Magic Wand
• Weekly Paragraph-Narrative I Was SO Surprised
• Weekly Paragraph-Narrative A Long Time Ago, There Lived..
• Weekly Paragraph-Narrative Scariest Thing That Happened
• Weekly Paragraph-Narrative My Summer Break
• Weekly Paragraph-Narrative The Dog Washing Business
• Weekly Paragraph-Narrative The Time Machine
• Weekly Paragraph-Informative My Morning Routine
• Weekly Paragraph-Informative Recycling: What can Kids Do?
• Weekly Paragraph-Informative My Favorite Game: How to Play to Win
• Weekly Paragraph-Informative How to Learn to Draw Better Pictures
• Weekly Paragraph-Informative How to Be a Team Player
• Weekly Paragraph-Informative How to Be a Good Friend
• Weekly Paragraph-Informative How to Babysit a Puppy
• Weekly Paragraph-Informative Fire Alarms: What to Do
• Weekly Paragraph-Informative How to Get Ready for a Test
• Back To School-Open House Flipbook
• State Research Flipbook Template
• Full Page Flipbook Template - 5 tabs
• Biography Research Graphic Organizer
• Animal Research Graphic Organizer
• Insect Research Graphic Organizer
• Tri-Fold Brochure Template
• My Life Timeline Template 10 Yrs
• Newspaper Template - Blue
• Family Tree Template
• OREO Opinion Template
• My Opinion Graphic Organizer
• Friendly Letter Graphic Organizer
• First, Then, Next, Last Graphic Organizer
• Sentence Stretcher Graphic Organizer
• My Vacation - Narrative Writing Graphic Organizer - Black
• My Vacation - Narrative Writing Graphic Organizer - Blue
• Grades 2-5 Simple Spreadsheets & Charts
• Petting Zoo Chart
• Halloween Candy Chart
• Simple Pie Chart - Fruits
• Simple Bar Chart - Ice Cream
• M&M Chart
• Favorite Pets Chart
• Movie Expenses Chart
• Clothes Shopping Expenses Chart
• Camping Trip Expenses Chart
• School Supplies Expense Chart
• Thanksgiving Dinner Cost Comparison
• Puppy Adoption Budget Chart
• Emergency Supplies Budget
• Birthday Party Budget Chart

Clothes Shopping Budget

• iPad iWork Numbers Your First Chart
• iPad iWork Budgeting Basics for Kids
• QR Codes - for Quick iPad File Sharing
• QR Codes 32 Would You Rather..Questions
• QR Codes 36 More Would You Rather..Questions
• 3 Ways Teachers Can Use iPads in the Classroom Infographic
• iPad - Earth Science - Drawing Seasons
• iPad - Life Science - Labeling Anatomy Parts
• iPad - All About Me - Pic Collage
• iPad - All About Me - Balloon Stickies
• iPad All About Me Acrostic
• iPad - Personal Timeline - Popplet
• iPad Character Analysis Mind Map - Popplet
• iPad Spelling Words Comic Strip
• iPad Biography Summary Comic Strip
• QR Codes - iPad Butterfly Lifecycle Mini Poster
• iPad Technology Leader Presentation
• iPad My Life -Timeline Template
• iPad Family Tree Template
• iPad Friendly Letter Graphic Organizer
• iPad Tri-Fold Brochure Template
• iPad Newspaper Template
• Grades 3 - 5 - iPad Main Idea Graphic Organizer
• Grades 1 -2 - iPad Graphic Organizer - Ask Questions
• Grades 1 -2 - iPad Graphic Organizer - Answer Questions
• Grades 1 -2 - iPad Graphic Organizer - Story Detective
• Grade 1 - iPad Graphic Organizer - Story Elements Grade 1 - iPad Graphic Organizer - Feeling and Sensing Words
• Grade 1 - iPad Graphic Organizer - Explain the Difference
• Grade 1 - iPad Graphic Organizer - Who is Telling the Story?
• Grades 1 -3 -iPad Graphic Organizer - Central Message
• Grades 2 -3 - iPad Graphic Organizer - Moral of the Story
• Grades 3 - 5 - iPad Graphic Organizer - Fable Summary
• Grades 3 -5 iPad Graphic Organizer - Story Summary
• Grade 1 - iPad Graphic Organizer - Summarize a Story
• Grades 3 -4 - iPad Graphic Organizer - Character Analysis
• Grades 3 - 5 - iPad Graphic Organizer - Character Comparison
• Writing: Opinion
• Grades 1 - 3 - iPad Graphic Organizer - I Think ..
• Grades 1 -3 - iPad Graphic Organizer - My Opinion
• Grades 1 -3 - iPad Graphic Organizer - OREO Opinion
• Grades 1 -3 - iPad Graphic Organizer - Opinion - The Best Pet for Me
• Grades 1 -3 - iPad Graphic Organizer - Opinion - My Movie Review
• Grades 1 - 3 - iPad Graphic Organizer - Opinion - My Book Review
• Writing: Informative
• Grades 1 - 2 - iPad Graphic Organizer - Informative - First, Next, Then, Last
• Grades 1 -2 - iPad Graphic Organizer - Informative - All About Me
• Grades 1 - 2 - iPad Graphic Organizer - Informative - Can, Have, Are
• Grades 2-5 Basic Charts
• Excel First Chart - Party Supplies
• Excel Bar Chart - Fruit Stand
• Excel How We Get to School
• Excel What is Your Favorite Subject
• Excel Bake Sale Chart
• Excel What is Your Favorite Pet
• Excel What is Your Favorite Ice Cream Flavor
• Excel M & M Chart
• Excel Zoo Animals Chart
• Halloween Excel Chart
• Excel World's Fastest Animals
• Back to School Supplies Expense Chart
• Excel Clothes Expense Chart
• Excel Munch Box Expenses
• Excel Movie Expenses
• Excel Sports Equipment Expenses
• Excel Camping Trip Supplies Expenses
• Excel Lemonade Stand Expenses
• Excel Thanksgiving Dinner Expenses
• Excel Mini Video-Course in 4 minutes
• Excel Clothes Shopping Budget
• Excel Party for 5 Budget
• Excel Pet Adoption Budget
• Excel School Supplies Budget
• Excel Birthday Party Budget
• Excel Fast Food Nutrition Facts
• Lemonade Stand Profit or Loss
• Kinder / First Word Processing
• Copy and Paste Animals
• Copy and Paste Fractions
• Copy and Paste Lady Bug Math
• Copy and Paste Living Things
• Copy and Paste - Combo
• Copy and Paste Push and Pull
• Copy and Paste Time - Hours
• Copy and Paste Halloween
• Copy and Paste Thanksgiving
• Copy and Paste Solids, Liquids, Gases
• Cut and Paste Animal Vocabulary
• Cut and Paste Computer Parts
• Cut and Paste Positional Words
• Copy and Paste Bee
• Cut and Paste Weather Words
• Cut and Paste with Numbers
• Cut and Paste Opposites
• First Grade Common Core Writing Practice
• Informative Writing - Lesson #1 What Can Birds Do?
• Informative Writing - Lesson #2 How do Cats Grow?
• Informative - Lesson #3 Party Invitation
• Opinion Writing - Lesson #4 Dogs are Great
• Opinion Writing - Lesson #5 School is Fun
• Opinion Writing - Lesson #6 Reading is Fun
• Narrative Writing - Lesson #7 Itsy Bitsy Spider
• Narrative Writing Lesson #8 Clouds and Rain
• Narrative Writing - Lesson #9 Fox and the Grapes
• Writing Assignment Series - Sequencing
• First, Next, Then, Last, Graphic Organizer Template
• Punctuation Practice
• Common Core Opinion Writing Template
• First Grade Narrative Writing Lesson - My Friend
• First Grade Writing Prompt If I Had Three Wishes
• First Grade Narrative Writing Prompt - How I Lost My Tooth
• Opinion My Favorite Food Template
• Opinion Writing Prompt - The Best Subject
• Head Shoulders Knees Toes
• Labeling Skeleton Bones
• Fall Acrostic
• Story About a Pumpkin
• Happy Holidays Greeting
• Happy-Mother's Father's Day
• Happy Mother's Day Acrostic
• Happy Father's Day Acrostic
• Happy Spring Break Acrostic
• Happy Spring Break Letter
• Happy Thanksgiving Letter
• Happy Valentine's Day
• I Have a Dream Activity
• Time line Template
• Cesar Chavez Timeline
• Martin Luther King Jr. Timeline Template
• Time Line - New World Exploration
• My Life - Time line - 9 Yrs
• My Life - Time line - 10 Yrs
• Common Core Graphic Organizers
• All About Me Graphic Organizer
• Book Review Graphic Organizer
• Central Message Graphic Organizer
• Main Idea and Details Graphic Organizer
• Ask and Answer Questions Graphic Organizer
• OREO Opinion Writing Graphic Organizer
• Grades 2 -5 - Narrative - My Vacation
• Grades 3 -5 - Personal Narrative
• Grades 3 -5 - Informative Writing - "How To"
• Grades 2 -3 -Animal Research Graphic Organizer
• Grades 1-3 -Friendly Letter Graphic Organizer
• 3rd grade Money Unit Activity
• Respiratory System Diagram
• Explorer Hernando Cortes Poster
• Explorers Wanted Poster Template
• Amazing Animals PowerPoint
• Animal Homes
• Biography Lesson Plan
• Brochure Template - Tri-Fold
• Butterfly Life Cycle PowerPoint
• California Chumash Indians
• California Missions Powerpoint
• Camouflage PowerPoint
• Community Helpers PowerPoint
• Community Heroes PowerPoint
• Desert Ecosystems
• Dinosaurs PowerPoint
• Ecosystems PowerPoint
• Energy PowerPoint
• Extinct, Endangered, Threatened
• Food Chain PowerPoint
• Food Web Energy Pyramid
• Fossils PowerPoint
• Insect Life Cycle Presentation
• Inventors PowerPoint
• Kindness Powerpoint
• Life Cycle of a Frog Powerpoint
• Mammals-Herbivores, Carnivores, Omnivores
• Martin Luther King PowerPoint
• Needs and Wants PowerPoint
• Newspaper Templates
• Parts of a Plant PowerPoint
• Rocks and Minerals Powerpoint
• Solar System Powerpoint
• Temperate Forest Ecosystem PowerPoint
• Then and Now - How is Life Different Today?
• Westward Expansion Powerpoint
• How to Put a Head on a Different Body using Paint.NET (Windows)
• How to Put a Head on a Different Body - using Pixlr (Online)
• Anatomy - Skeletal System
• Butterfly Life Cycle Pictures
• Camouflage Activity
• Create a Wanted Poster
• Frog Life Cycle Pictures
• Green Screen Tutorial
• How to Make a Comic
• How to Make a Blinkie
• Stick Figure Animation
• Labeling Plant Parts
• Label The Thirteen Colonies
• Label The World Map
• Common Core Animal Research Graphic Organizer
• Common Core Insect Research Graphic Organizer
• Common Core State Research Graphic Organizer
• Common Core Biography Research Graphic Organizer
• 3rd Grade Facts about Money
• California Regions Brochure
• California Regions Research Help
• Martin Luther King Research
• My Life -Timeline Template
• iWork Family Tree Template
• iWork Tri-Fold Brochure Template
• Numbers First Chart
• iWork Numbers 3D Bar Chart
• iWork Numbers M & M Chart
• iWork Numbers Lemonade Stand
• Anatomy Skeleton Labeling
• Label Parts of Plants
• Your Face on Money
• Scratch - Easy Animal Pong
• Scratch - Froggy Bug Eater
• Scratch - Play Fetch
• Scratch - Shootin' Hoops
• QR Code Generator
• K5 Computer Lab Rules
• Rubric for Presentation / Poster
• Computer Lab Seating Chart Template
• Proper Finger Placement for Keyboarding
• Site Privacy Policy

Excel Lesson Plan- Make Your First Chart

This Excel lesson plan teaches beginning Excel users to enter data and create a simple spreadsheet with a chart. The instructions are for Microsoft Excel, but the data and chart can be recreated using whatever spreadsheet app you have available. When printing the finished excel chart, be sure to have the students use "print preview" to check the proper positioning of the chart and data to fit on a single page before printing. I have used this successfully with 2nd and 3rd graders, but your mileage may vary.

How to Create Your First Chart - Video Tutorial

Time to learn = 25 seconds

First Spreadsheet and Chart - Finished Example:

Excel Party Supplies List

Students can use this list to choose items for their spreadsheet. Students are having a party and have invited several classmates, family members and friends. Students choose at least 6 different foods, drinks, and party gifts that they think their friends will enjoy. Students create a simple spreadsheet and chart using their chosen items.

Download: excel-party-supplies-list.pdf

Excel Tutorial Your First Chart - Printable Instructions:

Download: excel-tutorial-your-first-chart-instructions.pdf

Excel Spreadsheet Rubric for Grading Assignments:

Download: rubric-for-spreadsheet-with-chart.pdf

Excel Spreadsheets and Charts

Simple bar chart, thanksgiving dinner shopping, learn excel in minutes, excel back to school, excel pet adoption, excel sports budget, excel m & m chart, excel lemonade stand.

Practice And Learn Excel Online For Free

Welcome to Excel Practice Online!

Now you can practice Excel everywhere! You can even practice on your mobile phone!

Every function and tool has an explanation followed by an online excel exercise which can be solved within the page itself, no need to download anything – All thanks to the amazing powers of Excel Online!

The tutorials are sorted from beginner level to advanced level. If you like this site please share it with your friends! 🙂

Tip for mobile phone users – tap twice on the cell you want to edit in order to edit it.

• Free Excel Courses and Resources
• Excel Self-Assessment Tool
• Free Excel Online Exercises
• Excel Basics – Zero to Hero
• Excel Tests
• Top 10 formulas and functions in Excel
• Vlookup – Tutorial with Example and Exercise Sheet
• Pivot Tables Tutorial
• Excel Shortcuts – Windows and Mac
• HOT! – Excel Mortgage Calculator – Calculate your mortgage payments and get the payment schedule for the entire period of the loan – Step-by-step tutorial on how to build a Mortgage Calculator in Excel.
• New! Excel Online Cheat Sheet – A Quick Guide To Excel’s Web Version
• Can’t find what you’re looking for? Suggest a tutorial here!
• Excel Basics – Start here if you are new to Excel! Learn how Excel works, how to perform basic calculations, and how to use cell references to save time and increase efficiency!
• Addition (Plus)
• Subtraction (Minus)
• Multiplication
• Excel Shortcuts for Windows – Master Excel Shortcuts to save time and increase efficiency!
• Excel Shortcuts for Mac – Learn how to make the most of Excel on your Mac!

Formulas/Functions

• SUM function – Sum multiple values in Excel
• MAX – find the maximum value in a range
• MIN – find the minimum value in a range
• COUNT – Count numeric values in a range
• COUNTA – Count numeric and textual values
• AVERAGE – Calculate average of a range
• Filtering in Excel – Learn how to filter your data using Excel’s Filter Tool
• Excel Sort – Learn how to sort your data in Excel.
• Flash Fill – Excel’s hidden gem for auto-completing data based on a pattern
• Remove Duplicates – Remove duplicate values in a single column or multiple columns!

Intermediate

Conditional.

• IF function – check if a condition is met
• NESTED IF – Multiple if conditions
• Conditional Formatting – Format Excel Cells based on criteria
• COUNTIF – Count cells in range which meet a certain criteria
• SUMIF – Sum range based on criteria
• AVERAGEIF – Calculate the average of a range based on criteria
• SUMIFS – Sum cells using multiple criteria
• COUNTIFS – Count cells using multiple criteria
• MAXIFS – Find maximum value in a range based on criteria
• MINIFS – Find minimum value in a range based on criteria
• AND/OR – Check if multiple criteria are met (Works great when combined with an IF function!)
• ISBLANK – Check if a cell is blank or not
• VLOOKUP – lookup value and return corresponding value from a table
• HLOOKUP – lookup value and return corresponding value from a table
• Hot!!! XLOOKUP – Excel’s next generation lookup function which combines the best features from VLOOKUP, INDEX MATCH, HLOOKUP and IFERROR/IFNA

Pivot tables

• Pivot Table – Quickly Analyze and Summarize your data using Excel’s most powerful tool!

Text Formulas

• LEFT, MID, RIGHT – Basic Text Functions
• HOT! – TEXTBEFORE & TEXTAFTER – Extract text before or after a delimiter using Excel’s brand new powerful functions!
• HOT! – TEXTSPLIT – Split your text into multiple cells using this super powerful new function!
• TEXTJOIN – Easily combine multiple cells using delimiter
• CONCAT – Combine range of cells without delimiter
• CONCATENATE – Combine two cells or more into one cell
• LEN – Find the length of a cell
• FIND – Find the position of a text within another text (Case-sensitive)
• SEARCH – Find the position of a text within another text (Case-insensitive)
• SUBSTITUTE – Replace text with another text in a cell/expression
• TRIM – Remove extra spaces from the text
• LOWER, UPPER, PROPER – Convert text to lowercase, uppercase and proper case
• VALUE – Convert data stored as text into values
• TEXT – Convert and format numbers into text
• Text to Columns – Quickly split a column into multiple columns using a delimiter. Bonus – Quickly change date formats or convert text to numbers!
• FORMULATEXT – display a formula in another cell as text

Date functions

• DAY, MONTH, YEAR – Extract day, month and year from a date in Excel
• DATE – Create a date from individual values
• WEEKDAY – Return the number of the day of the week
• EOMONTH – Return the date of the last day of the month based on a specific date

Index & Match lookup

• INDEX – Retrieve cell in nth position in a range
• MATCH – Find position of value in a range
• INDEX MATCH – Just like VLOOKUP, only better.

Other advanced tools

• SUMPRODUCT – Sum the products of Excel ranges
• Excel Wildcards – Advanced searching and matching in Excel
• Advanced Filter – Filter by multiple criteria in the same column, or even in different columns!

Power Query

• Combine data from multiple Excel workbooks using Power Query
• Column from Examples tool – Learn the secret to mastering Power Query without any prior knowledge!
• Unpivot columns easily using Power Query

Secret Excel Functions

This section covers Excel functions that are not available in most of Excel’s versions. These functions will unlock a new set of capabilities such as fining only unique values, sorting, and filtering – the tutorials below will help you with mastering Excel’s new functions!

• UNIQUE – Extract unique values from a range
• SORT Function – Sort range dynamically
• SORTBY – Sort range dynamically by using another range
• FILTER Function – Filter range by specific criteria
• RANDARRAY – Create an array of random numbers 
• SEQUENCE – Create a range of sequential values
• LET – Assign values and calculations to names to improve your formula’s ease of use, readability, and performance!
• HOT! – LAMBDA – The mother of all functions that will help you create amazing and powerful custom functions for your own need! 
• VSTACK – Vertically stack arrays/ranges in Excel
• HSTACK – Horizontally stack arrays/ranges in Excel
• CHOOSEROWS – Return specific rows from a range or array
• CHOOSECOLS – Return specific columns from a range or array
• TOROW – Convert a range/array into a single row
• TOCOL – Convert a range/array into a single column

Financial Functions

Learn how to use Excel to make financial calculations!

• Excel Financial Calculator – quickly calculate PV, FV, PMT, NPV, IRR
• PMT – Calculate the periodic payment amount of a loan, mortgage, or another financial instrument
• PPMT & IPMT – Find the Principal and Interest portion of a certain payment
• PV – Find the Present Value of a loan, mortgage, or any other financial instrument 

Excel Macros – VBA (Visual Basic for Applications)

• Start here – How to run your first VBA Macro in Excel without knowing VBA? 

Excel Data Sheets for Practice

Want to do some freestyle practice? Create your own Excel playground with our blank excel Worksheet!

• Excel-Online Blank Worksheet
• Excel Practice Data

How to Calculate in Excel – Excel-Online Calculators

• How to Calculate GPA in Excel
• How to Calculate BMI in Excel
• How to Calculate Density in Excel
• How to Calculate Weighted Average in Excel

Terms and Conditions - Privacy Policy

excel student spreadsheets

All Formats

Resource types, all resource types.

• Rating Count
• Price (Ascending)
• Price (Descending)
• Most Recent

Excel student spreadsheets

STUDENT GROWTH DATA TRACKING SPREADSHEET

High School Student Budgeting Workbook and Spreadsheet

• Excel Spreadsheets

Inclusive Student Progress Monitoring Spreadsheet DIBELS QPA and NWEA editable

MICROSOFT EXCEL : Spreadsheet Formulas Formatting Averages on Student Grade Sheet

Teacher Student Checklist Tracker Spreadsheet Daily Goals

• Google Apps™

MTSS Student Graphing Spreadsheet

• Google Sheets™

Student Tracking Spreadsheet - For Use With Bar Codes or ID Numbers

Track Academic Eligibility & Attendance for Student Clubs Spreadsheet , Google

Excel Spreadsheets with Formulas to Analyze Student Test Data

Fountas & Pinnell: Individual Student Checklist [Data Assessing Spreadsheet ]

Student Learning Objective Data Tracking Spreadsheet - SLO - Editable - Excel

Individual Student Unit Test Tracker Spreadsheet Gradebook - Level 2

Student Intervention Plan Spreadsheet

DIAL 4 Student Record Form Spreadsheet

College Application Tracker | Simple Spreadsheet for Students

RtI (Response to Intervention) or SST ( Student Support Team) Spreadsheet

Campus Student Information Spreadsheet

Student Detention List Spreadsheet

Inventory Spreadsheet | Club Docs | Official Forms | Student Store & Spirit Gear

• Google Drive™ folder

Individual Student Unit Test Tracker Spreadsheet Gradebook - Level 1

Teacher Absence: Student Split List Spreadsheet

Morning SEL Check-In Digital Student Form and Spreadsheet Integration

Student Information Spreadsheet Organizer

Accommodations Spreadsheet for students on an IEP (Special Education)

• We're hiring
• Help & FAQ
• Privacy policy
• Student privacy
• Terms of service
• Tell us what you think

Weekly Student Planner Templates

Students in Middle School and High School need some way to keep track of their assignments and activities. Some schools put together a spiral-bound "student agenda" that each student is required to purchase and use. These "agendas" (I prefer the term "student planner") typically include calendars, school rules, and a lot of weekly planner pages for listing assignments. If your school doesn't provide something like this, you can buy your own student planner or print your own planner pages using templates like the ones on this page.

Printing Two-Sided (Duplex Mode): These 2-page weekly planner pages are designed for printers that can handle printing on both sides of the page. Some instructions are provided on the cover page within each template. If your printer cannot print two-sided, your printer may allow a manual duplex mode (where you flip the pages yourself and reinsert them into the printer). Follow your printer's instructions for manual duplex printing. Experiment with a few pages at first to avoid wasting paper.

Student Planner - Weekday Columns / Subject Rows

⤓ Download XLSX For: Excel 2010 or later

⤓ Download PDF

This is one of the most popular weekly student planners. It lists the weekdays along the top and includes rows for up to 7 different subjects. You can list other activities on the bottom row and weekly action items and notes on the right side of the second page. You only need to edit the subjects on the first page. All the other pages will update based on the first page.

Student Planner - Subject Columns / Weekday Rows

This version lists the Subjects along the top with the weekdays as rows. The to-do and notes sections are included on the second page at the bottom. Like the other templates, the Excel file allows you to edit the subjects listed at the top.

Weekly Student Planner - Basic

This is a basic version that lists subjects along the top and rows for each weekday. It doesn't include an action items or notes section, but it does still include the columns that can be used to check off the daily assignments.

Follow Us On ...

Related templates.

Education Templates

• Health Science
• Business Education
• Computer Applications
• Career Readiness
• Teaching Strategies

«  View All Posts

Computer Applications | Microsoft Office | Microsoft Office Specialist (MOS)

Microsoft Office Lesson Plans Your Students Will Love

• Share This Article

May 18th, 2022 | 9 min. read

Print/Save as PDF

Do you teach middle or high school computer applications classes? If so, it's likely that your standards include requirements on teaching Microsoft Office.

As a computer applications curriculum developer, teachers often ask how we help teach Microsoft Office and prepare students for MOS certification.

While we provide a Microsoft Office curriculum system, our solution may not be the best fit for everyone.

Some teachers are only looking for supplemental resources or tips on improving their existing lessons.

If that's the type of information you're looking for, you're in the right place!

In this article, you'll discover Microsoft Office lesson plans and teaching tips for:

• Microsoft Word
• Microsoft Excel
• Microsoft PowerPoint
• Microsoft Access
• Microsoft Publisher
• Microsoft Office Specialist Certification

For each of these topics, you'll find a list of recommended resources to help you teach the best Microsoft Office lessons possible.

1. Microsoft Word Lessons & Activities

Microsoft Word is often the first jumping off point for many computer applications classes. Rather than spend hours creating your own Microsoft Word lesson plans and activities, wouldn't you like some that you can just integrate into your existing curriculum?

That's where this post can help: Microsoft Word Lesson Plans to Wow Your Students

It contains a number of resources that you can use to teach your middle or high school students to use Microsoft Word.

Want more than just Microsoft Word lesson plans to supplement your existing curriculum?

Business&ITCenter21 has lessons, quizzes, and projects to teach your students all about Microsoft Word.

The curriculum begins with Microsoft Word Essentials, which introduces your students to the basics of the application.

Next, you can use the Microsoft Word Fundamentals lessons to give students a more in depth look at formatting content within a Word document.

Once they have mastered the basics, your students can move on to the Microsoft Word Skills Project to put their skills to the test. The project requires learners to start from scratch and fully create a document.

If you want to take it one step further, you can assign the Microsoft Word Business Project, which requires students to create a job description booklet using more advanced skills.

Looking for additional tips? Read this article: How to Teach Microsoft Word in Middle School

2. Microsoft Excel Lesson Plans

Let's face it--Excel isn't the most exciting Microsoft application out there. So what can you do to spice up your Microsoft Excel lesson plans? Make them relevant to your students!

So where can you find engaging, relevant Microsoft Excel lesson ideas?

Start by reviewing these popular Microsoft Excel lesson plan resources:

• Excel Tutorials from GCFLearnFree.org
• Microsoft Excel Spreadsheets Lesson Plan Bundle from Computer Creations
• Lessons & Activities Bundle for Microsoft Excel from TechCheck Lessons

Each of these resources can help supplement any teacher's lessons on Microsoft Excel.

But what if you need more than a few extra spreadsheet activities?

Our computer applications curriculum has you covered with Excel, too!

The first module in the sequence is the Microsoft Excel Essentials, which provides an overview of working with spreadsheets, cells, rows, and columns. Students also learn about using basic functions and formulas.

Next, students can work through Microsoft Excel Fundamentals. This module provides an overview of the fundamentals of Microsoft Excel, including relative and absolute cell references, common functions, and formatting.

If you need to cover more advanced skills and features within Excel, you can assign the Microsoft Excel Skills Project or Microsoft Excel Business Project.

3. Microsoft PowerPoint Lesson Plans

PowerPoint is sometimes considered to be overused in schools, both by instructors and students. Because of this, it’s important that your Microsoft PowerPoint lesson plans are right on par (or above and beyond!)

Your PowerPoint lessons should be more than just a How-To. You must make sure that your students understand how a presentation can effectively (and ineffectively) be used.

So how can you teach your students to effectively use Microsoft PowerPoint?

We recommend you start with four topics on Microsoft PowerPoint:

• An Introduction to Microsoft PowerPoint
• The Basics of Building a PowerPoint Presentation
• More Features in PowerPoint
• Do’s & Don’ts of Effective Presentations

To find teaching tips and activity outlines, read these articles:

• Best PowerPoint Lessons for Middle School
• 4 Best PowerPoint Lesson Plans for High School 

Need more structure and resources to teach Microsoft PowerPoint?

In Business&ITCenter21, the Microsoft PowerPoint Essentials module provides an overview of Microsoft PowerPoint essentials, themes, templates, and adding and inserting a variety of items into a presentation.

Then, in the Microsoft PowerPoint Fundamentals module, students learn about creating effective presentations that are interesting, engaging, and functional.

Once your students have the basics down, you can move on to more advanced concepts and features with the Microsoft PowerPoint Skills Project and Microsoft PowerPoint Business Project .

4. Microsoft Access Lesson Plans

Microsoft Access can be a challenging subject for middle school and high school students. So it’s no surprise that Microsoft Access lesson plans   are a challenge for computer applications teachers.

To help you save time, we put together a list of popular Microsoft Access teaching resources :

• GCF Learn Free
• Tonya Skinner's Website
• Teachers Pay Teachers

Each of these websites has a variety of materials to help you teach Microsoft Access skills.

In addition, check out the Microsoft Access Fundamentals module within Business&ITCenter21.

This module provides an overview of database theory as students gain practical experience with Microsoft Access.

5. Microsoft Publisher Lesson Plans

Do you give Microsoft Publisher its fair share of attention? Many computer applications educators avid including Microsoft Publisher lesson plans in their curriculum.

We've found that's often because they don’t know where to find good Microsoft Publisher lessons!

To help you get started, we put together a list of popular Microsoft Publisher lessons and activities:

• Tangipahoa Parish School System
• Cape May County Technical School District
• Council Rock High School South
• Rochester Hills Public Library
• Instructables
• Shawano School District
• Microsoft Office Support
• Business&ITCenter21

Each of these resources can help you introduce Microsoft Publisher to your students when added to your existing Microsoft Office lesson plans.

But are you looking for a more structured resource on Publisher? If so, check out the Microsoft Publisher Fundamentals module within Business&ITCenter21.

This module provides an overview of the fundamentals of Microsoft Publisher through the creation of a number of desktop publishing documents.

6. Microsoft Office Certification Prep

In our experience, we've found that teachers searching for Microsoft Office lesson plans are often also interested in preparing their students for the Microsoft Office Specialist certification exams.

To help your students prepare for certification, you most likely need more than just a lesson or two. It might be beneficial to also include test prep material to help your students prepare.

For tips on how to best prepare your students for MOS certification, read these articles:

• How to Prepare Students for the MOS Word Exam
• Steps for Successful Microsoft Excel Test Prep

Start Teaching Microsoft Office Skills Today!

All of the resources and ideas listed on this page can help you put together a great Microsoft Office curriculum.

However, if you're like most computer applications teachers you don't have much time to spare for piecing together a hodgepodge of lessons and activities.

If you need a more robust Microsoft Office solution that helps you teach all of the Microsoft Office applications, consider looking into a full curriculum.

There are many Microsoft Office curriculum options available so it can feel overwhelming to decide which one is right for you.