WALL STREET PREP ACTUAL 10 2026 HIGHYIELD FINANCIAL STATEMENT ANALYSIS AND VALUATION REVIEW GUIDE

WALL STREET PREP ACTUAL 10 2026 HIGH-
YIELD FINANCIAL STATEMENT ANALYSIS AND
VALUATION REVIEW GUIDE

◉ 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.