EXCEL CRASH COMPREHENSIVE
CERTIFICATION EVALUATION VERIFIED
QUESTIONS AND FULL SOLUTIONS
●● What is a keyboard shortcut to open a file?
Answer: Ctrl o
●● What is the recommended workbook calculation setting for Excel?
Answer: Automatic except for Data Tables
●● To add a cell reference from a different worksheet into an existing
formula with your keyboard, you should follow the following steps:
Answer: 1. Hit F2 to get into the existing formula; delete any incorrect
formulas or operators 2. Hit F2 again to enable "Enter" mode on the
bottom-left corner of the Excel sheet 3. Holding down Ctrl, use PageUp
or PageDown to find the desired worksheet 4. Let go of the Ctrl and
PageUp/Down keys 5. Use the arrow keys to locate the desired cell
reference 6. Hit Enter
●● Alt h o i
Answer: exact column width
●● Alt h o w
, Answer: identical column widths
●● Alt h o h
Answer: identical column height
●● Control + Space
Answer: highlight column
●● Shift + Space
Answer: highlight row
●● Command + B
Answer: bold
●● Command + I
Answer: italicize
●● Alt e s / control command v
Answer: paste special
●● What is the keyboard shortcut to move sheets within a workbook?
Answer: Alt H O M
CERTIFICATION EVALUATION VERIFIED
QUESTIONS AND FULL SOLUTIONS
●● What is a keyboard shortcut to open a file?
Answer: Ctrl o
●● What is the recommended workbook calculation setting for Excel?
Answer: Automatic except for Data Tables
●● To add a cell reference from a different worksheet into an existing
formula with your keyboard, you should follow the following steps:
Answer: 1. Hit F2 to get into the existing formula; delete any incorrect
formulas or operators 2. Hit F2 again to enable "Enter" mode on the
bottom-left corner of the Excel sheet 3. Holding down Ctrl, use PageUp
or PageDown to find the desired worksheet 4. Let go of the Ctrl and
PageUp/Down keys 5. Use the arrow keys to locate the desired cell
reference 6. Hit Enter
●● Alt h o i
Answer: exact column width
●● Alt h o w
, Answer: identical column widths
●● Alt h o h
Answer: identical column height
●● Control + Space
Answer: highlight column
●● Shift + Space
Answer: highlight row
●● Command + B
Answer: bold
●● Command + I
Answer: italicize
●● Alt e s / control command v
Answer: paste special
●● What is the keyboard shortcut to move sheets within a workbook?
Answer: Alt H O M