EXCEL CRASH Course WALL Street
Exam Questions and Answers
Verified Solutions Latest Update
Question:
What is the keyboard sequence to
Question:
Group highlighted columns (but not to hide group)
Question:
Hide the group (will show a + sign above the column)
Question:
Show the group (will show a + sign above the column).
Answer:
1. Shift Alt Right Arrow 2. Alt a h 3. Alt a j
Question:
What is the keyboard shortcut to open the paste special dialog box?
Answer:
Alt e s or Alt h v s
Question:
Which of the following keys IS NOT a way to trace precedent cells?
Answer:
Ctrl Alt [
, Question:
What is the keyboard shortcut to freeze panes within a worksheet?
Answer:
Alt W F F
Question:
Please select the answer that best describes the shortcut to Split (not freeze) an excel
sheet into just two panes (top and bottom) To navigate from pane to pane
Answer:
1. With the active cell on any row but in column A, hit Alt W S to split the panes to a top
and bottom.
Question:
Hit F6 to jump from pane to pane (in some versions of Excel you will need to hit F6
several times to get from one pane to the other).
Question:
You are in cell A1 and 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
Answer:
Hit F6
Question:
Identify the commands to insert a comment and delete a comment
Answer:
1)Shift F2 2) Alt h e m
Question:
Identify the utility used to create a dropdown menu in Excel.
Answer:
Alt d l
Exam Questions and Answers
Verified Solutions Latest Update
Question:
What is the keyboard sequence to
Question:
Group highlighted columns (but not to hide group)
Question:
Hide the group (will show a + sign above the column)
Question:
Show the group (will show a + sign above the column).
Answer:
1. Shift Alt Right Arrow 2. Alt a h 3. Alt a j
Question:
What is the keyboard shortcut to open the paste special dialog box?
Answer:
Alt e s or Alt h v s
Question:
Which of the following keys IS NOT a way to trace precedent cells?
Answer:
Ctrl Alt [
, Question:
What is the keyboard shortcut to freeze panes within a worksheet?
Answer:
Alt W F F
Question:
Please select the answer that best describes the shortcut to Split (not freeze) an excel
sheet into just two panes (top and bottom) To navigate from pane to pane
Answer:
1. With the active cell on any row but in column A, hit Alt W S to split the panes to a top
and bottom.
Question:
Hit F6 to jump from pane to pane (in some versions of Excel you will need to hit F6
several times to get from one pane to the other).
Question:
You are in cell A1 and 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
Answer:
Hit F6
Question:
Identify the commands to insert a comment and delete a comment
Answer:
1)Shift F2 2) Alt h e m
Question:
Identify the utility used to create a dropdown menu in Excel.
Answer:
Alt d l
