Versions Compared

Key

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

\uD83D\uDCD8 InstructionsInstructions

Section 3.1: Data Flow

When creating text for a table, always try to make it easily readable and have good flow. Have the text go left to right and up and down. Each table has sections to keep in account, the title, headings, and data. The title of the table must always be at the top. Underneath the title is where the headings would go. They describe what the data will represent. The data itself will go inside the table in a cell next to or under the headings.

...

  1. Create two tables.

    Two tables about the population of countries. The top 5 biggest counties are at the top, the top 5 smallest countries are at the bottom. There are multiple lines of separation between the tables.
  2. Click the numbers of the rows you want to delete.

    Rows 8 and 9 are highlighted.
  3. Right click, select delete rows or columns. Now you have a much more organized spreadsheet.

    Two tables on country population with only one row of separation between them.
  4. For tables that have blanks in them, just type in simple words or abbreviations. Examples of these include, N/A, or “No Data.”

...

Warning

This table leaves the main exports of Japan, Germany, and the Netherlands completely blank. If a screen reader were to read this, it would completely skip the blank cells and confuse the reader.

...

Our example of an Index Sheet will be for budgetsTotal Monthly Sales. To create an Index sheet,

  1. Create several spreadsheets.

  2. Name the first sheet “Index”“Index Sheet”, then give appropriate names to the rest of the spreadsheets.

    The Worksheet section of Excel with Worksheets named Index, January, February, and March.Image RemovedThe spreadsheets with the names Index Sheet, 2017 Data, 2016 Data, 2015 Data, and 2014 Data.Image Added
  3. In the Index Spreadsheet, type in the names of your spreadsheets. One name per cell.

    The Index Spreadsheet with the names of each spreadsheet in their own cell.Image RemovedIndex Sheet Example.pngImage Added
  4. Right click your first spreadsheet name. In the dropdown menu, click Link. In the Insert Hyperlink box, click “Place in This Document”. Click the name of the spreadsheet you want the link to connect to. It is possible that your Text to Display may have a syntax code in it. Delete it and type in a name that suits your spreadsheet. Click OK.

    Insert Hyperlink box with the text to display as January. Link to is Place in this Document.Image RemovedInsert Hyperlink box with the text to display as 2017 Data. The Link to section has is set to Place in this Document. 2017 Data is selected.Image Added
  5. Your link is made. Click on it and you will be taken to the spreadsheet it is linked to.

    The Index spreadsheet with January set as a link. The link has blue text and is underlined.Image RemovedThe January Expenses worksheet is open.Image RemovedThe Index spreadsheet with 2017 Data set as a link. The link has blue text and is underlined.Image AddedThe 2017 Data spreadsheet is open showing the Total Monthly Sales for 2017.Image Added

Section 3.7: Headers and Footers

...

Warning

This header includes very important information. Screen readers might not read this to a student which would cause a lot of confusion when the spreadsheet is changed.

...

Tip

This header does not have anything important inside it. All of the important information is placed in Cell A1. The text will be the first thing the screen reader reads and the reader will be aware the warningThe header information has been moved to cell A1.

Section 3.8: Hidden Rows and Columns

...

Tip

This table has multiple columns hidden. However, a comment is shown giving instructions on how to access the missing data.

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"