ISM3004 EXAM 2 EXCEL QUESTIONS AND VERIFIED
ACCURATE ANSWERS
Command (ctrl) <- -> ^ (down) - Answers - Jumps to the border of emptiness and data
Command Home (Fn+Left Arrow) - Answers - Immediately go to the top right corner of
the data
Command end (F9+Right arrow) - Answers - Immediately go to the bottom left corner of
the data
Command pg up(Fn +Up arrow) - Answers - Move up one sheet
Command pg up (Fn+down arrow) - Answers - Move down one sheet
Ctrl-Command-Enter - Answers - Manually force new line
How to Clear text - Answers - -Right click- clear contents
-or hit delete
-or you can clear formatting but keep data
Insert Copy Cells - Answers - Select the Row/ column
Ctrl-C to copy
Right click your destination- choose "insert copied cells"
Hiding - Answers - Right click column then click hide
What Problems should you use Freeze Panes for? - Answers - When your column
headings disappear when you scroll down but you want them to stay
How to use Freeze Panes - Answers - Take Curser & put it right below headings, go to
"view" and click freeze pane
now when you press ctrl home you go back to the freeze pane area
to keep ABC1,2 put your curser in D3
How to Rapidly enter a range of data - Answers - o Type your first number then take
your curser to the bottom right corner of your cell
Drag this all the way down to copy, click the button and you have options to include a
series or other choices
o Hit tab to go to the next row hit enter to go down the next column
Instantly set a column width to optimum size - Answers - Double click the border
between two columns
or click the column and chose wrap text
ACCURATE ANSWERS
Command (ctrl) <- -> ^ (down) - Answers - Jumps to the border of emptiness and data
Command Home (Fn+Left Arrow) - Answers - Immediately go to the top right corner of
the data
Command end (F9+Right arrow) - Answers - Immediately go to the bottom left corner of
the data
Command pg up(Fn +Up arrow) - Answers - Move up one sheet
Command pg up (Fn+down arrow) - Answers - Move down one sheet
Ctrl-Command-Enter - Answers - Manually force new line
How to Clear text - Answers - -Right click- clear contents
-or hit delete
-or you can clear formatting but keep data
Insert Copy Cells - Answers - Select the Row/ column
Ctrl-C to copy
Right click your destination- choose "insert copied cells"
Hiding - Answers - Right click column then click hide
What Problems should you use Freeze Panes for? - Answers - When your column
headings disappear when you scroll down but you want them to stay
How to use Freeze Panes - Answers - Take Curser & put it right below headings, go to
"view" and click freeze pane
now when you press ctrl home you go back to the freeze pane area
to keep ABC1,2 put your curser in D3
How to Rapidly enter a range of data - Answers - o Type your first number then take
your curser to the bottom right corner of your cell
Drag this all the way down to copy, click the button and you have options to include a
series or other choices
o Hit tab to go to the next row hit enter to go down the next column
Instantly set a column width to optimum size - Answers - Double click the border
between two columns
or click the column and chose wrap text