EXCEL CRASH COMPREHENSIVE
EXAMINATION PROBLEMS AND VERIFIED
ANSWERS BUNDLED
●● 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
EXAMINATION PROBLEMS AND VERIFIED
ANSWERS BUNDLED
●● 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