EXCEL CRASH COURSE EXAM WALL STREET NEWEST UPDATED
ACTUAL EXAM QUESTIONS AND ANSWERS ALREADY GRADED
A+
All of the following are keyboard shortcut that allow
the user input to add more sheets to a workbook
EXCEPT:
ANSWER-Alt h i w
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
Page Up or Page Down to find the desired
worksheet 4. Let go of the Ctrl and Page Up/Down
keys 5. Use the arrow keys to locate the desired cell
reference 6. Hit Enter
What is the keyboard shortcut to move sheets
within a workbook?
ANSWER-Alt H O M
ACTUAL EXAM QUESTIONS AND ANSWERS ALREADY GRADED
A+
All of the following are keyboard shortcut that allow
the user input to add more sheets to a workbook
EXCEPT:
ANSWER-Alt h i w
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
Page Up or Page Down to find the desired
worksheet 4. Let go of the Ctrl and Page Up/Down
keys 5. Use the arrow keys to locate the desired cell
reference 6. Hit Enter
What is the keyboard shortcut to move sheets
within a workbook?
ANSWER-Alt H O M
