Basic Function Tables
120+ results
Filters
Grade
Subject
Format
Resource type
Standard
Language
Programs & methods
Supports
How to use Pivot Tables in Excel
Refer to this overview of the Pivot Table function in Excel and Google Sheets to understand it's use in consolidating information in extensive worksheets.
7th - 12th
Math, Order of Operations, Other (Math)
Google Sheets Quiz
Use this Quiz to test students on their ability to use basic Google Sheets functions and shortcuts.
5th - 12th
Business, Other (Math)
" Now You're Talkin'" MathFacts DEMO
Math Facts Excel Spreadsheet is a tool for children to practice their basic math skills. Macros must be enabled for the spreadsheet to work properly. Addition, Subtraction, Multiplication, and Division. This demo only has the addition function enabled, and to save space, the video clip has been removed. Download this free demo, I'm sure you'll enjoy it!
Quiz questions are randomly generated within the parameters you set. If answered correctly, a funny sound clip is played. If answered incorrect
PreK - 7th
Arithmetic, Basic Operations, Other (Math)
Microsoft Excel: No Computer Necessary
This introductory 9-lesson, 6-project unit is specially designed for those without a computer. It covers cell basics, common functions, writing formulas, different types of cell references, using multiple worksheets and more. The nine lessons give ample opportunity for practicing new skills while the projects range from easy to difficult, applying the skills developed in the lessons. While this may be specially designed with "No Computer Necessary," the lessons can easily be adjusted for complet
9th - 12th, Adult Education
Business, Computer Science - Technology, Other (Math)
Also included in: Mastering Microsoft Applications: No Computer Necessary
Seven Financial Math Problems
Lesson consists of seven financial questions which can be solved in Excel. Students who solve these problems will gain a basic understanding of several financial functions in Excel. They will learn how to create an organized spreadsheet. They will also gain some important practical insights on financial issues they are likely to address in the near future.
10th - 12th, Adult Education, Higher Education
Economics , Other (Math)
Microsoft Excel Practice Creating Functions
Purpose: To offer learners scenarios to practice creating functions using Microsoft Excel. Content: Using an Excel spreadsheet to work in, learners are given 10 different basic scenarios and are asked to create functions. This is on an intermediate level, and the content is for practicing what learners have already learned, not to teach the functions themselves. Functions included are AND (), CONCAT (), TEXTJOIN (), LEFT (), UPPER (), AVERAGE (), COUNTBLANK (), IF (), SUMIF (), MAX (), VLOOKUP
11th - 12th, Adult Education, Higher Education
Instructional Technology, Other (Math)
Microsoft Excel Functions Workbook, Volume 1
NOTE: Check out Microsoft Excel Functions Workbook, Volume 2 (BUSINESS MATH)This is an Excel 97-2003 workbook collection of 9 project-based, problem solving spreadsheet exercises (with complete keys - SEE PREVIEW) that help students learn to use the following powerful Microsoft Excel functions: IF CEILING CHOOSE CONCATENATE COUNTBLANK RANK SUM Each exercise generally takes between 1 and 2 full class periods to complete. I take 10-15 minutes to explain the problem, the deliverable, and the tools
8th - 12th, Adult Education, Higher Education
Computer Science - Technology, Other (Math)
Excel for Beginners: Monthly Expenses - Math Worksheet and Spreadsheet Basics
Are your students intimidated by Excel?This introductory activity helps students build confidence with spreadsheets using a familiar, real-world budgeting example. Designed for learners with little to no prior Excel experience, this resource walks students through essential spreadsheet skills such as entering data, formatting values, writing formulas, and troubleshooting common errors. Students will learn how to: Navigate a spreadsheet (rows, columns, and cells) Enter and format numeric data cor
11th - 12th, Adult Education, Higher Education, Not Specific
Financial Literacy, Money Math, Other (Math)
Trig Functions Blank Sheet
Convert radians to degrees and find the six trig functions for each angle that's a multiple of 30 degrees and 45 degrees between 0 degrees and 360 degrees.
Betty Watson
Sin Cos Chart by Betty Watson is licensed under a Creative Commons Attribution-Noncommercial 3.0 United States License.
11th - 12th
Geometry, Other (Math), PreCalculus
Microsoft Excel Functions Workbook, Volume 2 (BUSINESS MATH)
NOTE: Check out Microsoft Excel Functions Workbook, Volume 1! This is an Excel 97-2003 workbook collection of 15 project-based, problem solving spreadsheet exercises (with complete keys - SEE PREVIEW) that help students learn to use the following powerful Microsoft Excel functions: SUM AVERAGE IF COUNTIF COUNTBLANK Each exercise generally takes between 1 and 2 full class periods to complete. I take 10-15 minutes to explain the problem, the deliverable, and the tools, and then let the students w
8th - 12th, Adult Education, Higher Education
Computer Science - Technology, Other (Math)
Create a Basic Spreadsheet Game Using Excel (BUNDLE)
Bundle includes: The Free Resource “Step-by-Step Programming for a basic Excel Spreadsheet Game” (instructions on how to program / format the game in Excel) AND “Excel Spreadsheet containing actual worksheets for a basic game” 10 already programmed / formatted games in an Excel workbook / worksheets for Students to use as a guide as they create their own version of a spreadsheet game by modifying the existing worksheets using the above-mentioned Free Resource. OR Students can just use the progra
6th - 11th
Mental Math, Order of Operations, Other (Math)
Modeling with Sinudoidal Functions - Foxes and Rabbits
Sinusoidal functions are a staple of Algebra 2 and Pre-Calculus but the modeling problems in the textbooks are always so dry. I can't stand any more weights on a spring or riders on a ferris wheel! I wanted to make a problem that would be more interesting than the classic textbook tropes and I also wanted students to experience data that could be modeled this way. Of course, data is never perfect so the data provided here can be modeled with sine or cosine but no model will completely exact.
10th - 12th
Applied Math, Math, Other (Math)
CCSS
HSF-TF.B.5
Superimposing Wave Functions on a Spreadsheet (Physics)
Provided:
-Step by step instructions on how to model superposition of waves starting from a blank Excel (2007 or 2003) spreadsheet
-Discussion section outlining objectives.
-Assessment questions
Appropriate for all levels of high school Physics. Applying spreadsheets to study science provides students with skills essential to success in higher education. This activity gives students an interactive experience manipulating variables and observing the resulting wave functions.
******Assessm
9th - 12th
Other (Math), Physical Science, Physics
Excel Spreadsheet containing actual worksheets for a basic game
Purchase this Programmed / Formatted Excel Spreadsheet from Bob Gnibus in TPT – Teachers Pay Teachers to play the game OR for Students to use as a guide as they create their own customized spreadsheet game. A Free Resource is available on TPT – Teachers Pay Teachers (see separate TPT listing) which provides instructions on how to program the Game in Excel. The Free Resource includes Step-by-Step programming instructions for a basic Excel Spreadsheet Game, including game format suggestions and de
6th - 12th
Basic Operations, Order of Operations, Other (Math)
Also included in: Create a Basic Spreadsheet Game Using Excel (BUNDLE)
UNLIMITED Customizable Basic Math Worksheets
QUICK OVERVIEWThis isn't ONE worksheet! This is the never-ending gobstopper of all worksheets! This is a program that generates a new worksheet (to any level you set). Unlimited amount of worksheets (and answers) for ADDITION, SUBTRACTION, and/or MULTIPLICATION of numbers under 10, 20, 50, OR 100 (you choose, to make a perfect worksheet tailored to each individual student)! Best for elementary students or middle school students that need to refresh the basics. But also great for late middle
2nd - 9th
Basic Operations, Math, Other (Math)
FINANCIAL LITERACY--Introduction to Spreadsheets and Basic Spreadsheet formulas
FINANCIAL LITERACY This step-by-step easy to follow lesson includes 4 files which introduces the student to spreadsheets concepts and the basic formulas required to complete spreadsheet exercises. NOTE: This lesson can be administered ONLINE or in a PHYSICAL SETTING The exercise teaches the student the following concepts: a. Basic spreadsheet terminology b. The SUM formula to add a range of cells c. The MAX formula to find the highest number in a range of cells d. The MIN formula to find
9th - 12th
Business, For All Subjects, Other (Math)
Reference Sheet Trig Functions
Completed table for six trig functions and radian measure for all angles between 0 degrees and 360 degrees that are multiples of 30 and 45.
Betty Watson
Completed Trig Functions Chart by Betty Watson is licensed under a Creative Commons Attribution-Noncommercial 3.0 United States License.
11th - 12th
Geometry, Other (Math), PreCalculus
Conversions (Functions Project)
This project is two-fold, in that students are required to solve a literal equation, and then use that literal equation to make repeated calculations in Google Spreadsheet (or Microsoft Excel).
This includes instructions for the project, a rubric, and instructions for suggested technology applications.
**I created this project because my students were not seeing the necessity in being able to solve a literal equation (an equation with multiple variables). When I explained that sometimes you
7th - 10th
Algebra, Algebra 2, Other (Math)
Z and t Distribution tables
Statistics t and Z distribution tables. The Z table is for the positive half of the standard normal curve. The tables were created for use with college statistics courses, but can be used with high school courses as well.
11th - 12th, Higher Education
Math, Other (Math)
Math Times Tables Practice
The old school way of practicing times-tables.... repetition! You can use these for morning work practice or homework practice. Instead of writing the full facts out ( 2x1=2, 2x2=4, 2x3=6), write each fact down the column repetitively. This will help students memorize the facts better because of the fine motor coordination in a repetitive manor. (2x2=4, 2x2=4, 2x2=4). I make my kids do one of the fact sheets every night and they are becoming fact masters!!! This excel spreadsheet has a tab for
1st - 7th
Arithmetic, Math, Other (Math)
CCSS
3.NBT.A.3
, 4.NBT.B.5
Multiplication Tables (0 to 20)
This is a handy and easy to read one and two digit multiplication tables chart that covers from 1 to 20 with answers. Great one page quick reference!
2nd - 12th
Math, Math Test Prep, Other (Math)
Modeling Daylight Length with Trig Functions Data Set
This is the data set needed to complete the activity Modeling Daylight Length with Trig Functions.
9th - 12th
Other (Math)
Also included in: Modeling Seasonal Daylight Length with Trig Functions
5th Grade Basic Geometry Anchor Chart
This is an anchor chart that displays the basic understanding of geometrical shapes.
5th
Other (Math)
CCSS
5.G.B.3
, 5.G.B.4
Showing 1-24 of 120+ results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands