Question

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

Answer 1

Answer with Explanation:

(i) Rich Conditional Formatting

It is very useful feature of spreadsheet that occurs in home tab in styles section. Mostly, it is useful during concluding highest, lowest and in-between numbers in selected cells. It contain 3 main option Highlight cells rules, Top/bottom rules, clear rules.

• By use of highlight cells rules we also check duplicate value in data, compare value as greater, lesser and equal, highlight specific text and also produce a custom rule.
• By use of Top/bottom rules we check Top and bottom specific numbers of items also check average and percentage.  
• Clear rule option is used to clear the already applied rules on sheet or on entire book.

(ii) Freeze panes feature​

It is very interesting feature of spread sheet by use of freeze pane option we also freeze a desire area on spread sheet. You also view freeze area on spread sheet after scroll down.

Related link:

https://brainly.in/question/13873937