To repeat the last action F4 To calculate the worksheet in all open workbook Ctrl+Alt+F9 To rechecks dependent formula Ctrl+Alt+Shift+F9 To define the name Ctrl+F3 To create the names in…