EXCEL CRASH Course WALL Street
FINAL PAPER Questions and Answers
Verified Solutions Latest Update
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
Question:
auditing cells.
Answer:
go to the cel and hit F2 OR hitting *Ctrl [* on a cell will highlight the precedent cells
-keep hitting *Ctrl [* and it will take you to the next precedent, and on and on hitting
*Ctrl ]* on a cell will do the same thing but for dependent cells
FINAL PAPER Questions and Answers
Verified Solutions Latest Update
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
Question:
auditing cells.
Answer:
go to the cel and hit F2 OR hitting *Ctrl [* on a cell will highlight the precedent cells
-keep hitting *Ctrl [* and it will take you to the next precedent, and on and on hitting
*Ctrl ]* on a cell will do the same thing but for dependent cells
