Correct Answer : Divide
Explanation : Paste Special allows Divide operation while you paste to new cell.
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".