If you want to create multiple worksheets in multiple Excel workbooks, you can set the default number of worksheets when you open Excel.

The formula to add multiple rows in Google Sheets is the same as the formula used in Excel. Type =SUM (cell range of first row, cell range of second row, cell range of third row, …) and hit Enter.