MS Excel Chapter 8: Math, Equations, and Formulas
- Daniel LaGrow
Instructions
Most formulas and math equations come as floating objects. Such objects cannot be read by a screen reader and are therefore, inaccessible. To avoid inaccessible content being sent, we must find a more accessible solution for how to write our formulas.
This equation is a floating object and spreads out over multiple cells. This is inaccessible, and overall does not look presentable.
Section 8.1: How to make a Floating Object with an Alt Text
When you create your formulas, you always want to be sure you have a text alternative in Cell A1. This will make it easier for screen readers to read the information. Also, make sure you do not use any symbols for the alternative text and only use words. This is because screen readers can only read a few symbols.
Type of formula in Cell A1. Only use regular text and no symbols.
Now change the Font Color to white to match the background.
Resize cell A1 and fit your formula inside it. Now you have a formula with a hidden text alternative, but will still be read by a screen reader.
Note: You can use this method for many formulas, including expressions.
Section 8.2: Math Equations without Floating Objects
The best way to create an equation that is accessible is to type out the whole equation without symbols.
These equations are written out in the traditional way. Screen readers would not be able to read the equations the way they are written. This table is therefore, inaccessible to many readers.
Section 8.3: Excel Functions
Most Excel functions are accessible for readers, and can be read by both JAWS and NVDA. However, the software will only read the formula character by character. This process can take a long time to complete and can be very time consuming for the students. To avoid this issue, type in the name of the formula and an abbreviation above the cell containing the results.