EXCEL CRASH COURSE WALL STREET PREP COMPREHENSIVE EXAM SCRIPT COMPLETE
QUESTIONS VERIFIED SOLUTIONS
Question:
*Ctrl Shift!*.
Answer:
number format: 2 decimals, 000 separator
Question:
*Ctrl Shift $*.
Answer:
currency format: 2 decimal places
Question:
*Ctrl Shift %*.
Answer:
percentage format with no decimal places
Question:
*Ctrl Shift #*.
Answer:
date format with the day, month, and year
Question:
*Ctrl Shift _*.
,Answer:
remove all borders
Question:
anchoring cells.
Answer:
when you copy and paste a cell containing a formula from one cell to another, Excel automatically
shifts the cells being referenced in the formula sometimes this is not desirable, which is why Excel
allows you to anchor cells Anchoring (or "Fixing") cells that are being referenced in a formula tells
Excel that even if you copy the formula to another cell, the cells in the formula that are anchored
should not change fix column: $ before letter fix row: $ before number fix entire cell: $ before letter
and before number
Question:
renaming a worksheet you are working in.
Answer:
*Alt h o r*
Question:
inserting and deleting worksheets.
Answer:
add a new worksheet: *Alt h i s* or *Alt i w* delete a worksheet: *Alt e l*
Question:
new tab.
Answer:
*Shift F11*
, Question:
Grouping columns and rows.
Answer:
to group columns: hit *Ctrl Spacebar* to select the desired column(s) hit *Shift Alt right arrow key*
to create the group hitting *Alt a h* will hide the columns hitting *Alt a j* will unhide the columns
hitting *Shift Alt left arrow key* will remove the group to group rows: hit *Shift Spacebar* to select
the desired rows follow the other steps above
Question:
grouping vs hiding.
Answer:
another way to hide data is by hitting *Alt h o u r* for rows and *Alt h o u c* for columns, but don't
ever use this method because under this method, columns and rows are hidden, but there are no
indications (no minus or plus signs as in the first method) as to their location so it's easy to forget
which columns and rows you've hidden
Question:
grouping worksheets.
Answer:
if you want to format data in the same manner or enter the same data across multiple sheets, Excel
allows you to do this by grouping multiple worksheets, any data and formatting that you would
perform in one of the grouped worksheets would automatically be reflected in all of them to group
worksheets: holding down *Ctrl Shift*, press *PageUp* or *PageDown* to reach the worksheets
you would like to group all of the grouped worksheets are highlighted and the file name on top of
the Excel screen should show [Group] after it
Question:
to ungroup worksheets.
Answer:
press *Ctrl PageUp* or *Ctrl PageDown* until you reach one of the ungrouped worksheets; this
automatically groups all of the previously grouped sheets
QUESTIONS VERIFIED SOLUTIONS
Question:
*Ctrl Shift!*.
Answer:
number format: 2 decimals, 000 separator
Question:
*Ctrl Shift $*.
Answer:
currency format: 2 decimal places
Question:
*Ctrl Shift %*.
Answer:
percentage format with no decimal places
Question:
*Ctrl Shift #*.
Answer:
date format with the day, month, and year
Question:
*Ctrl Shift _*.
,Answer:
remove all borders
Question:
anchoring cells.
Answer:
when you copy and paste a cell containing a formula from one cell to another, Excel automatically
shifts the cells being referenced in the formula sometimes this is not desirable, which is why Excel
allows you to anchor cells Anchoring (or "Fixing") cells that are being referenced in a formula tells
Excel that even if you copy the formula to another cell, the cells in the formula that are anchored
should not change fix column: $ before letter fix row: $ before number fix entire cell: $ before letter
and before number
Question:
renaming a worksheet you are working in.
Answer:
*Alt h o r*
Question:
inserting and deleting worksheets.
Answer:
add a new worksheet: *Alt h i s* or *Alt i w* delete a worksheet: *Alt e l*
Question:
new tab.
Answer:
*Shift F11*
, Question:
Grouping columns and rows.
Answer:
to group columns: hit *Ctrl Spacebar* to select the desired column(s) hit *Shift Alt right arrow key*
to create the group hitting *Alt a h* will hide the columns hitting *Alt a j* will unhide the columns
hitting *Shift Alt left arrow key* will remove the group to group rows: hit *Shift Spacebar* to select
the desired rows follow the other steps above
Question:
grouping vs hiding.
Answer:
another way to hide data is by hitting *Alt h o u r* for rows and *Alt h o u c* for columns, but don't
ever use this method because under this method, columns and rows are hidden, but there are no
indications (no minus or plus signs as in the first method) as to their location so it's easy to forget
which columns and rows you've hidden
Question:
grouping worksheets.
Answer:
if you want to format data in the same manner or enter the same data across multiple sheets, Excel
allows you to do this by grouping multiple worksheets, any data and formatting that you would
perform in one of the grouped worksheets would automatically be reflected in all of them to group
worksheets: holding down *Ctrl Shift*, press *PageUp* or *PageDown* to reach the worksheets
you would like to group all of the grouped worksheets are highlighted and the file name on top of
the Excel screen should show [Group] after it
Question:
to ungroup worksheets.
Answer:
press *Ctrl PageUp* or *Ctrl PageDown* until you reach one of the ungrouped worksheets; this
automatically groups all of the previously grouped sheets
