Select cell D4 and Enter the formula: =0.01*B4
Drag/Copy the formula from D4 up to D12
Select range from D4 to D12 –> Conditional Formatting –> Highlight Rules –> Greater than –> 10
Select cell B13 and enter formula : = Sum(B4:B12)
Drag/Copy the formula from B13 up to E13
Select cell E4 and enter the formula: = B4-C4+D4
Drag/ Copy the formula from E4 up to E12
Select B14 and enter formula : =Average(B4:B12) and Drag/ copy formula up to E14
Select B15 and enter the formula: =MIN(B4:B12) and Drag/ copy formula up to E15
Select B16 and enter formula : =Max(B4:B12) and Drag/ copy formula up to E16.
Save the Excel file with your name and Upload Excel File.
