EXCEL CRASH COURSE EXAM STUDY SHEET WITH 200 REAL QUESTIONS AND ANSWERS

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?