Hi there, please help me with these excel question. Provide a reason for each below.

Question: Which one of the following is true for Conditional Formatting technique in Excel ? Order of rules for Conditional Formatting is important, We can apply multiple Conditional Formatting to a single columns 0 "Data bars" and "Cell Rules" are two techniques used in Conditional Formatting. O Conditional Formatting is a quick tool to visualize data when certain conditions are met. All of the above Question: The following picture shows sales data for 4 companies. They produce two products, coffee and cocoa. Determine for each part how we can obtain the highlighted results using Conditional Formatting. Date Product Company Amount 20180409 -company A $1,048.00 201805-26 company A $1,430.00 2018-1207 Cocoa company A company A Total $2,928.50 20181105 company B $1,000.50 201807-12 company 3 $900.63 20180602 company B company 3 Total $2,461.53 20180830 company C $1,100.00 201807-26 company C $1,525.00 7' 20180924 company C $990.00 L 201810-30 company C 20180826 Cocoa company C $1,125.00 , 20180707 Cocoa company C C 201806-26 Cocoa company C $1,690.00 20180707 Cocoa company C company C Total $8,464.00 20180118-company D $1,220.00 201802-13 Cocoa company D $980.00 201812-18 Cocoa company 0 $1,100.00 20180343 Cocoa company D $960.00 company D Total $4,260.00 For the column "Product" we used conditional formatting to highlight coffee from two products. I) Which \"rule type" is used to create the result? For the column "Amount" we used conditional formatting to highlight some values from others. ii) If we used "Format values where this formula is true", which one the following formulas can produce the highlighted results? i) Rule type: 0 Format only unique or duplicate values 0 Format cells based on their values 0 Format only cells that contain 0 Format only values that are above or below average \f