Department of Defense
Do Dea: Spreadsheet Software: M2:l3: Working Smarter: Copy Formulas and Functions
In Module 2 Lesson 3 of this course on spreadsheets, students learn how to save time when setting up a spreadsheet by copying functions and formulas. Includes slideshow tutorials.
Goodwill
Gcf Global: Excel Formulas
In this interactive tutorial, learn how to create formulas to solve real-world problems.
Goodwill
Gcf Global: Excel Formulas: Functions
A function is a predefined formula that performs calculations using specific values in a particular order. All spreadsheet programs include common functions that can be used for quickly finding the sum, average, count, maximum value, and...
Department of Defense
Do Dea: Spreadsheet Software: M3: L2: In the Library: Calculate With Functions
In Module 3 Lesson 2 of this course on spreadsheets, students learn about naming cells and cell ranges and how a name moves with the range it is attached to. Names can also be used in constructing absolute cell reference formulas....
Goodwill
Gcf Global: Excel 2016
A website with 33 links plus a quiz on how to use Microsoft Excel 2016. Topics include Excel 2016 Basics, Working with Cells and Sheets, Formulas and Functions, Working with Data, Doing More with Excel, and Extras.
Department of Defense
Do Dea: Spreadsheet Software: M2: L2: Shortcuts Anyone? Calculate With Functions
In Module 2 Lesson 2 of this course on spreadsheets, students learn how to use the built-in functions in Excel so that they don't have to retype a formula each time they use it. Includes slideshow tutorials.
University of Illinois
University of Illinois: Quadratic Formula
This site from the University of Illinois offers an excellent simulation of the quadratic formula, where you can type in different values for a, b, and c, and then view the change in the answer for x.
Department of Defense
Do Dea: Spreadsheet Software: M2: L5: Show Me Your Skills: Practice Skills
In Module 2 Lesson 5 of this course on spreadsheets, students review what they have learned in the previous four lessons about formulas, functions, and manipulating a spreadsheet. Content is stored in the Resources section. Practice...
Royal Society of Chemistry
Royal Society of Chemistry: Gridlocks: Level 3
A collection of grid puzzles that cover a wide variety of topics in advanced high school chemistry. These are excellent for topic review and reinforcement. The puzzles can be played online and also downloaded as worksheets. Answers are...
Other
Personal: Let's Go Shopping
This personal site provides a student activity that allows learners to practice spreadsheet skills in inputting data and creating function formulas. The activity is based on the collection and comparison of shopping receipts using max,...
Other
Tonya Skinner Business Ed Lesson Plans: Grocery Shopping
This personal site provides a student activity that allows learners to plan a class party while organizing the budget details in a spreadsheet program. Learners will demonstrate computer skills in inputting data, formatting data, and...