One common example to apply cell protection to spreadsheet entries is to protect a formula used in the sheet to calculate payouts or rankings for example. A manager might want to share the results of the team to all its team and provides some ranking or other form of calculations in the sheet. He then needs to protect the formula so it's not altered by the team members or anyone else reviewing the file.
