Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
minLevel1
maxLevel6
outlinefalse
stylenone
typelist
printablefalse

...

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.

...

Warning

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.

  1. Type of formula in Cell A1. Only use regular text and no symbols.

    Area of a circle equals pi r squared now has a text version.
  2. Now change the Font Color to white to match the background.

    Change Color Button in Excel.Mathematic Equation for the Area of a Circle covers multiple cells.Image Modified

...

  1. Resize cell A1 and fit your formula inside it. Now you have a formula with a hidden text alternative

...

  1. , but will still be read by a screen reader.

    The equation Area of a Circle equals pi r squared now fits in one cell.Image Modified
Info

Note: You can use this method for many formulas, including expressions.

...

Tip

The formula is now in one cell and all of the information is given with a text description.

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.

...

Tip

These formulas are all written in text form. Now screen readers can read the information to the reader without too much risk of errors.

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, put a text name and abbreviation type in the name of the formula directly and an abbreviation above the cell that contains containing the value outputresults.

...

Warning

This example shows a function calculating the sample standard deviation for some data. Though this is accessible, it does not contain the name of the function or abbreviation.

...

Tip

This example shows a function with a name and abbreviation. This is the best way to display functions.

...

Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@82d
sortmodified
showSpacefalse
reversetrue
typepage
labelskb-how-to-article
cqllabel = "kb-how-to-article" and type = "page" and space = "AN"