Excel Crash Course Exam from Wall Street Prep-wall Street | Questions with Verified Answers | 100% Correct | Latest 2025/2026.

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,-