1h|hP a g e
EXCEL CRASH COURSE EXAM|| ALL QUESTIONS A h h h h h h
ND CORRECT ANSWERS|| LATEST AND COMPLETE
h h h h h h
UPDATE 2024 WITH EXPERT SOLUTIONS|| ASSURE h h h h h
D PASS!!! h
Which of the following keys IS NOT a way to trace precedent cells?
h h h h h h h h h h h h
Ctrl [ h
Alt m p h h
Alt t u t h h h
Ctrl Alt [ - h h h
hANSWER: The correct answer is: Ctrl [. Ctrl [ is not a valid shortcut. Alt m p, Alt t u
h h h h h h h h h h h h h h h h h h h h
t, and Ctrl Alt [ are all shortcuts that can be used to trace precedent cells.
h h h h h h h h h h h h h h h
What is the keyboard shortcut to freeze panes within a worksheet?
h h h h h h h h h h
Alt F W V h h h
Alt W S h h
Alt W F F h h h
Alt A W T - ANSWER: The correct answer is: Alt w f f.
h h h h h h h h h h h h h
Alt f w v is the shortcut for Print Preview. Alt w s is the shortcut to split panes. Alt a w
h h h h h h h h h h h h h h h h h h h h h
t is a shortcut to build data tables.
h h h h h h h h
Please select the answer that best describes the shortcut to
h h h h h h h h h
Split (not freeze) an excel sheet into just two panes (top and bottom)
h h h h h h h h h h h h
To navigate from pane to pane
h h h h h
1. Anywhere in the Excel worksheet hit Alt W S to split the panes to a top and bottom.
h h h h h h h h h h h h h h h h h h
2. Hit F6 to jump from pane to pane (in some versions of Excel you will need to hit F
h h h h h h h h h h h h h h h h h h h h
6 several times to get from one pane to the other).
h h h h h h h h h h
,2h|hP a g e
1. With the active cell on any row but in column A, hit Alt W S to split the panes to a t
h h h h h h h h h h h h h h h h h h h h h h
op and bottom. 2. Hit F6 to jump from pane to pane (in some versions of Excel you wi
h h h h h h h h h h h h h h h h h h
ll need to hit F6 several times to get from one pane to the other).
h h h h h h h h h h h h h h
1. With the active cell on any column but in row 1, hit Alt W S to split the panes to a to
h h h h h h h h h h h h h h h h h h h h h h
p and bottom. 2. Hit F6 to jump from pane to pane (in some versions of Excel you will
h h h h h h h h h h h h h h h h h h
need to hit F6 several times to get from one pane to the other). -
h h h h h h h h h h h h h h h
ANSWER: The correct answer is:
h h h h h
With the active cell on any row but in column A, hit Alt w s to split the panes to a top a
h h h h h h h h h h h h h h h h h h h h h h
nd bottom. h
Hit F6 to jump from pane to pane (in some versions of Excel you will need to hit F6 se
h h h h h h h h h h h h h h h h h h h
veral times to get from one pane to the other).
h h h h h h h h h
If the active cell is not in Column A, the user will have more than 2 panes. If the activ
h h h h h h h h h h h h h h h h h h h
e cell is in Row 1, the user will get two vertical panes.
h h h h h h h h h h h h
You are in cell A1 and start a formula by typing = in a worksheet with split top and bo
h h h h h h h h h h h h h h h h h h h
ttom panes. In order to jump to the bottom pane while working on the formula:
h h h h h h h h h h h h h h
Hit Tab h
Hit F6 h
Hit Alt F6 h h
Hit Alt Tab - ANSWER: The correct answer is: Hit F6
h h h h h h h h h h
Tab will navigate to the next cell. Alt F6 is not a valid shortcut. Alt Tab will navigate t
h h h h h h h h h h h h h h h h h h
o a different window.
h h h
See lesson: Splitting & Freezing Panes
h h h h h
Identify the commands to insert a comment and delete a comment
h h h h h h h h h h
1)Alt e m 2) Alt e m h h h h h h
1)Alt h e m 2) Alt I m h h h h h h h
1)Shift F2 2) Alt h e m h h h h h h
1)Alt h e m 2) Alt I s - ANSWER: The correct answer is Shift F2, Alt h e m.
h h h h h h h h h h h h h h h h h h h
,3h|hP a g e
Alt e m is a shortcut to open the menu to move or copy a selected sheet. Alt I s is the s
h h h h h h h h h h h h h h h h h h h h h h
hortcut to insert a symbol. h h h h
Identify the utility used to create a dropdown menu in Excel.
h h h h h h h h h h
Alt d t h h
Alt d v l h h h
Alt d l h h
Alt d d t - ANSWER: The correct answer is: alt d l.
h h h h h h h h h h h h
Alt d t is the shortcut to build a data table. Alt d v l is not a valid shortcut. Alt d d t is no
h h h h h h h h h h h h h h h h h h h h h h h h h
t a valid shortcut.
h h h
Which of the following is NOT a shortcut for changing the format of a cell
h h h h h h h h h h h h h h
Ctrl Tab h
Ctrl Shift 1 h h
Ctrl B h
Alt h f c - ANSWER: The correct answer is Ctrl Tab.
h h h h h h h h h h h
Ctrl Tab will move the selected cell. It is not a shortcut used to format cells. Ctrl Shift
h h h h h h h h h h h h h h h h h h
1 will change the cell to a Number format, Ctrl B makes the cell text bold, Alt h f c wil
h h h h h h h h h h h h h h h h h h h h
l allow to change the text color.
h h h h h h
Identify the shortcut to remove arrows from Trace Precedents or Trace Dependents.
h h h h h h h h h h h
Alt d t h h
Alt m p h h
Alt m d h h
Alt m a - ANSWER: The correct answer is Alt m a.
h h h h h h h h h h h
Alt d t inserts a data table. Alt m p is the shortcut to trace precedents. Alt m d is the sh
h h h h h h h h h h h h h h h h h h h h h
ortcut to trace dependents.
h h h
, 4h|hP a g e
Identify a function in cell D6 that will return the fraction of the year elapsed assuming
h h h h h h h h h h h h h h h
ha 360 day count basis.
h h h h
=STUB(D4,D5)
=YEARFRAC(D4,D5,2)
=DAYS360(D4,D5)
=YEARFRAC(D4,D5) - h
ANSWER: The correct answer is: =YEARFRAC(D4,D5,2). STUB is not an Excel f
h h h h h h h h h h h h
ormula. DAYS360 will return the number of days in a 360 day year. YEARFRAC(D
h h h h h h h h h h h h h
4,D5) will calculate the fraction using a 365-day year.
h h h h h h h h
Identify the formula that will always output a date that is the end-of-
h h h h h h h h h h h h
month date 3 months after the date inputted in D5.
h h h h h h h h h
=DATE(YEAR(D5),MONTH(D5)+3,DAY(D5))
=EOMONTH(3,D5)
=EOMONTH(D5,3) - ANSWER: The correct answer is: =EOMONTH(D5,3) h h h h h h h
=DATE(YEAR(D5),MONTH(D5)+3,DAY(D5)) will add 3 months to the data input h h h h h h h h
ted in D5. EOMONTH(3,D5) reverses the arguments required for this function.
h h h h h h h h h h
Identify the formula that, based in user inputs in cells B1 and B2, outputs the text "ani
h h h h h h h h h h h h h h h h
mal lover" for users who have at least 1 dog and at least one cat, and outputs "lonely p
h h h h h h h h h h h h h h h h h h
erson" when those conditions are not met.
h h h h h h
=IF(OR(B1>0,B2>0),"animal lover","lonely person") h h
=IF(AND(B1>1,B2>1),"animal lover","lonely person") h h
=IF(AND(B1>0,B2>0),"animal lover","lonely person") h h
=AND(IF(B1>0,"animal lover","lonely person"),IF(B2>0,"animal lover","lonely pe h h h h
rson")) - h
EXCEL CRASH COURSE EXAM|| ALL QUESTIONS A h h h h h h
ND CORRECT ANSWERS|| LATEST AND COMPLETE
h h h h h h
UPDATE 2024 WITH EXPERT SOLUTIONS|| ASSURE h h h h h
D PASS!!! h
Which of the following keys IS NOT a way to trace precedent cells?
h h h h h h h h h h h h
Ctrl [ h
Alt m p h h
Alt t u t h h h
Ctrl Alt [ - h h h
hANSWER: The correct answer is: Ctrl [. Ctrl [ is not a valid shortcut. Alt m p, Alt t u
h h h h h h h h h h h h h h h h h h h h
t, and Ctrl Alt [ are all shortcuts that can be used to trace precedent cells.
h h h h h h h h h h h h h h h
What is the keyboard shortcut to freeze panes within a worksheet?
h h h h h h h h h h
Alt F W V h h h
Alt W S h h
Alt W F F h h h
Alt A W T - ANSWER: The correct answer is: Alt w f f.
h h h h h h h h h h h h h
Alt f w v is the shortcut for Print Preview. Alt w s is the shortcut to split panes. Alt a w
h h h h h h h h h h h h h h h h h h h h h
t is a shortcut to build data tables.
h h h h h h h h
Please select the answer that best describes the shortcut to
h h h h h h h h h
Split (not freeze) an excel sheet into just two panes (top and bottom)
h h h h h h h h h h h h
To navigate from pane to pane
h h h h h
1. Anywhere in the Excel worksheet hit Alt W S to split the panes to a top and bottom.
h h h h h h h h h h h h h h h h h h
2. Hit F6 to jump from pane to pane (in some versions of Excel you will need to hit F
h h h h h h h h h h h h h h h h h h h h
6 several times to get from one pane to the other).
h h h h h h h h h h
,2h|hP a g e
1. With the active cell on any row but in column A, hit Alt W S to split the panes to a t
h h h h h h h h h h h h h h h h h h h h h h
op and bottom. 2. Hit F6 to jump from pane to pane (in some versions of Excel you wi
h h h h h h h h h h h h h h h h h h
ll need to hit F6 several times to get from one pane to the other).
h h h h h h h h h h h h h h
1. With the active cell on any column but in row 1, hit Alt W S to split the panes to a to
h h h h h h h h h h h h h h h h h h h h h h
p and bottom. 2. Hit F6 to jump from pane to pane (in some versions of Excel you will
h h h h h h h h h h h h h h h h h h
need to hit F6 several times to get from one pane to the other). -
h h h h h h h h h h h h h h h
ANSWER: The correct answer is:
h h h h h
With the active cell on any row but in column A, hit Alt w s to split the panes to a top a
h h h h h h h h h h h h h h h h h h h h h h
nd bottom. h
Hit F6 to jump from pane to pane (in some versions of Excel you will need to hit F6 se
h h h h h h h h h h h h h h h h h h h
veral times to get from one pane to the other).
h h h h h h h h h
If the active cell is not in Column A, the user will have more than 2 panes. If the activ
h h h h h h h h h h h h h h h h h h h
e cell is in Row 1, the user will get two vertical panes.
h h h h h h h h h h h h
You are in cell A1 and start a formula by typing = in a worksheet with split top and bo
h h h h h h h h h h h h h h h h h h h
ttom panes. In order to jump to the bottom pane while working on the formula:
h h h h h h h h h h h h h h
Hit Tab h
Hit F6 h
Hit Alt F6 h h
Hit Alt Tab - ANSWER: The correct answer is: Hit F6
h h h h h h h h h h
Tab will navigate to the next cell. Alt F6 is not a valid shortcut. Alt Tab will navigate t
h h h h h h h h h h h h h h h h h h
o a different window.
h h h
See lesson: Splitting & Freezing Panes
h h h h h
Identify the commands to insert a comment and delete a comment
h h h h h h h h h h
1)Alt e m 2) Alt e m h h h h h h
1)Alt h e m 2) Alt I m h h h h h h h
1)Shift F2 2) Alt h e m h h h h h h
1)Alt h e m 2) Alt I s - ANSWER: The correct answer is Shift F2, Alt h e m.
h h h h h h h h h h h h h h h h h h h
,3h|hP a g e
Alt e m is a shortcut to open the menu to move or copy a selected sheet. Alt I s is the s
h h h h h h h h h h h h h h h h h h h h h h
hortcut to insert a symbol. h h h h
Identify the utility used to create a dropdown menu in Excel.
h h h h h h h h h h
Alt d t h h
Alt d v l h h h
Alt d l h h
Alt d d t - ANSWER: The correct answer is: alt d l.
h h h h h h h h h h h h
Alt d t is the shortcut to build a data table. Alt d v l is not a valid shortcut. Alt d d t is no
h h h h h h h h h h h h h h h h h h h h h h h h h
t a valid shortcut.
h h h
Which of the following is NOT a shortcut for changing the format of a cell
h h h h h h h h h h h h h h
Ctrl Tab h
Ctrl Shift 1 h h
Ctrl B h
Alt h f c - ANSWER: The correct answer is Ctrl Tab.
h h h h h h h h h h h
Ctrl Tab will move the selected cell. It is not a shortcut used to format cells. Ctrl Shift
h h h h h h h h h h h h h h h h h h
1 will change the cell to a Number format, Ctrl B makes the cell text bold, Alt h f c wil
h h h h h h h h h h h h h h h h h h h h
l allow to change the text color.
h h h h h h
Identify the shortcut to remove arrows from Trace Precedents or Trace Dependents.
h h h h h h h h h h h
Alt d t h h
Alt m p h h
Alt m d h h
Alt m a - ANSWER: The correct answer is Alt m a.
h h h h h h h h h h h
Alt d t inserts a data table. Alt m p is the shortcut to trace precedents. Alt m d is the sh
h h h h h h h h h h h h h h h h h h h h h
ortcut to trace dependents.
h h h
, 4h|hP a g e
Identify a function in cell D6 that will return the fraction of the year elapsed assuming
h h h h h h h h h h h h h h h
ha 360 day count basis.
h h h h
=STUB(D4,D5)
=YEARFRAC(D4,D5,2)
=DAYS360(D4,D5)
=YEARFRAC(D4,D5) - h
ANSWER: The correct answer is: =YEARFRAC(D4,D5,2). STUB is not an Excel f
h h h h h h h h h h h h
ormula. DAYS360 will return the number of days in a 360 day year. YEARFRAC(D
h h h h h h h h h h h h h
4,D5) will calculate the fraction using a 365-day year.
h h h h h h h h
Identify the formula that will always output a date that is the end-of-
h h h h h h h h h h h h
month date 3 months after the date inputted in D5.
h h h h h h h h h
=DATE(YEAR(D5),MONTH(D5)+3,DAY(D5))
=EOMONTH(3,D5)
=EOMONTH(D5,3) - ANSWER: The correct answer is: =EOMONTH(D5,3) h h h h h h h
=DATE(YEAR(D5),MONTH(D5)+3,DAY(D5)) will add 3 months to the data input h h h h h h h h
ted in D5. EOMONTH(3,D5) reverses the arguments required for this function.
h h h h h h h h h h
Identify the formula that, based in user inputs in cells B1 and B2, outputs the text "ani
h h h h h h h h h h h h h h h h
mal lover" for users who have at least 1 dog and at least one cat, and outputs "lonely p
h h h h h h h h h h h h h h h h h h
erson" when those conditions are not met.
h h h h h h
=IF(OR(B1>0,B2>0),"animal lover","lonely person") h h
=IF(AND(B1>1,B2>1),"animal lover","lonely person") h h
=IF(AND(B1>0,B2>0),"animal lover","lonely person") h h
=AND(IF(B1>0,"animal lover","lonely person"),IF(B2>0,"animal lover","lonely pe h h h h
rson")) - h
