What is the main advantage of preparing a spreadsheet template?

It automatically shows calculated results as values are entered

The correct answer is option 3- It automatically shows calculated results as values are entered.

Whenever we have to use a spreadsheet for any computations, the first step is to plan its layout and the template specifying the sequence of various columns, etc. The template also includes identification of cells, which will contain formulae. The advantage of preparing the template is that as a user puts in the values in the spreadsheet, the calculated results are shown correspondingly. A table giving the contents of various columns is a helpful tool to represent the template of a spreadsheet.