excel crash course Exam with verified detailed || || || || || || ||
answers
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 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. Shift Alt Right Arrow 2. Alt a h
|| || || || || || || || || || || || || || || || || || || || || ||
3. Alt a j
|| || ||
What is the keyboard shortcut to open the paste special dialog box? - ✔✔Alt e s or Alt h v s
|| || || || || || || || || || || || || || || || || || || ||
Which of the following keys IS NOT a way to trace precedent cells? - ✔✔Ctrl Alt [
|| || || || || || || || || || || || || || || ||
What is the keyboard shortcut to freeze panes within a worksheet? - ✔✔Alt W F F
|| || || || || || || || || || || || || || ||
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 - ✔✔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. 2. 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).
|| || || || || || || || || || || || || || || ||
, 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: - ✔✔Hit F6
|| || || || || || || || || || || || || || ||
Identify the commands to insert a comment and delete a comment - ✔✔1)Shift F2 2) Alt h e m
|| || || || || || || || || || || || || || || || || ||
Identify the utility used to create a dropdown menu in Excel. - ✔✔Alt d l
|| || || || || || || || || || || || || ||
Which of the following is NOT a shortcut for changing the format of a cell - ✔✔Ctrl Tab
|| || || || || || || || || || || || || || || || ||
Identify the shortcut to remove arrows from Trace Precedents or Trace Dependents. - ✔✔Alt m a
|| || || || || || || || || || || || || || ||
What is the keyboard shortcut to open the formatting cells dialog box? - ✔✔Ctrl 1
|| || || || || || || || || || || || || ||
What are the keyboard shortcuts for auto-fitting a range of columns? - ✔✔1) Select the columns
|| || || || || || || || || || || || || || || ||
by hitting Ctrl Spacebar. 2) Hold down the shift key and use left and right arrow keys to highlight
|| || || || || || || || || || || || || || || || || || ||
the range of columns. 3) Hit Alt H O I to auto fit the columns.
|| || || || || || || || || || || || || ||
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) Ctrl Tab 2) Shift Tab 3)
|| || || || || || || || || || || || || || || || || || || ||
Spacebar
All of the following are keyboard shortcut that allow the user input to add more sheets to a
|| || || || || || || || || || || || || || || || || ||
workbook EXCEPT: - ✔✔Alt h i w || || || || || ||
What is a keyboard shortcut to open a file? - ✔✔Ctrl o
|| || || || || || || || || || ||
answers
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 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. Shift Alt Right Arrow 2. Alt a h
|| || || || || || || || || || || || || || || || || || || || || ||
3. Alt a j
|| || ||
What is the keyboard shortcut to open the paste special dialog box? - ✔✔Alt e s or Alt h v s
|| || || || || || || || || || || || || || || || || || || ||
Which of the following keys IS NOT a way to trace precedent cells? - ✔✔Ctrl Alt [
|| || || || || || || || || || || || || || || ||
What is the keyboard shortcut to freeze panes within a worksheet? - ✔✔Alt W F F
|| || || || || || || || || || || || || || ||
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 - ✔✔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. 2. 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).
|| || || || || || || || || || || || || || || ||
, 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: - ✔✔Hit F6
|| || || || || || || || || || || || || || ||
Identify the commands to insert a comment and delete a comment - ✔✔1)Shift F2 2) Alt h e m
|| || || || || || || || || || || || || || || || || ||
Identify the utility used to create a dropdown menu in Excel. - ✔✔Alt d l
|| || || || || || || || || || || || || ||
Which of the following is NOT a shortcut for changing the format of a cell - ✔✔Ctrl Tab
|| || || || || || || || || || || || || || || || ||
Identify the shortcut to remove arrows from Trace Precedents or Trace Dependents. - ✔✔Alt m a
|| || || || || || || || || || || || || || ||
What is the keyboard shortcut to open the formatting cells dialog box? - ✔✔Ctrl 1
|| || || || || || || || || || || || || ||
What are the keyboard shortcuts for auto-fitting a range of columns? - ✔✔1) Select the columns
|| || || || || || || || || || || || || || || ||
by hitting Ctrl Spacebar. 2) Hold down the shift key and use left and right arrow keys to highlight
|| || || || || || || || || || || || || || || || || || ||
the range of columns. 3) Hit Alt H O I to auto fit the columns.
|| || || || || || || || || || || || || ||
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) Ctrl Tab 2) Shift Tab 3)
|| || || || || || || || || || || || || || || || || || || ||
Spacebar
All of the following are keyboard shortcut that allow the user input to add more sheets to a
|| || || || || || || || || || || || || || || || || ||
workbook EXCEPT: - ✔✔Alt h i w || || || || || ||
What is a keyboard shortcut to open a file? - ✔✔Ctrl o
|| || || || || || || || || || ||
