TESTBANK FOR 2025-2026 FEMA ACTUAL FINAL EXAM QUESTIONS AND
CORRECT DETAILED ANSWERS - VERIFIED ANSWERS ALREADY GRADED A+ NEW
GUARANTEED
Which of the following calculates a series of averages for a set of values? - CORRECT
ANSWER moving average
Which of the following best describes a Trusted Location in Excel? - CORRECT
ANSWER a folder
Which of the following displays warning information yet allows users to make an entry? -
CORRECT ANSWER information message box
Which of the following is not true regarding the Compatibility Checker dialog box? -
CORRECT ANSWER access the compatibility checker by clicking the review tab
Which of the following prohibits a user from making an entry, and provides a choice of
either canceling the task or retrying? - CORRECT ANSWER stop warning
Which of the following tasks is not performed using the Excel Options dialog box? -
CORRECT ANSWER set data validation rules
Which of the following is not true for unlocking cells? - CORRECT ANSWER cells
are not locked by default
Basic form controls do not require any knowledge of Visual Basic for Applications (VBA)
coding. - CORRECT ANSWER true
The Circle Invalid Data command corrects cells with data that does not conform to
validation criteria. - CORRECT ANSWER false
It is best to create data validation settings after all data is entered. - CORRECT
ANSWER false
When using Solver, which of the following parameters is a cell with a formula to be
calculated to reach a desired result? - CORRECT ANSWER objective cell
Which of the following creates a visual filter for a field in a PivotTable? - CORRECT
ANSWER slicer tool
,Which of the following is not true when using Goal Seek? - CORRECT ANSWER
absolute value is typed in the to value box
Up to three scenarios can be displayed at a time in a worksheet. - CORRECT
ANSWER false
Unlock the cells B3:D8 so the user can edit the cells when the worksheet is protected. -
CORRECT ANSWER in the mini toolbar you clicked the format button in the format
menu you clicked the lock cell menu item
Which of the following creates a drop-down list from which you select one option? -
CORRECT ANSWER combo box
Which of the following displays in the upper right corner of a cell after a comment has
been added? - CORRECT ANSWER small red triangle
Which of the following extensions does Excel assign to templates? - CORRECT
ANSWER .xltx
By default, the Developer tab displays on the Ribbon. - CORRECT ANSWER false
It is not possible to remove metadata from a workbook. - CORRECT ANSWER
false
How many types of reports can you create using the Solver Results dialog box? -
CORRECT ANSWER 3
What should you do before creating a new scenario in Excel? - CORRECT ANSWER
save the current data in a worksheet as a scenario
Which of the following is a step-by-step procedure to find a solution? - CORRECT
ANSWER algorithm
Which of the following is a worksheet with an Excel table and a chart that illustrates past
data and predicts future values generated from data in the worksheet? - CORRECT
ANSWER forecast sheet
Which of the following is data that is the same in each query and allows for a
relationship between queries? - CORRECT ANSWER common field
Which of the following is defined as a range of cells that shows calculated results for
one or more formulas - CORRECT ANSWER data table
,Which of the following statements is not true about calculated fields? - CORRECT
ANSWER A calculated field is a field in the source data.
Which of the following commands is a quick and easy way to prepare a summary report
about a set of values? - CORRECT ANSWER descriptive statistics
Which of the following add-ins performs statistical and engineering functions? -
CORRECT ANSWER analysis toolpak
Forecast means knowing the results and determining the value needed to reach those
results. - CORRECT ANSWER false
If you edit a scenario after creating a summary report, the report is automatically
updated. - CORRECT ANSWER true
Which of the following is the programming language that underlies Excel macros? -
CORRECT ANSWER VBA
When you run a macro that was recorded with absolute references, where should the
active cell be before running the macro? - CORRECT ANSWER anywhere in the
worksheet
Which of the following are messages that identify code that Visual Basic doesn't
recognize? - CORRECT ANSWER syntax errors
In VBA code, what is the name of each line that is preceded by an apostrophe and
shown in green? - CORRECT ANSWER comment
Which of the following extensions identifies a macro-enabled workbook? - CORRECT
ANSWER .xlsm
Which of the following runs in a window that is separate from Excel? - CORRECT
ANSWER vbe
A macro records every step and every keystroke, including incorrect or unnecessary
steps. - CORRECT ANSWER true
Macro names must begin with a number and cannot contain spaces. - CORRECT
ANSWER false
, Once a shortcut has been assigned to a macro, it cannot be changed. - CORRECT
ANSWER false
To save your macros, you must save the workbook as an Excel macro-enabled
workbook. - CORRECT ANSWER true
Apply data validation rules to the selected cells to allow only decimal numbers between
2.5 and 4.0. Do not allow blanks. - CORRECT ANSWER In the Data Ribbon Tab in
the Data Tools Ribbon Group, you clicked the Data Validation button arrow. In the Data
Validation menu, you clicked the Data Validation... menu item. Inside the Data
Validation dialog in the Allow drop-down, you selected Decimal. Inside the Data
Validation dialog, you typed 2.5 in the Minimum: input, typed 4.0 in the Maximum: input,
unchecked the Ignore blank check box, and clicked the OK button.
Display all the comments in this worksheet at once. - CORRECT ANSWER In the
Review Ribbon Tab in the Comments Ribbon Group, you clicked the Show All
Comments button.
Create a new scenario to reflect a change in cell B9 to a value of 0.01 Name the
scenario Low COLA. - CORRECT ANSWER In the Data Ribbon Tab in the
Forecast Ribbon Group, you clicked the What-If Analysis button. In the What-If Analysis
menu, you clicked the Scenario Manager... menu item. Inside the Scenario Manager
dialog, you clicked the DialogHeader view, clicked the dialog undefined button, and
clicked the Add... button. Inside the Add Scenario dialog, you typed Low COLA in the
Scenario name: input, clicked the OK button. Inside the Scenario Values dialog, you
typed 0.01 in the text box input, clicked the OK button.
Complete the one-variable data table in cells E3:F8 to calculate the breakeven sales
point for varying owner withdrawal amounts. The formula has been entered for you in
cell E3. It references the original owner withdrawal value in cell B12. The substitute
values have been entered for you in cells E4:E8. - CORRECT ANSWER Ribbon
Group, you clicked the What-If Analysis button. In the What-If Analysis menu, you
clicked the Data Table... menu item. Inside the Data Table dialog, you clicked the
DialogHeader view, clicked the dialog undefined button, typed B12 in the Column input
cell input, and clicked the OK button.
Use Goal Seek to find the value for cell C2 that will result in a value of $550,000 for cell
B15. Accept the solution. - CORRECT ANSWER In the Data Ribbon Tab in the
Forecast Ribbon Group, you clicked the What-If Analysis button. In the What-If Analysis
menu, you clicked the Goal Seek... menu item. Inside the Goal Seek dialog, you typed
550,000 in the To value: input, typed C2 in the By changing cell: input, and clicked the
OK button. Inside the Goal Seek Status dialog, you clicked the OK button.
Use Solver to find the combination of procedures that will result in the maximum
possible profit per week in cell B7. Use the range name Optimal as the variable cells.
CORRECT DETAILED ANSWERS - VERIFIED ANSWERS ALREADY GRADED A+ NEW
GUARANTEED
Which of the following calculates a series of averages for a set of values? - CORRECT
ANSWER moving average
Which of the following best describes a Trusted Location in Excel? - CORRECT
ANSWER a folder
Which of the following displays warning information yet allows users to make an entry? -
CORRECT ANSWER information message box
Which of the following is not true regarding the Compatibility Checker dialog box? -
CORRECT ANSWER access the compatibility checker by clicking the review tab
Which of the following prohibits a user from making an entry, and provides a choice of
either canceling the task or retrying? - CORRECT ANSWER stop warning
Which of the following tasks is not performed using the Excel Options dialog box? -
CORRECT ANSWER set data validation rules
Which of the following is not true for unlocking cells? - CORRECT ANSWER cells
are not locked by default
Basic form controls do not require any knowledge of Visual Basic for Applications (VBA)
coding. - CORRECT ANSWER true
The Circle Invalid Data command corrects cells with data that does not conform to
validation criteria. - CORRECT ANSWER false
It is best to create data validation settings after all data is entered. - CORRECT
ANSWER false
When using Solver, which of the following parameters is a cell with a formula to be
calculated to reach a desired result? - CORRECT ANSWER objective cell
Which of the following creates a visual filter for a field in a PivotTable? - CORRECT
ANSWER slicer tool
,Which of the following is not true when using Goal Seek? - CORRECT ANSWER
absolute value is typed in the to value box
Up to three scenarios can be displayed at a time in a worksheet. - CORRECT
ANSWER false
Unlock the cells B3:D8 so the user can edit the cells when the worksheet is protected. -
CORRECT ANSWER in the mini toolbar you clicked the format button in the format
menu you clicked the lock cell menu item
Which of the following creates a drop-down list from which you select one option? -
CORRECT ANSWER combo box
Which of the following displays in the upper right corner of a cell after a comment has
been added? - CORRECT ANSWER small red triangle
Which of the following extensions does Excel assign to templates? - CORRECT
ANSWER .xltx
By default, the Developer tab displays on the Ribbon. - CORRECT ANSWER false
It is not possible to remove metadata from a workbook. - CORRECT ANSWER
false
How many types of reports can you create using the Solver Results dialog box? -
CORRECT ANSWER 3
What should you do before creating a new scenario in Excel? - CORRECT ANSWER
save the current data in a worksheet as a scenario
Which of the following is a step-by-step procedure to find a solution? - CORRECT
ANSWER algorithm
Which of the following is a worksheet with an Excel table and a chart that illustrates past
data and predicts future values generated from data in the worksheet? - CORRECT
ANSWER forecast sheet
Which of the following is data that is the same in each query and allows for a
relationship between queries? - CORRECT ANSWER common field
Which of the following is defined as a range of cells that shows calculated results for
one or more formulas - CORRECT ANSWER data table
,Which of the following statements is not true about calculated fields? - CORRECT
ANSWER A calculated field is a field in the source data.
Which of the following commands is a quick and easy way to prepare a summary report
about a set of values? - CORRECT ANSWER descriptive statistics
Which of the following add-ins performs statistical and engineering functions? -
CORRECT ANSWER analysis toolpak
Forecast means knowing the results and determining the value needed to reach those
results. - CORRECT ANSWER false
If you edit a scenario after creating a summary report, the report is automatically
updated. - CORRECT ANSWER true
Which of the following is the programming language that underlies Excel macros? -
CORRECT ANSWER VBA
When you run a macro that was recorded with absolute references, where should the
active cell be before running the macro? - CORRECT ANSWER anywhere in the
worksheet
Which of the following are messages that identify code that Visual Basic doesn't
recognize? - CORRECT ANSWER syntax errors
In VBA code, what is the name of each line that is preceded by an apostrophe and
shown in green? - CORRECT ANSWER comment
Which of the following extensions identifies a macro-enabled workbook? - CORRECT
ANSWER .xlsm
Which of the following runs in a window that is separate from Excel? - CORRECT
ANSWER vbe
A macro records every step and every keystroke, including incorrect or unnecessary
steps. - CORRECT ANSWER true
Macro names must begin with a number and cannot contain spaces. - CORRECT
ANSWER false
, Once a shortcut has been assigned to a macro, it cannot be changed. - CORRECT
ANSWER false
To save your macros, you must save the workbook as an Excel macro-enabled
workbook. - CORRECT ANSWER true
Apply data validation rules to the selected cells to allow only decimal numbers between
2.5 and 4.0. Do not allow blanks. - CORRECT ANSWER In the Data Ribbon Tab in
the Data Tools Ribbon Group, you clicked the Data Validation button arrow. In the Data
Validation menu, you clicked the Data Validation... menu item. Inside the Data
Validation dialog in the Allow drop-down, you selected Decimal. Inside the Data
Validation dialog, you typed 2.5 in the Minimum: input, typed 4.0 in the Maximum: input,
unchecked the Ignore blank check box, and clicked the OK button.
Display all the comments in this worksheet at once. - CORRECT ANSWER In the
Review Ribbon Tab in the Comments Ribbon Group, you clicked the Show All
Comments button.
Create a new scenario to reflect a change in cell B9 to a value of 0.01 Name the
scenario Low COLA. - CORRECT ANSWER In the Data Ribbon Tab in the
Forecast Ribbon Group, you clicked the What-If Analysis button. In the What-If Analysis
menu, you clicked the Scenario Manager... menu item. Inside the Scenario Manager
dialog, you clicked the DialogHeader view, clicked the dialog undefined button, and
clicked the Add... button. Inside the Add Scenario dialog, you typed Low COLA in the
Scenario name: input, clicked the OK button. Inside the Scenario Values dialog, you
typed 0.01 in the text box input, clicked the OK button.
Complete the one-variable data table in cells E3:F8 to calculate the breakeven sales
point for varying owner withdrawal amounts. The formula has been entered for you in
cell E3. It references the original owner withdrawal value in cell B12. The substitute
values have been entered for you in cells E4:E8. - CORRECT ANSWER Ribbon
Group, you clicked the What-If Analysis button. In the What-If Analysis menu, you
clicked the Data Table... menu item. Inside the Data Table dialog, you clicked the
DialogHeader view, clicked the dialog undefined button, typed B12 in the Column input
cell input, and clicked the OK button.
Use Goal Seek to find the value for cell C2 that will result in a value of $550,000 for cell
B15. Accept the solution. - CORRECT ANSWER In the Data Ribbon Tab in the
Forecast Ribbon Group, you clicked the What-If Analysis button. In the What-If Analysis
menu, you clicked the Goal Seek... menu item. Inside the Goal Seek dialog, you typed
550,000 in the To value: input, typed C2 in the By changing cell: input, and clicked the
OK button. Inside the Goal Seek Status dialog, you clicked the OK button.
Use Solver to find the combination of procedures that will result in the maximum
possible profit per week in cell B7. Use the range name Optimal as the variable cells.
