Formulas and Functions in Microsoft Excel

A learning object to illustrate the right way to enter formulas and functions in Excel.

In this learning activity you'll create strategies for sending and receiving complaints and requests.

In this interactive object, learners complete dental formulas for various species of animals.

Students read an explanation of chemical formulas in this animated activity. A quiz completes the object.

Use Ohm's law, Watt's law, and the power equation to derive formulas for the DC power wheel.

In this module we will explore some commonly used formulas for area and volume.

Learners follow a four-step process to determine the empirical formula of a compound from the masses of its constituent elements. The molecular formula is determined in a fifth step using the molecular weight of the compound.

In this learning activity you'll identify abbreviations that represent quantities associated with electrical circuits.

Students view the formulas to be used to convert a parallel impedance to a series impedance.

Students use algebra to rearrange formulas and solve for the missing volume, density, or mass quantity.

The inverting amplifier configuration is presented. The closed loop voltage gain and the closed loop bandwidth formulas are explained, along with the concept of negative feedback.

Learners study the properties of a regular square pyramid and use geometric formulas to find volume and surface area.

In this interactive object, learners identify charges on ions, write new formulas based on charge, and balance equations using coefficients.

Students examine the full-wave rectifier. They review appropriate formulas and examples of actual circuits.

Students read how to calculate the size of a hydraulic cylinder that is required for a particular application. Mathematical formulas are provided.

In this animated object, learners examine the formulas used to convert peak, RMS, average, and peak-to-peak AC voltages. A brief quiz completes the activity.

Learners examine the formulas that are used to determine the proper PID values to be entered into a controller using the Ziegler-Nichols Continuous Cycling Tuning Method.

Students are introduced to the non-inverting amplifier configuration. The formulas for closed loop gain and bandwidth are shown, and an example is given.

Students read the terms associated with the Bipolar Junction Transistor (BJT) . They also view formulas for dc current and voltage.

Learners review the three formulas for power and work 12 problems. In each of the problems, students are given two of the three variables (voltage, resistance, or current) and asked to solve for power. Immediate feedback is provided.