Useful Keyboard Shortcuts Format any selected object, press ctrl+1 Insert current date, press ctrl+; Insert current time, press ctrl+shift+; Repeat last action, press F4 Edit a cell comment, press shift + F2 Autosum selected cells, press alt + = Recalculate formulas, press F9 Select data in current region, press ctrl+shift+8 See formulas in the worksheet, press ctrl+shift+` (ctrl+~) While editing formulas to change the reference type from absolute to relative…