WALL STREET PREP PREMIUM
COMPREHENSIVE STUDY GUIDE 2026
FULL QUESTIONS AND SOLUTIONS
GRADED A+
◍ Add a worksheet.
Answer: alt i w
◍ Move back and forth between worksheets.
Answer: ctrl PgUp or ctrl PgDn
◍ Open new workbook.
Answer: ctrl n
◍ Open a file.
Answer: ctrl o
◍ Save a file.
Answer: ctrl s
◍ Print a file.
Answer: ctrl p
◍ Access excel settings.
Answer: alt f t
◍ Key settings to change when starting new excel file.
Answer: -Make "workbook calculation" automatic except for data
tables-Enable iterative calculations
◍ Autofit width of column.
Answer: alt h o i
, ◍ Change column width arbitrarily.
Answer: alt h o w
◍ Highlight a column.
Answer: ctrl spacebar
◍ Highlight a row.
Answer: shift spacebar
◍ Open a cell's dialogue box.
Answer: ctrl 1
◍ Paste special.
Answer: Alt e s
◍ Moving between workbooks.
Answer: ctrl tab
◍ Freezing panes.
Answer: alt w f f
◍ Splitting panes.
Answer: alt w s (f6 and shift f6 to jump back and forth between panes)
◍ Redo.
Answer: ctrl y
◍ Go to beginning of cell while editing.
Answer: ctrl home
◍ Go to end of cell while editing.
Answer: ctrl end
◍ Clear cell dialogue.
Answer: alt h e (+a = clear all, + f = clear formats, + c = clear contents)
◍ Paste right.
Answer: ctrl r
◍ Paste down.
COMPREHENSIVE STUDY GUIDE 2026
FULL QUESTIONS AND SOLUTIONS
GRADED A+
◍ Add a worksheet.
Answer: alt i w
◍ Move back and forth between worksheets.
Answer: ctrl PgUp or ctrl PgDn
◍ Open new workbook.
Answer: ctrl n
◍ Open a file.
Answer: ctrl o
◍ Save a file.
Answer: ctrl s
◍ Print a file.
Answer: ctrl p
◍ Access excel settings.
Answer: alt f t
◍ Key settings to change when starting new excel file.
Answer: -Make "workbook calculation" automatic except for data
tables-Enable iterative calculations
◍ Autofit width of column.
Answer: alt h o i
, ◍ Change column width arbitrarily.
Answer: alt h o w
◍ Highlight a column.
Answer: ctrl spacebar
◍ Highlight a row.
Answer: shift spacebar
◍ Open a cell's dialogue box.
Answer: ctrl 1
◍ Paste special.
Answer: Alt e s
◍ Moving between workbooks.
Answer: ctrl tab
◍ Freezing panes.
Answer: alt w f f
◍ Splitting panes.
Answer: alt w s (f6 and shift f6 to jump back and forth between panes)
◍ Redo.
Answer: ctrl y
◍ Go to beginning of cell while editing.
Answer: ctrl home
◍ Go to end of cell while editing.
Answer: ctrl end
◍ Clear cell dialogue.
Answer: alt h e (+a = clear all, + f = clear formats, + c = clear contents)
◍ Paste right.
Answer: ctrl r
◍ Paste down.