Correct Answer : Apostrophe (‘)
Explanation : An apostrophe before a cell value forces Excel to interpret the value as label. This is mostly useful for values that look like a number or date.
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".