EXCEL CRASH COURSE WALL STREET PREP
TERMINAL CERTIFICATION EVALUATION
COMPLETE QUESTIONS WITH FULL
SOLUTION ALREADY PASSED
⩥ What is the purpose of the Navigation Pane in Word?
Answer: It displays all headings in a hierarchical tree for quick
navigation.
⩥ How do you apply a heading style in Word?
Answer: Select the title text > Home tab > Styles group > click Heading
1, Heading 2, or Heading 3.
⩥ What is the function of tab stops in Word?
Answer: Tab stops align text at specific positions on the ruler for precise
alignment.
⩥ How do you insert a table in Word?
Answer: Insert tab > Table > choose rows x columns or use 'Insert Table'
for specific dimensions.
⩥ What is the command to select all text in a Word document?
, Answer: Ctrl+A (PC) or Cmd+A (Mac).
⩥ How do you modify a heading style in Word?
Answer: Right-click the style in the Styles gallery > Modify to change
font, size, etc.
⩥ What is the purpose of conditional formatting in Excel?
Answer: To apply formatting rules to cells based on specific conditions.
⩥ What does the SUMIFS function do?
Answer: Sums the values in a range that meet one or more criteria.
⩥ How do you save a macro-enabled workbook in Excel?
Answer: Save as .xlsm (Excel Macro-Enabled Workbook) via File >
Save As > change file type.
⩥ What is the formula to calculate a penalty in Excel?
Answer: =IF(E12 < C3, K3 * D12, 0) applies a penalty if the condition
is met.
⩥ How do you set a tab stop in Word?
Answer: Double-click the ruler at the desired position or go to Home >
Paragraph > Tabs.
TERMINAL CERTIFICATION EVALUATION
COMPLETE QUESTIONS WITH FULL
SOLUTION ALREADY PASSED
⩥ What is the purpose of the Navigation Pane in Word?
Answer: It displays all headings in a hierarchical tree for quick
navigation.
⩥ How do you apply a heading style in Word?
Answer: Select the title text > Home tab > Styles group > click Heading
1, Heading 2, or Heading 3.
⩥ What is the function of tab stops in Word?
Answer: Tab stops align text at specific positions on the ruler for precise
alignment.
⩥ How do you insert a table in Word?
Answer: Insert tab > Table > choose rows x columns or use 'Insert Table'
for specific dimensions.
⩥ What is the command to select all text in a Word document?
, Answer: Ctrl+A (PC) or Cmd+A (Mac).
⩥ How do you modify a heading style in Word?
Answer: Right-click the style in the Styles gallery > Modify to change
font, size, etc.
⩥ What is the purpose of conditional formatting in Excel?
Answer: To apply formatting rules to cells based on specific conditions.
⩥ What does the SUMIFS function do?
Answer: Sums the values in a range that meet one or more criteria.
⩥ How do you save a macro-enabled workbook in Excel?
Answer: Save as .xlsm (Excel Macro-Enabled Workbook) via File >
Save As > change file type.
⩥ What is the formula to calculate a penalty in Excel?
Answer: =IF(E12 < C3, K3 * D12, 0) applies a penalty if the condition
is met.
⩥ How do you set a tab stop in Word?
Answer: Double-click the ruler at the desired position or go to Home >
Paragraph > Tabs.
