Question

Answer the following
(a) Define the Conditional Formatting
(b) Distinguish between sorting and filtering,
(cWhat is the difference between Line chart and Area Chart?​

Answer 1

Answer:

(a) Conditional formatting is a feature in many spreadsheet applications that allows you to apply specific formatting to cells that meet certain criteria. It is most often used as color-based formatting to highlight, emphasize, or differentiate among data and information stored in a spreadsheet.

(b) Essentially, sorting and filtering are tools that let you organize your data. When you sort data, you are putting it in order. Filtering data lets you hide unimportant data and focus only on the data you're interested in.

(c) Line charts are good at showing multiple different series and comparing them against each other. ... Area charts show a filled area below the quantity line. This fill can obscure other data series that are on the same chart.