To apply data validation rules to a selected cell or range, head to the "Data" tab on the ribbon, and click the top half of the "Data Validation" icon if you're using a wide screen, or the left half ...

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.

You may need to add cells in Google Sheets if your spreadsheet needs to contain more information than it currently has room for.