5/16/25, 12:31 AM Create a New Flashcard Set | Quizlet
Scheduled maintenance: May 17, 2025 from 07:00 AM to 10:00 AM
Title
Excel Crash Course
Description
EXCEL CRASH COURSE EXAM 2024 LATEST VERSION FROM WALL STREET
QUESTIONS AND 100% CORRECT ANSWERS (BRAND NEW!!)/WSP EXCEL
Import Add diagram Create from notes
1
All of the following are keyboard Alt i w, Alt h i s, Shift F11
Image
shortcut that allow the user input to and Alt Shift F1 are all
add more sheets to a workbook keyboard shortcuts for
EXCEPT: adding more sheets to a
Alt i w workbook.
Alt h i s Alt h i w is not a valid
Shift F11 shortcut.
Alt Shift F1
DEFINITION
Alt h i w
Incorrect
TERM
2
https://quizlet.com/1044714596/autosaved 1/20
,5/16/25, 12:31 AM Create a New Flashcard Set | Quizlet
What is a keyboard shortcut to open a The correct answer is
Image
file? Ctrl o.
Ctrl o Ctrl f is the shortcut to
Ctrl f find, or find and replace,
Alt o text on the worksheet.
Ctrl n Alt o is not a command.
Ctrl n is the shortcut to
TERM
open a new workbook.
DEFINITION
3
What is the recommended workbook The correct answer is
Image
calculation setting for Excel? "Automatic except for
Automatic Data Tables".
Manual Data tables can
Automatic except for Data Tables significantly slow down
Iterate Excel and other
programs. "Automatic",
TERM
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
https://quizlet.com/1044714596/autosaved 2/20
, 5/16/25, 12:31 AM Create a New Flashcard Set | Quizlet
toggle for users to set
for workbooks that may
have circular
calculations.q
DEFINITION
4
To add a cell reference from a different The correct answer is:
Image
worksheet into an existing formula with Hit F2 to get into the
your keyboard, you should follow the existing formula; delete
following steps: any incorrect formulas
1. Hit F2 to get into the existing formula; or operators
delete any incorrect formulas or Hit F2 again to enable
operators 2. Hit F2 again to enable "Enter" mode on the
"Enter" mode on the bottom-left bottom-left corner of
corner of the Excel sheet 3. Holding the Excel sheet
down Ctrl, use PageUp or PageDown Holding down Ctrl, use
to find the desired worksheet 4. Let go PageUp or PageDown
of the Ctrl and PageUp/Down keys 5. to find the desired
Use the arrow keys to locate the worksheet
desired cell reference 6. Hit Enter Let go of the Ctrl and
1. Hit F2 to get into the existing formula; PageUp/Down keys
delete any incorrect formulas or Use the arrow keys to
operators 2. Hit F2 again to enable locate the desired cell
"Enter" mode on the bottom-left reference
corner of the Excel sheet 3. Holding Hit Enter
down Alt, use PageUp or PageDown to In the incorrect option,
find the desired worksheet 4. Let go of 3. Alt Page Up / Down
the Ctrl and PageUp/Down keys 5. Use will not allow the user to
the arrow keys to locate the desired navigate to a different
cell reference 6. Hit Escape worksheet; 6. Hit Escape
will not save any cell
TERM
references, but will
delete any new data or
https://quizlet.com/1044714596/autosaved 3/20
Scheduled maintenance: May 17, 2025 from 07:00 AM to 10:00 AM
Title
Excel Crash Course
Description
EXCEL CRASH COURSE EXAM 2024 LATEST VERSION FROM WALL STREET
QUESTIONS AND 100% CORRECT ANSWERS (BRAND NEW!!)/WSP EXCEL
Import Add diagram Create from notes
1
All of the following are keyboard Alt i w, Alt h i s, Shift F11
Image
shortcut that allow the user input to and Alt Shift F1 are all
add more sheets to a workbook keyboard shortcuts for
EXCEPT: adding more sheets to a
Alt i w workbook.
Alt h i s Alt h i w is not a valid
Shift F11 shortcut.
Alt Shift F1
DEFINITION
Alt h i w
Incorrect
TERM
2
https://quizlet.com/1044714596/autosaved 1/20
,5/16/25, 12:31 AM Create a New Flashcard Set | Quizlet
What is a keyboard shortcut to open a The correct answer is
Image
file? Ctrl o.
Ctrl o Ctrl f is the shortcut to
Ctrl f find, or find and replace,
Alt o text on the worksheet.
Ctrl n Alt o is not a command.
Ctrl n is the shortcut to
TERM
open a new workbook.
DEFINITION
3
What is the recommended workbook The correct answer is
Image
calculation setting for Excel? "Automatic except for
Automatic Data Tables".
Manual Data tables can
Automatic except for Data Tables significantly slow down
Iterate Excel and other
programs. "Automatic",
TERM
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
https://quizlet.com/1044714596/autosaved 2/20
, 5/16/25, 12:31 AM Create a New Flashcard Set | Quizlet
toggle for users to set
for workbooks that may
have circular
calculations.q
DEFINITION
4
To add a cell reference from a different The correct answer is:
Image
worksheet into an existing formula with Hit F2 to get into the
your keyboard, you should follow the existing formula; delete
following steps: any incorrect formulas
1. Hit F2 to get into the existing formula; or operators
delete any incorrect formulas or Hit F2 again to enable
operators 2. Hit F2 again to enable "Enter" mode on the
"Enter" mode on the bottom-left bottom-left corner of
corner of the Excel sheet 3. Holding the Excel sheet
down Ctrl, use PageUp or PageDown Holding down Ctrl, use
to find the desired worksheet 4. Let go PageUp or PageDown
of the Ctrl and PageUp/Down keys 5. to find the desired
Use the arrow keys to locate the worksheet
desired cell reference 6. Hit Enter Let go of the Ctrl and
1. Hit F2 to get into the existing formula; PageUp/Down keys
delete any incorrect formulas or Use the arrow keys to
operators 2. Hit F2 again to enable locate the desired cell
"Enter" mode on the bottom-left reference
corner of the Excel sheet 3. Holding Hit Enter
down Alt, use PageUp or PageDown to In the incorrect option,
find the desired worksheet 4. Let go of 3. Alt Page Up / Down
the Ctrl and PageUp/Down keys 5. Use will not allow the user to
the arrow keys to locate the desired navigate to a different
cell reference 6. Hit Escape worksheet; 6. Hit Escape
will not save any cell
TERM
references, but will
delete any new data or
https://quizlet.com/1044714596/autosaved 3/20
