1|Page
BUS 375 Exam 4 Hands On | Actual Exam
Questions With Accurate Detailed Solutions
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, clicked the Dialog
Header view, clicked the dialog undefined button, clicked the Dialog Header view,
clicked the dialog undefined button, typed 4.0 in the Maximum: input, unchecked
the Ignore blank check box, and clicked the OK button.
Complete the two-variable data table in cells A7:E12. The formula has been
entered for you in cell A7. The substitute values in cells B7:E7 reference the
original cost of goods percentage in cell B3, and the substitute values in cells
A8:A12 reference the original owner withdrawal percentage in cell B4. -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 Data
Table... menu item. Inside the Data Table dialog, you clicked the DialogHeader
view, clicked the dialog undefined button, and typed in the Row input cell input.
You selected the cell range A7:E12, selected the cell range A7:E12. Inside the Data
Table dialog, you clicked the OK button.
BUS 375 Exam 4 Hands On | Actual Exam
Questions With Accurate Detailed Solutions
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, clicked the Dialog
Header view, clicked the dialog undefined button, clicked the Dialog Header view,
clicked the dialog undefined button, typed 4.0 in the Maximum: input, unchecked
the Ignore blank check box, and clicked the OK button.
Complete the two-variable data table in cells A7:E12. The formula has been
entered for you in cell A7. The substitute values in cells B7:E7 reference the
original cost of goods percentage in cell B3, and the substitute values in cells
A8:A12 reference the original owner withdrawal percentage in cell B4. -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 Data
Table... menu item. Inside the Data Table dialog, you clicked the DialogHeader
view, clicked the dialog undefined button, and typed in the Row input cell input.
You selected the cell range A7:E12, selected the cell range A7:E12. Inside the Data
Table dialog, you clicked the OK button.
