WALL STREET PREP EXCEL CRASH
COURSE EXAM COMPREHENSIVE
QUESTIONS ACCURATE ANSWERS
◉ When you are in the Format Cells dialog (Ctrl 1):
What is the keyboard shortcut for moving across tabs (Number,
Alignment, Font Border, Fill, Protection)?
How do you move counter clockwise across form elements?
How do you select a checkbox (put a checkbox next to it)
1) Tab 2) Ctrl Tab 3) Spacebar
1) Alt Tab 2) Ctrl Tab 3) Spacebar
1) Ctrl Tab 2) Shift Tab 3) Spacebar
1) Ctrl Tab 2) Shift Tab 3) Enter. Answer: The correct answer is: 1)
Ctrl Tab 2) Shift Tab 3) Spacebar
Tab will navigate the user to different cells. Enter will keep the data
the user has entered in the cell. Alt Tab is a shortcut to toggle among
different Windows.
◉ If I want to add the title "Company Financials" in cell A1 ensure
that all columns are the same width across all the worksheets in my
workbook, how would I do that?
1. Group the worksheets by hitting Ctrl Shift and use the left and/or
right arrow keys to select the worksheets. 2. In the active sheet type
, in "Company Financials" in A1 and apply the desired width to all
columns 3. Remember to hit Ctrl Pageup or Pagedown to make sure
that future edits only apply to active sheet.
1. Group the worksheets by hitting Ctrl Shift and use the
PageUp/Down keys to select the worksheets. 2. In the active sheet
type in "Company Financials" in A1 and apply the desired width to
all columns 3. Remember to hit Ctrl Pageup or Pagedown to make
sure that future edits only apply to active sheet.. Answer: 1. Group
the worksheets by hitting Ctrl Shift and use the PageUp/Down keys
to select the worksheets. 2. In the active sheet type in "Company
Financials" in A1 and apply the desired width to all columns 3.
Remember to hit Ctrl Pageup or Pagedown to make sure that future
edits only apply to active sheet.
◉ What is the keyboard 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)
1. Ctrl Alt Right Arrow 2. Alt a j 3. Alt a h
1. Ctrl Alt Right Arrow 2. Alt a h 3. Alt a s
1. Shift Alt Down Arrow 2. Alt a h 3. Alt a j. Answer: 1. Shift Alt Down
Arrow 2. Alt a h 3. Alt a j
◉ What is the keyboard shortcut to open the paste special dialog
box?
COURSE EXAM COMPREHENSIVE
QUESTIONS ACCURATE ANSWERS
◉ When you are in the Format Cells dialog (Ctrl 1):
What is the keyboard shortcut for moving across tabs (Number,
Alignment, Font Border, Fill, Protection)?
How do you move counter clockwise across form elements?
How do you select a checkbox (put a checkbox next to it)
1) Tab 2) Ctrl Tab 3) Spacebar
1) Alt Tab 2) Ctrl Tab 3) Spacebar
1) Ctrl Tab 2) Shift Tab 3) Spacebar
1) Ctrl Tab 2) Shift Tab 3) Enter. Answer: The correct answer is: 1)
Ctrl Tab 2) Shift Tab 3) Spacebar
Tab will navigate the user to different cells. Enter will keep the data
the user has entered in the cell. Alt Tab is a shortcut to toggle among
different Windows.
◉ If I want to add the title "Company Financials" in cell A1 ensure
that all columns are the same width across all the worksheets in my
workbook, how would I do that?
1. Group the worksheets by hitting Ctrl Shift and use the left and/or
right arrow keys to select the worksheets. 2. In the active sheet type
, in "Company Financials" in A1 and apply the desired width to all
columns 3. Remember to hit Ctrl Pageup or Pagedown to make sure
that future edits only apply to active sheet.
1. Group the worksheets by hitting Ctrl Shift and use the
PageUp/Down keys to select the worksheets. 2. In the active sheet
type in "Company Financials" in A1 and apply the desired width to
all columns 3. Remember to hit Ctrl Pageup or Pagedown to make
sure that future edits only apply to active sheet.. Answer: 1. Group
the worksheets by hitting Ctrl Shift and use the PageUp/Down keys
to select the worksheets. 2. In the active sheet type in "Company
Financials" in A1 and apply the desired width to all columns 3.
Remember to hit Ctrl Pageup or Pagedown to make sure that future
edits only apply to active sheet.
◉ What is the keyboard 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)
1. Ctrl Alt Right Arrow 2. Alt a j 3. Alt a h
1. Ctrl Alt Right Arrow 2. Alt a h 3. Alt a s
1. Shift Alt Down Arrow 2. Alt a h 3. Alt a j. Answer: 1. Shift Alt Down
Arrow 2. Alt a h 3. Alt a j
◉ What is the keyboard shortcut to open the paste special dialog
box?
