WALL STREET PREP EXCEL COURSE
EXAM SCRIPT TESTED QUESTIONS
VERIFIED SOLUTIONS
◉ deleting rows and columns. Answer: row: *Alt h d r*
column: *Alt h d c*
OR
highlight row/column and press *Ctrl -*
◉ Paste special - transpose. Answer: 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*
-your vertical list of data should now be listed horizontally
◉ *Ctrl Shift !*. Answer: number format: 2 decimals, 000 separator
◉ *Ctrl Shift $*. Answer: currency format: 2 decimal places
,◉ *Ctrl Shift %*. Answer: percentage format with no decimal places
◉ *Ctrl Shift #*. Answer: date format with the day, month, and year
◉ *Ctrl Shift _*. Answer: remove all borders
◉ 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
◉ renaming a worksheet you are working in. Answer: *Alt h o r*
, ◉ inserting and deleting worksheets. Answer: add a new worksheet:
*Alt h i s* or *Alt i w*
delete a worksheet: *Alt e l*
◉ new tab. Answer: *Shift F11*
◉ 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
◉ 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
EXAM SCRIPT TESTED QUESTIONS
VERIFIED SOLUTIONS
◉ deleting rows and columns. Answer: row: *Alt h d r*
column: *Alt h d c*
OR
highlight row/column and press *Ctrl -*
◉ Paste special - transpose. Answer: 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*
-your vertical list of data should now be listed horizontally
◉ *Ctrl Shift !*. Answer: number format: 2 decimals, 000 separator
◉ *Ctrl Shift $*. Answer: currency format: 2 decimal places
,◉ *Ctrl Shift %*. Answer: percentage format with no decimal places
◉ *Ctrl Shift #*. Answer: date format with the day, month, and year
◉ *Ctrl Shift _*. Answer: remove all borders
◉ 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
◉ renaming a worksheet you are working in. Answer: *Alt h o r*
, ◉ inserting and deleting worksheets. Answer: add a new worksheet:
*Alt h i s* or *Alt i w*
delete a worksheet: *Alt e l*
◉ new tab. Answer: *Shift F11*
◉ 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
◉ 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
