5/15/25, 8:45 AM Wall Street Prep Excel//Wall Street Prep Excel Basics (Windows) Exam Flashcards | Quizlet
Terms in this set (27) Original
Which of the following Ctrl Alt [
keys IS NOT a way to
trace precedent cells?
Please select the 1. With the active cell on any row but in column
answer that best A, hit Alt W S to split the panes to a top and
describes the shortcut bottom. 2. Hit F6 to jump from pane to pane (in
to some versions of Excel you will need to hit F6
several times to get from one pane to the other).
Split (not freeze) an
excel sheet into just
two panes (top and
bottom)
To navigate from pane
to pane
You are in cell A1 and Hit F6
start a formula by
typing = in a worksheet
with split top and
bottom panes. In order
to jump to the bottom
pane while working on
the formula:
If I want to add the title 1. Group the wroksheets by hitting Ctrl Shift and
"Company Financials" use the PageUp/Down keys to select the
in cell A1 ensure that all worksheets. 2. In the active sheet type in
columns are the same "Company Financials" in A1 and apply the
width across all the desired width to all columns 3. Remember to hit
worksheets in my Ctrl Pageup or Pagedown to make sure that
workbook, how would I future edits only apply to active sheet.
do that?
If I want to add the title 1. Group the wroksheets by hitting Ctrl Shift and
"Company Financials" use the PageUp/Down keys to select the
in cell A1 ensure that all worksheets. 2. In the active sheet type in
columns are the same "Company Financials" in A1 and apply the
width across all the desired width to all columns 3. Remember to hit
worksheets in my Ctrl Pageup or Pagedown to make sure that
workbook, how would I future edits only apply to active sheet.
do that?
https://quizlet.com/1044292650/wall-street-prep-excelwall-street-prep-excel-basics-windows-exam-flash-cards/?new 1/5
, 5/15/25, 8:45 AM Wall Street Prep Excel//Wall Street Prep Excel Basics (Windows) Exam Flashcards | Quizlet
What is the keyboard 1. Shift Alt Right Arrow 2. Alt a h 3. Alt a j
sequence to
1) Group highlighted
columns (but not to
hide group)
2) Hide the group (will
show a + sign above
the column)
3) Show the group (will
show a + sign above
the column)
What is the keyboard Alt e s or Alt h v s
shortcut to open the
paste special dialog
box?
What is the keyboard Alt W F F
shortcut to freeze
panes within a
worksheet?
Identify a function in =YEARFRAC(D4,D5,2)
cell D6 that will return
the fraction of the year
elapsed assuming a
360 day count basis.
Identify the formula that =EOMONTH(D5,3)
will always output a
date that is the end-of-
month date 3 months
after the date inputted
in D5.
Identify the formula =IF(AND(B1>0,B2>0),"animal lover","lonely
that, based in user person")
inputs in cells B1 and
B2, outputs the text
"animal lover" for users
who have at least 1 dog
and at least one cat,
and outputs "lonely
person" when those
conditions are not met.
Identify the best =HLOOKUP(2016,A1:D4,3)
formula that will output
2016 expenses Hint:
https://quizlet.com/1044292650/wall-street-prep-excelwall-street-prep-excel-basics-windows-exam-flash-cards/?new 2/5
Terms in this set (27) Original
Which of the following Ctrl Alt [
keys IS NOT a way to
trace precedent cells?
Please select the 1. With the active cell on any row but in column
answer that best A, hit Alt W S to split the panes to a top and
describes the shortcut bottom. 2. Hit F6 to jump from pane to pane (in
to some versions of Excel you will need to hit F6
several times to get from one pane to the other).
Split (not freeze) an
excel sheet into just
two panes (top and
bottom)
To navigate from pane
to pane
You are in cell A1 and Hit F6
start a formula by
typing = in a worksheet
with split top and
bottom panes. In order
to jump to the bottom
pane while working on
the formula:
If I want to add the title 1. Group the wroksheets by hitting Ctrl Shift and
"Company Financials" use the PageUp/Down keys to select the
in cell A1 ensure that all worksheets. 2. In the active sheet type in
columns are the same "Company Financials" in A1 and apply the
width across all the desired width to all columns 3. Remember to hit
worksheets in my Ctrl Pageup or Pagedown to make sure that
workbook, how would I future edits only apply to active sheet.
do that?
If I want to add the title 1. Group the wroksheets by hitting Ctrl Shift and
"Company Financials" use the PageUp/Down keys to select the
in cell A1 ensure that all worksheets. 2. In the active sheet type in
columns are the same "Company Financials" in A1 and apply the
width across all the desired width to all columns 3. Remember to hit
worksheets in my Ctrl Pageup or Pagedown to make sure that
workbook, how would I future edits only apply to active sheet.
do that?
https://quizlet.com/1044292650/wall-street-prep-excelwall-street-prep-excel-basics-windows-exam-flash-cards/?new 1/5
, 5/15/25, 8:45 AM Wall Street Prep Excel//Wall Street Prep Excel Basics (Windows) Exam Flashcards | Quizlet
What is the keyboard 1. Shift Alt Right Arrow 2. Alt a h 3. Alt a j
sequence to
1) Group highlighted
columns (but not to
hide group)
2) Hide the group (will
show a + sign above
the column)
3) Show the group (will
show a + sign above
the column)
What is the keyboard Alt e s or Alt h v s
shortcut to open the
paste special dialog
box?
What is the keyboard Alt W F F
shortcut to freeze
panes within a
worksheet?
Identify a function in =YEARFRAC(D4,D5,2)
cell D6 that will return
the fraction of the year
elapsed assuming a
360 day count basis.
Identify the formula that =EOMONTH(D5,3)
will always output a
date that is the end-of-
month date 3 months
after the date inputted
in D5.
Identify the formula =IF(AND(B1>0,B2>0),"animal lover","lonely
that, based in user person")
inputs in cells B1 and
B2, outputs the text
"animal lover" for users
who have at least 1 dog
and at least one cat,
and outputs "lonely
person" when those
conditions are not met.
Identify the best =HLOOKUP(2016,A1:D4,3)
formula that will output
2016 expenses Hint:
https://quizlet.com/1044292650/wall-street-prep-excelwall-street-prep-excel-basics-windows-exam-flash-cards/?new 2/5
