Display a drop down list of the values in the current column of a range ?
Alt + Left Arrow
Alt + Right Arrow
Alt + Down Arrow
Alt + Up Arrow
In a formula, display the Insert Function dialog box
SHIFT+F2
SHIFT+F4
SHIFT+F3
SHIFT+F5
Insert an AutoSum formula with the SUM function
ALT+ - (minus sign)
ALT+= (equal sign)
ALT+ %
ALT+ !
Copy the value from the cell above the active cell into the cell or the Formula Bar
CTRL+' (apostrophe)
CTRL+SHIFT+" (quotation mark)
CTRL+SHIFT+ &
None of the Above
Copies a formula from the cell above the active cell into the cell or the Formula Bar
CTRL+SHIFT+ !
Fill down
CTRL+D
CTRL+SHIFT+"
All the Above
Key to Edit a cell comment ?
SHIFT+F12
SHIFT+F8
to Delete text to the end of the line
ALT +DELETE
CTRL+DELETE
SHIFT +DELETE
key to Display the Style dialog box
ALT+ #
ALT+ $
ALT+' (apostrophe)
ALT+" (quotation mark)
to Display the Format Cells dialog box
CTRL+ 1
CTRL+ 2
CTRL+ 3
CTRL+ 4