Creating Lt Spreadsheet Panels

The Spreadsheet panel can be used to display a read only spreadsheet in your lessons. Authors can use the spreadsheet to display results of calculations on tabular data. Spreadsheet cells can contain numerical or text data, or the results of formulae that automatically calculate values based on the contents of other cells.

Note: The Table, Table Question, Spreadsheet, and Spreadsheet Question panels have similar features and functionality. For information on the differences between these panels, see Table and Spreadsheet Panels in Lt.

To add a Spreadsheet panel, select PANELS from the footer, then Basic from the PANELS menu as shown below:

Editing your Spreadsheet

Drag and drop the Spreadsheet icon to the desired location on the page. To customize your spreadsheet, select Edit. Now you'll see three editing menus below your spreadsheet.

To add or delete rows/columns, select the row or column buttons, then the action you wish to take.

 

To edit the width of columns, simply drag the edge of a cell border in the spreadsheet header.

You can set the data display to Number or Scientific, and adjust the number of decimal places from 0–9 by selecting the – and + buttons.

 

You can also make the first row or column a fixed header by selecting the header option from the bottom of the dropdown menu.

Calculations

Functions can be copied or entered directly into spreadsheet cells. Double-click on a cell to enter or edit the calculation formula.

Here is a full list of functions that can be used in the Spreadsheet panel.