Correct Answer : F9
Explanation : Manual calculation mode means that Excel will only recalculate all open workbooks when we request it by pressing F9. It allows to choose whether we want to update formulas in worksheets or entire workbook.
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".