The Spreadsheet Question panel allows students to enter data, perform calculations, and interact with spreadsheet cells. It is useful for data analysis tasks and structured problem-solving activities.
Cells can contain text, numerical values, or formulae that automatically calculate results based on other cells.
Note: The Table, Table Question, Spreadsheet, and Spreadsheet Question panels share similar features. For more information on when to use each, see Table and Spreadsheet Panels in Lt.
To add a Spreadsheet Question panel, select Panels from the footer, then choose Questions from the Panels menu. Drag and drop the Spreadsheet Question panel onto your lesson page.
Editing your Spreadsheet Question panel
To add your question or instructions, select Edit, then enter text in the question field.
You can customise the spreadsheet by adding or removing rows and columns, adjusting column width, and applying formatting options. For more information, see the Spreadsheet panel guide.
You can also access supported formulae and functions using the Help (?) button in the panel footer, or refer to the full list of functions.
Using read-only cells
To prevent students from editing specific cells, select the cell and enable the Read Only option.
Performing calculations
Students can perform calculations directly within cells. To enter a formula, double-click a cell and begin with an equals sign (=).
For a full list of supported functions, see the Formulae and Functions documentation.