Correct Answer : ALT + =
Explanation : The keyboard shortcut to insert a SUM formula is "ALT + =". For this, select the cell range and press "ALT+=". You will get the SUM of the values of the selected range.
Correct Answer : CTRL + TAB
Correct Answer : CTRL + SHIFT + "
Explanation : The keyboard shortcut to copy the value from the cell above the active cell into the cell or the Formula Bar is "CTRL + SHIFT + "".
Correct Answer : CTRL + 1
Explanation : The keyboard shortcut to display the Format Cells dialog box is "CTRL + 1".