EXCEL CRASH COURSE TEST PAPER ANSWERS AND
QUESTIONS SURE A+
✔✔splitting panes - ✔✔splitting panes allows users to scroll in both areas of the
worksheet, while rows and columns in the non-scrolled area remain visible
to split panes:
-click the cell BELOW the desired row and to the RIGHT of the desired column where
you want to split panes and hit *Alt w s*
-to unspilt panes, click *Alt w s* again
-press *F6* to move from pane to pane in a clockwise direction; press *Shift F6* to
move from pane to pane in a counter-clockwise direction
✔✔manipulating data inside a cell - ✔✔*F2* is the command that puts you inside a cell:
-pressing the F2 key once shows you the components of the formula you created
earlier, puts you inside a cell and enables you to navigate through it to edit the existing
cell data
-pressing the F2 key twice activates the cursor and enables you to move to different
cells, worksheets, and even other open Excel files
*Shift arrow key* will highlight characters one at a time
*Shift Ctrl arrow key* will highlight contiguous ranges of characters
✔✔deleting and clearing cell data - ✔✔hitting *Delete* does NOT delete the formatting
in the cell
to truly delete a cell:
-*Alt h e* (Home tab > Clear)
-from the drop-down, chose the appropriate actions
*(Alt h e) a*: clears ALL contents of the cell
*(Alt h e) f*: clears only the cell FORMAT
*(Alt h e) c*: clears only the cell CONTENT
-this is the same as hitting Delete
*(Alt h e) m*: clears only the cell COMMENTS
, ✔✔right and down fills - ✔✔highlight the range
*Ctrl R* tells Excel to look at the LEFTMOST column of a range of highlighted cells and
copy and paste the inputs and formulas in that column to all the columns to the right
*Ctrl D* does the same thing for rows that Ctrl R does for columns, telling Excel to look
at the topmost row of a range of highlighted cells and to copy and paste the inputs and
formulas in that row down to all the rows below it
✔✔inserting comments - ✔✔enter the cell and type *Shift F2*
hit *Esc* twice to exit the comment area
to edit an existing comment: go to the cell and press *Shift F2*
to delete a comment: press *Alt h e am*
✔✔inserting rows - ✔✔highlight the row BELOW the row where you want to add a row
press *Shift spacebar* to highlight the entire row
press *Ctrl Shift +* to insert the row
note:
Excel will insert the row ABOVE the row that is highlighted
✔✔inserting columns - ✔✔*Ctrl Spacebar* to highlight the entire column
*Ctrl Shift +* to insert the column
note:
Excel will insert the row to the LEFT of the column that is highlighted
✔✔deleting rows and columns - ✔✔row: *Alt h d r*
column: *Alt h d c*
OR
highlight row/column and press *Ctrl -*
✔✔Paste special - transpose - ✔✔this feature allows users to convert a vertical list of
data into a horizontal list of data, and vice versa
highlight the vertical list of data
in an open cell, press *Alt e s e*
QUESTIONS SURE A+
✔✔splitting panes - ✔✔splitting panes allows users to scroll in both areas of the
worksheet, while rows and columns in the non-scrolled area remain visible
to split panes:
-click the cell BELOW the desired row and to the RIGHT of the desired column where
you want to split panes and hit *Alt w s*
-to unspilt panes, click *Alt w s* again
-press *F6* to move from pane to pane in a clockwise direction; press *Shift F6* to
move from pane to pane in a counter-clockwise direction
✔✔manipulating data inside a cell - ✔✔*F2* is the command that puts you inside a cell:
-pressing the F2 key once shows you the components of the formula you created
earlier, puts you inside a cell and enables you to navigate through it to edit the existing
cell data
-pressing the F2 key twice activates the cursor and enables you to move to different
cells, worksheets, and even other open Excel files
*Shift arrow key* will highlight characters one at a time
*Shift Ctrl arrow key* will highlight contiguous ranges of characters
✔✔deleting and clearing cell data - ✔✔hitting *Delete* does NOT delete the formatting
in the cell
to truly delete a cell:
-*Alt h e* (Home tab > Clear)
-from the drop-down, chose the appropriate actions
*(Alt h e) a*: clears ALL contents of the cell
*(Alt h e) f*: clears only the cell FORMAT
*(Alt h e) c*: clears only the cell CONTENT
-this is the same as hitting Delete
*(Alt h e) m*: clears only the cell COMMENTS
, ✔✔right and down fills - ✔✔highlight the range
*Ctrl R* tells Excel to look at the LEFTMOST column of a range of highlighted cells and
copy and paste the inputs and formulas in that column to all the columns to the right
*Ctrl D* does the same thing for rows that Ctrl R does for columns, telling Excel to look
at the topmost row of a range of highlighted cells and to copy and paste the inputs and
formulas in that row down to all the rows below it
✔✔inserting comments - ✔✔enter the cell and type *Shift F2*
hit *Esc* twice to exit the comment area
to edit an existing comment: go to the cell and press *Shift F2*
to delete a comment: press *Alt h e am*
✔✔inserting rows - ✔✔highlight the row BELOW the row where you want to add a row
press *Shift spacebar* to highlight the entire row
press *Ctrl Shift +* to insert the row
note:
Excel will insert the row ABOVE the row that is highlighted
✔✔inserting columns - ✔✔*Ctrl Spacebar* to highlight the entire column
*Ctrl Shift +* to insert the column
note:
Excel will insert the row to the LEFT of the column that is highlighted
✔✔deleting rows and columns - ✔✔row: *Alt h d r*
column: *Alt h d c*
OR
highlight row/column and press *Ctrl -*
✔✔Paste special - transpose - ✔✔this feature allows users to convert a vertical list of
data into a horizontal list of data, and vice versa
highlight the vertical list of data
in an open cell, press *Alt e s e*
