EXCEL CRASH COURSE EXAM STUDY SHEET
WITH 200 REAL QUESTIONS AND ANSWERS
⩥ 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
⩥ What is the keyboard shortcut to open the formatting cells dialog
box?. Answer: Ctrl 1
⩥ What are the keyboard shortcuts for auto-fitting a range of columns?.
Answer: 1) Select the columns by hitting Ctrl Spacebar. 2) Hold down
the shift key and use left and right arrow keys to highlight the range of
columns. 3) Hit Alt H O I to auto fit the columns.
⩥ When you are in the Format Cells dialog (Ctrl 1):
What is the keyboard shortcut for moving across tabs (Number,
Alignment, Font Border, Fill, Protection)?
How do you move counter clockwise across form elements?
WITH 200 REAL QUESTIONS AND ANSWERS
⩥ 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
⩥ What is the keyboard shortcut to open the formatting cells dialog
box?. Answer: Ctrl 1
⩥ What are the keyboard shortcuts for auto-fitting a range of columns?.
Answer: 1) Select the columns by hitting Ctrl Spacebar. 2) Hold down
the shift key and use left and right arrow keys to highlight the range of
columns. 3) Hit Alt H O I to auto fit the columns.
⩥ When you are in the Format Cells dialog (Ctrl 1):
What is the keyboard shortcut for moving across tabs (Number,
Alignment, Font Border, Fill, Protection)?
How do you move counter clockwise across form elements?
