Excel Crash Course – Full Training Guide Covering Data
Analysis, Charts, Pivot Tables, and Advanced Spreadsheet
Techniques||Latest 2025-2026 Version!!!
Which of the following is NOT a shortcut for changing the format of
a cell
Ctrl Tab
Ctrl Shift 1
Ctrl B
Alt h f c - Answer-The correct answer is Ctrl Tab.
Ctrl Tab will move the selected cell. It is not a shortcut used to format
cells. Ctrl Shift 1 will change the cell to a Number format, Ctrl B
makes the cell text bold, Alt h f c will allow to change the text colour.
Identify the shortcut to remove arrows from Trace Precedents or Trace
Dependents.
Alt d t
Alt m p
Alt m d
Alt m a - Answer-The correct answer is Alt m a.
Alt d t inserts a data table. Alt m p is the shortcut to trace precedents.
Alt m d is the shortcut to trace dependents.
What is a keyboard shortcut to open a file?
Ctrl o
Ctrl f
Alt o
Ctrl n - Answer-The correct answer is Ctrl o.
pg. 1
,Ctrl f is the shortcut to find, or find and replace, text on the
worksheet. Alt o is not a command. Ctrl n is the shortcut to open a
new workbook.
What is the recommended workbook calculation setting for Excel?
Automatic
Manual
Automatic except for Data Tables
Iterate - Answer-The correct answer is "Automatic except for Data
Tables".
Data tables can significantly slow down Excel and other programs.
"Automatic", the default setting, will automatically calculate
everything in the workbook, including data tables, which will make
the program run more slowly. The Manual setting will require the user
to frequently recalculate the workbook in order to display correctly.
"Iterate" is not a setting for workbook calculation in Excel; iterative
calculation is a toggle for users to set for workbooks that may have
circular calculations’
To add a cell reference from a different worksheet into an existing
formula with your keyboard, you should follow the following steps:
1. Hit F2 to get into the existing formula; delete any incorrect
formulas or operators 2. Hit F2 again to enable "Enter" mode on the
bottom-left corner of the Excel sheet 3. Holding down Ctrl, use
PageUp or PageDown to find the desired worksheet 4. Let go of the
Ctrl and PageUp/Down keys 5. Use the arrow keys to locate the
desired cell reference 6. Hit Enter
1. Hit F2 to get into the existing formula; delete any incorrect
formulas or operators 2. Hit F2 again to enable "Enter" mode on the
bottom-left corner of the Excel sheet 3. Holding down Alt, use
PageUp or PageDown to find the desired worksheet 4. Let go of the
Ctrl and PageUp/Down keys 5. Use the arrow keys to locate the
desired cell reference 6. Hit Escape
pg. 2
,- Answer-The correct answer is:
Hit F2 to get into the existing formula; delete any incorrect formulas
or operators
Hit F2 again to enable "Enter" mode on the bottom-left corner of the
Excel sheet
Holding down Ctrl, use PageUp or PageDown to find the desired
worksheet
Let go of the Ctrl and PageUp/Down keys
Use the arrow keys to locate the desired cell reference
Hit Enter
In the incorrect option, 3. Alt Page Up / Down will not allow the user
to navigate to a different worksheet; 6. Hit Escape will not save any
cell references, but will delete any new data or formula that has been
entered into the cell.
What is the keyboard command to autofit the row height?
Alt o c a
Alt o c w
Alt h o h
Alt h o a - Answer-The correct answer is "Alt h o a"
Alt o c a is used to autofit column width. Alt o c w is used to assign
the column width. Alt h o h is used to assign the row height.
What is the command to change the zoom size?
Alt v z
Alt t o v
Alt h o i
Alt h v t - Answer-The correct answer is "Alt v z".
pg. 3
, Alt t o v is not a valid shortcut. Alt h o I is the shortcut to autofit the
column width. Alt h v t is not a valid shortcut.
What is the keyboard shortcut to open the formatting cells dialog box?
Ctrl 1
Ctrl 2
Ctrl Shift 1
Ctrl Shift 2 - Answer-The correct answer is: Ctrl 1.
Ctrl 2 is not a valid shortcut. Ctrl Shift 1 is the shortcut to cycle
through different number formats. Ctrl Shift 2 is the shortcut to cycle
through different date formats.
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.
1) Hold down the shift key and use left and right arrow keys to select
columns desired. 2) Hit Alt H O I to auto fit the columns
1) Select the columns by hitting Shift Spacebar. 2) Hold down the Ctrl
key and use left and right arrow keys to highlight the range of
columns. 3) Hit Alt H O W to auto fit the columns.
1) Select the columns by hitting Shift 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 W to auto fit the columns.
- Answer-Select the columns by hitting Ctrl Spacebar.
Hold down the shift key and use left and right arrow keys to highlight
the range of columns.
Hit Alt H O I to auto fit the columns.
Using the shift key and the right and left arrows will only autofit the
column widths for the cells selected and will not apply autofit to all
cells in the columns. Shift Spacebar will select a specific row rather
pg. 4
Analysis, Charts, Pivot Tables, and Advanced Spreadsheet
Techniques||Latest 2025-2026 Version!!!
Which of the following is NOT a shortcut for changing the format of
a cell
Ctrl Tab
Ctrl Shift 1
Ctrl B
Alt h f c - Answer-The correct answer is Ctrl Tab.
Ctrl Tab will move the selected cell. It is not a shortcut used to format
cells. Ctrl Shift 1 will change the cell to a Number format, Ctrl B
makes the cell text bold, Alt h f c will allow to change the text colour.
Identify the shortcut to remove arrows from Trace Precedents or Trace
Dependents.
Alt d t
Alt m p
Alt m d
Alt m a - Answer-The correct answer is Alt m a.
Alt d t inserts a data table. Alt m p is the shortcut to trace precedents.
Alt m d is the shortcut to trace dependents.
What is a keyboard shortcut to open a file?
Ctrl o
Ctrl f
Alt o
Ctrl n - Answer-The correct answer is Ctrl o.
pg. 1
,Ctrl f is the shortcut to find, or find and replace, text on the
worksheet. Alt o is not a command. Ctrl n is the shortcut to open a
new workbook.
What is the recommended workbook calculation setting for Excel?
Automatic
Manual
Automatic except for Data Tables
Iterate - Answer-The correct answer is "Automatic except for Data
Tables".
Data tables can significantly slow down Excel and other programs.
"Automatic", the default setting, will automatically calculate
everything in the workbook, including data tables, which will make
the program run more slowly. The Manual setting will require the user
to frequently recalculate the workbook in order to display correctly.
"Iterate" is not a setting for workbook calculation in Excel; iterative
calculation is a toggle for users to set for workbooks that may have
circular calculations’
To add a cell reference from a different worksheet into an existing
formula with your keyboard, you should follow the following steps:
1. Hit F2 to get into the existing formula; delete any incorrect
formulas or operators 2. Hit F2 again to enable "Enter" mode on the
bottom-left corner of the Excel sheet 3. Holding down Ctrl, use
PageUp or PageDown to find the desired worksheet 4. Let go of the
Ctrl and PageUp/Down keys 5. Use the arrow keys to locate the
desired cell reference 6. Hit Enter
1. Hit F2 to get into the existing formula; delete any incorrect
formulas or operators 2. Hit F2 again to enable "Enter" mode on the
bottom-left corner of the Excel sheet 3. Holding down Alt, use
PageUp or PageDown to find the desired worksheet 4. Let go of the
Ctrl and PageUp/Down keys 5. Use the arrow keys to locate the
desired cell reference 6. Hit Escape
pg. 2
,- Answer-The correct answer is:
Hit F2 to get into the existing formula; delete any incorrect formulas
or operators
Hit F2 again to enable "Enter" mode on the bottom-left corner of the
Excel sheet
Holding down Ctrl, use PageUp or PageDown to find the desired
worksheet
Let go of the Ctrl and PageUp/Down keys
Use the arrow keys to locate the desired cell reference
Hit Enter
In the incorrect option, 3. Alt Page Up / Down will not allow the user
to navigate to a different worksheet; 6. Hit Escape will not save any
cell references, but will delete any new data or formula that has been
entered into the cell.
What is the keyboard command to autofit the row height?
Alt o c a
Alt o c w
Alt h o h
Alt h o a - Answer-The correct answer is "Alt h o a"
Alt o c a is used to autofit column width. Alt o c w is used to assign
the column width. Alt h o h is used to assign the row height.
What is the command to change the zoom size?
Alt v z
Alt t o v
Alt h o i
Alt h v t - Answer-The correct answer is "Alt v z".
pg. 3
, Alt t o v is not a valid shortcut. Alt h o I is the shortcut to autofit the
column width. Alt h v t is not a valid shortcut.
What is the keyboard shortcut to open the formatting cells dialog box?
Ctrl 1
Ctrl 2
Ctrl Shift 1
Ctrl Shift 2 - Answer-The correct answer is: Ctrl 1.
Ctrl 2 is not a valid shortcut. Ctrl Shift 1 is the shortcut to cycle
through different number formats. Ctrl Shift 2 is the shortcut to cycle
through different date formats.
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.
1) Hold down the shift key and use left and right arrow keys to select
columns desired. 2) Hit Alt H O I to auto fit the columns
1) Select the columns by hitting Shift Spacebar. 2) Hold down the Ctrl
key and use left and right arrow keys to highlight the range of
columns. 3) Hit Alt H O W to auto fit the columns.
1) Select the columns by hitting Shift 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 W to auto fit the columns.
- Answer-Select the columns by hitting Ctrl Spacebar.
Hold down the shift key and use left and right arrow keys to highlight
the range of columns.
Hit Alt H O I to auto fit the columns.
Using the shift key and the right and left arrows will only autofit the
column widths for the cells selected and will not apply autofit to all
cells in the columns. Shift Spacebar will select a specific row rather
pg. 4
