EXCEL CRASH COMPREHENSIVE CERTIFICATION EVALUATION VERIFIED QUESTIONS AND FULL SOLUTIONS

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