Excel Crash Course Exam from Wall Street
All of the following are keyboard shortcut
that allow the user input to add more sheets
to a workbook EXCEPT:
Alt i w
Alt h i s
Shift F11
Alt Shift F1
Alt h i w
Incorrect - (ANSWER)Alt i w, Alt h i s, Shift
F11 and Alt Shift F1 are all keyboard
shortcuts for adding more sheets to a
workbook.
Alt h i w is not a valid shortcut.
What is a keyboard shortcut to open a file?
,Ctrl o
Ctrl f
Alt o
Ctrl n - (ANSWER)The correct answer is
Ctrl o.
Ctrl f is the shortcut to find, or find and
replace, text on the worksheet. Alt o is not a
command. Ctrl n is the shortcut to open a
new workbook.
What is the recommended workbook
calculation setting for Excel?
Automatic
Manual
Automatic except for Data Tables
Iterate - (ANSWER)The correct answer is
"Automatic except for Data Tables".
,Data tables can significantly slow down Excel
and other programs. "Automatic", the
default setting, will automatically calculate
everything in the workbook, including data
tables, which will make the program run
more slowly. The Manual setting will require
the user to frequently recalculate the
workbook in order to display correctly.
"Iterate" is not a setting for workbook
calculation in Excel; iterative calculation is a
toggle for users to set for workbooks that
may have circular calculations.q
To add a cell reference from a different
worksheet into an existing formula with your
keyboard, you should follow the following
steps:
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
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 Alt, 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
Escape - (ANSWER)The correct answer is:
Hit F2 to get into the existing formula; delete
any incorrect formulas or operators
Hit F2 again to enable "Enter" mode on the
bottom-left corner of the Excel sheet
Holding down Ctrl, use PageUp or
PageDown to find the desired worksheet
All of the following are keyboard shortcut
that allow the user input to add more sheets
to a workbook EXCEPT:
Alt i w
Alt h i s
Shift F11
Alt Shift F1
Alt h i w
Incorrect - (ANSWER)Alt i w, Alt h i s, Shift
F11 and Alt Shift F1 are all keyboard
shortcuts for adding more sheets to a
workbook.
Alt h i w is not a valid shortcut.
What is a keyboard shortcut to open a file?
,Ctrl o
Ctrl f
Alt o
Ctrl n - (ANSWER)The correct answer is
Ctrl o.
Ctrl f is the shortcut to find, or find and
replace, text on the worksheet. Alt o is not a
command. Ctrl n is the shortcut to open a
new workbook.
What is the recommended workbook
calculation setting for Excel?
Automatic
Manual
Automatic except for Data Tables
Iterate - (ANSWER)The correct answer is
"Automatic except for Data Tables".
,Data tables can significantly slow down Excel
and other programs. "Automatic", the
default setting, will automatically calculate
everything in the workbook, including data
tables, which will make the program run
more slowly. The Manual setting will require
the user to frequently recalculate the
workbook in order to display correctly.
"Iterate" is not a setting for workbook
calculation in Excel; iterative calculation is a
toggle for users to set for workbooks that
may have circular calculations.q
To add a cell reference from a different
worksheet into an existing formula with your
keyboard, you should follow the following
steps:
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
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 Alt, 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
Escape - (ANSWER)The correct answer is:
Hit F2 to get into the existing formula; delete
any incorrect formulas or operators
Hit F2 again to enable "Enter" mode on the
bottom-left corner of the Excel sheet
Holding down Ctrl, use PageUp or
PageDown to find the desired worksheet
