EXCEL CRASH EXAM SCRIPT VERIFIED
QUESTIONS WITH COMPLETE SOLUTION
REVIEW
●● File
Answer: Alt F
●● Save as
Answer: Alt F A
●● ###
Answer: Error that means increase width of column
●● Increase width of column
Answer: Alt H O I
●● Increase height of row
Answer: Alt H O H
●● Format cell
Answer: Ctrl 1
,●● format to percentage
Answer: Ctrl Shift 5
●● To scroll menu of formatting
Answer: tab, arrow keys, alt + underlined letter, space bar clicks
●● Highlight a whole range
Answer: Ctrl + Shift + Right Arrow Key + Down Arrow Key
●● Paste Special
Answer: Ctrl Alt V
●● Move between workbooks
Answer: Ctrl Tab
●● Zoom
Answer: Alt V Z
●● Freeze panes & create a divider between headers and data
Answer: freezes cells above and to the left of selected cell
Alt W F F
, ●● Split data (to create windows/panes in the same sheet)
Answer: Alt W S
●● Move between panes
Answer: F6 = clockwise
Shift F6 = counter clockwise
●● Clear cell
Answer: Alt H E
Alt H E A to clear everything including formatting
●● Redo
Answer: Ctrl Y
●● Go inside a cell
Answer: F2
●● Highlight inside of cell
Answer: Ctrl Shift Arrow
●● Highlight formula
QUESTIONS WITH COMPLETE SOLUTION
REVIEW
●● File
Answer: Alt F
●● Save as
Answer: Alt F A
●● ###
Answer: Error that means increase width of column
●● Increase width of column
Answer: Alt H O I
●● Increase height of row
Answer: Alt H O H
●● Format cell
Answer: Ctrl 1
,●● format to percentage
Answer: Ctrl Shift 5
●● To scroll menu of formatting
Answer: tab, arrow keys, alt + underlined letter, space bar clicks
●● Highlight a whole range
Answer: Ctrl + Shift + Right Arrow Key + Down Arrow Key
●● Paste Special
Answer: Ctrl Alt V
●● Move between workbooks
Answer: Ctrl Tab
●● Zoom
Answer: Alt V Z
●● Freeze panes & create a divider between headers and data
Answer: freezes cells above and to the left of selected cell
Alt W F F
, ●● Split data (to create windows/panes in the same sheet)
Answer: Alt W S
●● Move between panes
Answer: F6 = clockwise
Shift F6 = counter clockwise
●● Clear cell
Answer: Alt H E
Alt H E A to clear everything including formatting
●● Redo
Answer: Ctrl Y
●● Go inside a cell
Answer: F2
●● Highlight inside of cell
Answer: Ctrl Shift Arrow
●● Highlight formula