Validation is the feature that can limit what is entered into cells in Excel.
While Lotus continued with a DOS interface, Excel utilized the graphic interface of Windows. This provided easier highlighting, formatting, and cut/copy/paste/move features.
The Fill feature can do that.
The Auto Filter option.
The Goto Special command.
This feature is called Excel Slicers. See related links.
The Sort feature.
Rows are identified by numbers in Excel.
Bullets are not a feature of Excel. They are found in other applications. They have no use in Excel.
By using the Autosum feature. Select the cell below the last number and click on the Autosum and it will automatically total the numbers in the column.
Yes. Excel can display numbers as percentages. Do you have a question?
The general opinion is that Excel is better than Numbers.
The Fill Series feature allows you to do this.