Excel Crash Course Exam from Wall Street i,- i,- i,- i,- i,- i,- i,-
Prep-wall Street | Questions with Verified i,- i,- i,- i,- i,- i,-
Answers | 100% Correct | Latest 2025/2026. i,- i,- i,- i,- i,- i,-
What is the keyboard command to autofit the row height?
i,- i,- i,- i,- i,- i,- i,- i,- i,-
Alt o c a
i,- i,- i,-
Alt o c w
i,- i,- i,-
Alt h o h
i,- i,- i,-
Alt h o a
i,- i,- i,- i,-i,- i,- The correct answer is "Alt h o a"
i,- i,- i,- i,- i,- i,- i,-
Alt o c a is used to autofit column width. Alt o c w is used to
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
assign the column width. Alt h o h is used to assign the row
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
height.
What is the command to change the zoom size?
i,- i,- i,- i,- i,- i,- i,- i,-
Alt v z
i,- i,-
Alt t o v
i,- i,- i,-
Alt h o i
i,- i,- i,-
Alt h v t
i,- i,- i,- i,-i,- i,- The correct answer is "Alt v z".
i,- i,- i,- i,- i,- i,-
Alt t o v is not a valid shortcut. Alt h o I is the shortcut to autofit
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
the column width. Alt h v t is not a valid shortcut.
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
,What is the keyboard shortcut to open the formatting cells dialog
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
box?
Ctrl 1 i,-
Ctrl 2 i,-
Ctrl Shift 1
i,- i,-
Ctrl Shift 2
i,- i,- i,-i,- i,- The correct answer is: Ctrl 1.
i,- i,- i,- i,- i,-
Ctrl 2 is not a valid shortcut. Ctrl Shift 1 is the shortcut to cycle
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
through different number formats. Ctrl Shift 2 is the shortcut to
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
cycle through different date formats.
i,- i,- i,- i,-
What are the keyboard shortcuts for auto-fitting a range of
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
columns?
1) Select the columns by hitting Ctrl Spacebar. 2) Hold down the
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
shift key and use left and right arrow keys to highlight the range
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
of columns. 3) Hit Alt H O I to auto fit the columns.
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
1) Hold down the shift key and use left and right arrow keys to
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
select columns desired. 2) Hit Alt H O I to auto fit the columns
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
1) Select the columns by hitting Shift Spacebar. 2) Hold down the
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
Ctrl key and use left and right arrow keys to highlight the range
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
of columns. 3) Hit Alt H O W to auto fit the columns.
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
1) Select the columns by hitting Shift Spacebar. 2) Hold down the
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
Shift key and use left and right arrow keys to highlight the range
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
of columns. 3) Hit Alt H O W to auto fit the columns.
i,- Select
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-i,- i,- i,-
the columns by hitting Ctrl Spacebar.
i,- i,- i,- i,- i,-
, Hold down the shift key and use left and right arrow keys to
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
highlight the range of columns. i,- i,- i,- i,-
Hit Alt H O I to auto fit the columns.
i,- i,- i,- i,- i,- i,- i,- i,- i,-
Using the shift key and the right and left arrows will only autofit
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
the column widths for the cells selected and will not apply autofit
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
to all cells in the columns. Shift Spacebar will select a specific row
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
rather than a specific column. Alt H O W will allow the user to
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
select a specific column width but will not autofit the column
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
width.
When you are in the Format Cells dialog (Ctrl 1):
i,- i,- i,- i,- i,- i,- i,- i,- i,-
What is the keyboard shortcut for moving across tabs (Number,
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
Alignment, Font Border, Fill, Protection)? i,- i,- i,- i,-
How do you move counter clockwise across form elements?
i,- i,- i,- i,- i,- i,- i,- i,-
How do you select a checkbox (put a checkbox next to it)
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
1) Tab 2) Ctrl Tab 3) Spacebar
i,- i,- i,- i,- i,- i,-
1) Alt Tab 2) Ctrl Tab 3) Spacebar
i,- i,- i,- i,- i,- i,- i,-
1) Ctrl Tab 2) Shift Tab 3) Spacebar
i,- i,- i,- i,- i,- i,- i,-
1) Ctrl Tab 2) Shift Tab 3) Enter
i,- i,- i,- i,- i,- i,- i,- i,-i,- i,- The correct answer is: 1) Ctrl
i,- i,- i,- i,- i,- i,-
Tab 2) Shift Tab 3) Spacebar
i,- i,- i,- i,- i,-
Tab will navigate the user to different cells. Enter will keep the
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
data the user has entered in the cell. Alt Tab is a shortcut to
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
toggle among different Windows.
i,- i,- i,-
Prep-wall Street | Questions with Verified i,- i,- i,- i,- i,- i,-
Answers | 100% Correct | Latest 2025/2026. i,- i,- i,- i,- i,- i,-
What is the keyboard command to autofit the row height?
i,- i,- i,- i,- i,- i,- i,- i,- i,-
Alt o c a
i,- i,- i,-
Alt o c w
i,- i,- i,-
Alt h o h
i,- i,- i,-
Alt h o a
i,- i,- i,- i,-i,- i,- The correct answer is "Alt h o a"
i,- i,- i,- i,- i,- i,- i,-
Alt o c a is used to autofit column width. Alt o c w is used to
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
assign the column width. Alt h o h is used to assign the row
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
height.
What is the command to change the zoom size?
i,- i,- i,- i,- i,- i,- i,- i,-
Alt v z
i,- i,-
Alt t o v
i,- i,- i,-
Alt h o i
i,- i,- i,-
Alt h v t
i,- i,- i,- i,-i,- i,- The correct answer is "Alt v z".
i,- i,- i,- i,- i,- i,-
Alt t o v is not a valid shortcut. Alt h o I is the shortcut to autofit
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
the column width. Alt h v t is not a valid shortcut.
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
,What is the keyboard shortcut to open the formatting cells dialog
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
box?
Ctrl 1 i,-
Ctrl 2 i,-
Ctrl Shift 1
i,- i,-
Ctrl Shift 2
i,- i,- i,-i,- i,- The correct answer is: Ctrl 1.
i,- i,- i,- i,- i,-
Ctrl 2 is not a valid shortcut. Ctrl Shift 1 is the shortcut to cycle
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
through different number formats. Ctrl Shift 2 is the shortcut to
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
cycle through different date formats.
i,- i,- i,- i,-
What are the keyboard shortcuts for auto-fitting a range of
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
columns?
1) Select the columns by hitting Ctrl Spacebar. 2) Hold down the
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
shift key and use left and right arrow keys to highlight the range
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
of columns. 3) Hit Alt H O I to auto fit the columns.
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
1) Hold down the shift key and use left and right arrow keys to
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
select columns desired. 2) Hit Alt H O I to auto fit the columns
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
1) Select the columns by hitting Shift Spacebar. 2) Hold down the
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
Ctrl key and use left and right arrow keys to highlight the range
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
of columns. 3) Hit Alt H O W to auto fit the columns.
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
1) Select the columns by hitting Shift Spacebar. 2) Hold down the
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
Shift key and use left and right arrow keys to highlight the range
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
of columns. 3) Hit Alt H O W to auto fit the columns.
i,- Select
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-i,- i,- i,-
the columns by hitting Ctrl Spacebar.
i,- i,- i,- i,- i,-
, Hold down the shift key and use left and right arrow keys to
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
highlight the range of columns. i,- i,- i,- i,-
Hit Alt H O I to auto fit the columns.
i,- i,- i,- i,- i,- i,- i,- i,- i,-
Using the shift key and the right and left arrows will only autofit
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
the column widths for the cells selected and will not apply autofit
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
to all cells in the columns. Shift Spacebar will select a specific row
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
rather than a specific column. Alt H O W will allow the user to
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
select a specific column width but will not autofit the column
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
width.
When you are in the Format Cells dialog (Ctrl 1):
i,- i,- i,- i,- i,- i,- i,- i,- i,-
What is the keyboard shortcut for moving across tabs (Number,
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
Alignment, Font Border, Fill, Protection)? i,- i,- i,- i,-
How do you move counter clockwise across form elements?
i,- i,- i,- i,- i,- i,- i,- i,-
How do you select a checkbox (put a checkbox next to it)
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
1) Tab 2) Ctrl Tab 3) Spacebar
i,- i,- i,- i,- i,- i,-
1) Alt Tab 2) Ctrl Tab 3) Spacebar
i,- i,- i,- i,- i,- i,- i,-
1) Ctrl Tab 2) Shift Tab 3) Spacebar
i,- i,- i,- i,- i,- i,- i,-
1) Ctrl Tab 2) Shift Tab 3) Enter
i,- i,- i,- i,- i,- i,- i,- i,-i,- i,- The correct answer is: 1) Ctrl
i,- i,- i,- i,- i,- i,-
Tab 2) Shift Tab 3) Spacebar
i,- i,- i,- i,- i,-
Tab will navigate the user to different cells. Enter will keep the
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
data the user has entered in the cell. Alt Tab is a shortcut to
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
toggle among different Windows.
i,- i,- i,-
