Correct Answer : Insert
Explanation : The header and Footer option is available in the "Insert" Menu. We can insert the Header and Footer in the sheet by clicking on the "Header and Footer" option from "Text Group" in the "Insert" Menu.
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".