Excel Crash Course Newest updated exam with || || || || || ||
accurate detailed solutions
|| || ||
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 - ✔✔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 - ✔✔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 - ✔✔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 - ✔✔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 || || || || || || || || || || ||
Let go of the Ctrl and PageUp/Down keys
|| || || || || || ||
Use the arrow keys to locate the desired cell reference
|| || || || || || || || ||
Hit Enter ||
In the incorrect option, 3. Alt Page Up / Down will not allow the user to navigate to a different
|| || || || || || || || || || || || || || || || || || || ||
worksheet; 6. Hit Escape will not save any cell references, but will delete any new data or formula || || || || || || || || || || || || || || || || ||
that has been entered into the cell.
|| || || || || || ||
What is the keyboard command to autofit the row height?
|| || || || || || || || ||
Alt o c a || || ||
Alt o c w || || ||
Alt h o h || || ||
accurate detailed solutions
|| || ||
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 - ✔✔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 - ✔✔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 - ✔✔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 - ✔✔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 || || || || || || || || || || ||
Let go of the Ctrl and PageUp/Down keys
|| || || || || || ||
Use the arrow keys to locate the desired cell reference
|| || || || || || || || ||
Hit Enter ||
In the incorrect option, 3. Alt Page Up / Down will not allow the user to navigate to a different
|| || || || || || || || || || || || || || || || || || || ||
worksheet; 6. Hit Escape will not save any cell references, but will delete any new data or formula || || || || || || || || || || || || || || || || ||
that has been entered into the cell.
|| || || || || || ||
What is the keyboard command to autofit the row height?
|| || || || || || || || ||
Alt o c a || || ||
Alt o c w || || ||
Alt h o h || || ||
