Substitute a value into a recently calculated regression line to determine a predicted value.

After finding a linear regression model for a bivariate data set, residuals are calculated and plotted to check suitability of linear model.

Create a simple sequence and then extend the spreadsheet using Cut and Paste technique.

Create the Fibonacci sequence, adjust columns widths, use the Fill Range command to extend the sequence and display very long integers.

Create a geometric sequence including the sum of terms and extend using Tap and Drag technique.

Create a pie chart, determine the percentages represented by each sector and dynamically modify.

Create a flexible Simple Interest spreadsheet using Absolute and Relative cell references and extend by copying and pasting multiple columns.

Create a flexible Compound Interest spreadsheet using Absolute and Relative cell references and format cells to 2dp.

Use a spreadsheet to examine the balance of a reducible interest loan.

Use a spreadsheet to examine the balance of an annuity.