Question

(a) Explain the following features of a spreadsheet(1) Rich Conditional Formatting(i) Freeze panes feature​

Answer 1

Answer:

Auto format feature of spreadsheet:

• Auto format feature of spreadsheet is useful in speeding up formatting work.

• It allows us to speedily apply a preset formatting on a data set that has one header row and one header column.  

Auto sum feature of spreadsheet:

• It adds together a range of cells and displays the total in the cell below the selected range.  

• For example, if we want to add the values of cells between A1 and A5, highlight cells A1 through A5 then we have to click the AutoSum button.

Explanation: