I also reviewed Bottom Part of Software Window Hidden, but the only answer suggests experimenting with text size and mine is set to the standard 100%. I reviewed Windows 7 – bottom of applications hidden by taskbar, but the only answer (try a higher screen resolution) does not apply (I am using the highest available resolution). I do not have the taskbar set to auto-hide, and don't want to use that setting. I am using Excel 2016 on Windows 10, but I believe this also happens on Windows 7 and with any version of Excel that has a separate window for each workbook.
This is annoying as it means I have to reposition the window in order to see Excel's tabs.
However Excel doesn't do that and will place new windows with the bottom part hidden behind the taskbar. Most Office applications (such as Word) account for the taskbar, and will place the new window at the top right of the screen rather than with part of it hidden behind the taskbar. On the right, scroll down to the More Options section. In the Personalization window, switch to the Colors tab. In the main Settings window, click Personalization. To change the color, press Windows+I to open the settings interface. 'Cascaded' means it is located a little lower and to the right of the previous window unless that would put the bottom right of the window outside the screen, in which case the window is located at the top right of the screen. In Windows 10, the default color of the taskbar is black.
In Microsoft Office applications, when a new window (that is not maximised) is opened, it is sized the same as the previous window and is cascaded.