2024-25 MISY 5325 MS Excel Midterm Exam 2025
ACTUAL EXAM 370 QUESTIONS AND VERIFIED
ANSWERS GET IT 100% ACCURATE ALREADY
GRADED A+
___ specify the restrictions or limitations imposed on a spreadsheet mode as Solver
determines the optimum value of the objective cell. - CORRECT ANSWER: constraints
____ has the ability to generate Answer Reports. - CORRECT ANSWER: Solver
______ is/are used to place worksheet, column, and row titles on a worksheet. -
CORRECT ANSWER: Text
___is the best what-if analysis tool to solve complex linear and nonlinear problems -
CORRECT ANSWER: Solver
(Home tab | Alignment group) - CORRECT ANSWER: which of the following is the path
to the increase or decrease indent button
* - CORRECT ANSWER: What symbol shows that you are multiplying??
/ - CORRECT ANSWER: What symbol shows that you are dividing??
#### - CORRECT ANSWER: Excel displays the error message __________ in cells not
wide enough to display the entire entry.
#REF! - CORRECT ANSWER: Excel displays the error message ____ _____ in cells to
indicate a cell reference error as a result of deleting a row or column.
,+ - CORRECT ANSWER: If the following arithmetic operations all are found in a formula
with no parentheses, which one is completed last?
= - CORRECT ANSWER: What symbol shows that you are inserting a formula??
=B3*C3 - CORRECT ANSWER: What formula is in D3??
>=0 and <=30000 - CORRECT ANSWER: To specify that entries in the Returns field
must be between $0.00 and $30,000.00, enter _________ in the Validation Rule
property box.
1 - CORRECT ANSWER: Excel opens a new workbook with ____________
worksheets.
1,048,576 - CORRECT ANSWER: Each Excel worksheet has over ___________
possible rows.
1.Add-in
2.Binding constraint
3.Constraint
4.Changing variable cell
5.Solver - CORRECT ANSWER: 1.A program that can be added to Excel to provide
enhanced function
2.A constraint that Solver enforces to reach the target value
3.A limitation that imposes restrictions on Solver
4.A cell containing a variable whose value changes until Solver optimizes the value in
the objective cell
5. An add-in application that manipulates variables based on constraints to find the
optimal solution to a problem.
,1.Filtering
2.Top 10 option
3.Custom Filter
4.Duplicate Values
5.Sorting - CORRECT ANSWER: 1.displays only records that meet conditions
2.specify a number or percentage of records to display
3.complex filtering requirements
4.conditional formatting that displays doubled cells
5.arranges records in a table by the value
1.Scenario Manager
2.Scenario Summary Report
3.Scenario
4.Goal seek
5.Optimization model - CORRECT ANSWER: 1.Enables you to define and manage
scenarios to compare how they affect results
2.A worksheet that contains scenario results
3.Detailed sets of values that represent different possible situations
4.A tool that identifies the necessary input value to obtain a desired goal
5.Finds that highest, lowest, or exact value for one particular result by adjusting values
for selected variables
1.Slicer
2.Filter
3.Calculated Field
4.PivotChart
5.Slicer caption - CORRECT ANSWER: 1.A small window containing one button for
each unique item in a field so that you can filter the PivotTable quickly
, 2.Excludes particular categories or values
3.A user-defined field that does not exist int he original dataset
4.An interactive graphical representation of the data in a PivotTable
5.Text that displays in the header at the top of the slicer window
10 - CORRECT ANSWER: How many chart types does Excel offer?
15 - CORRECT ANSWER: The default row height is ________ points.
16,384 - CORRECT ANSWER: Each Excel worksheet has over ___________ possible
columns.
20xx - CORRECT ANSWER: When you enter a two digit year that is less than 30, XL
changes the year to
8.43 - CORRECT ANSWER: The default column width is _______ characters.
A chart is: - CORRECT ANSWER: a visual depiction of numerical data
A chart sheet: - CORRECT ANSWER: contains a single chart and no spreadsheet data.
A chart__ controls which data series and categories are visible in a chart. - CORRECT
ANSWER: filter
A nested function: - CORRECT ANSWER: contains another function embedded inside
one or more of its arguments.
A pie chart - CORRECT ANSWER: shows each data point in proportion to the whole
data series as a slice in a circular pie.
ACTUAL EXAM 370 QUESTIONS AND VERIFIED
ANSWERS GET IT 100% ACCURATE ALREADY
GRADED A+
___ specify the restrictions or limitations imposed on a spreadsheet mode as Solver
determines the optimum value of the objective cell. - CORRECT ANSWER: constraints
____ has the ability to generate Answer Reports. - CORRECT ANSWER: Solver
______ is/are used to place worksheet, column, and row titles on a worksheet. -
CORRECT ANSWER: Text
___is the best what-if analysis tool to solve complex linear and nonlinear problems -
CORRECT ANSWER: Solver
(Home tab | Alignment group) - CORRECT ANSWER: which of the following is the path
to the increase or decrease indent button
* - CORRECT ANSWER: What symbol shows that you are multiplying??
/ - CORRECT ANSWER: What symbol shows that you are dividing??
#### - CORRECT ANSWER: Excel displays the error message __________ in cells not
wide enough to display the entire entry.
#REF! - CORRECT ANSWER: Excel displays the error message ____ _____ in cells to
indicate a cell reference error as a result of deleting a row or column.
,+ - CORRECT ANSWER: If the following arithmetic operations all are found in a formula
with no parentheses, which one is completed last?
= - CORRECT ANSWER: What symbol shows that you are inserting a formula??
=B3*C3 - CORRECT ANSWER: What formula is in D3??
>=0 and <=30000 - CORRECT ANSWER: To specify that entries in the Returns field
must be between $0.00 and $30,000.00, enter _________ in the Validation Rule
property box.
1 - CORRECT ANSWER: Excel opens a new workbook with ____________
worksheets.
1,048,576 - CORRECT ANSWER: Each Excel worksheet has over ___________
possible rows.
1.Add-in
2.Binding constraint
3.Constraint
4.Changing variable cell
5.Solver - CORRECT ANSWER: 1.A program that can be added to Excel to provide
enhanced function
2.A constraint that Solver enforces to reach the target value
3.A limitation that imposes restrictions on Solver
4.A cell containing a variable whose value changes until Solver optimizes the value in
the objective cell
5. An add-in application that manipulates variables based on constraints to find the
optimal solution to a problem.
,1.Filtering
2.Top 10 option
3.Custom Filter
4.Duplicate Values
5.Sorting - CORRECT ANSWER: 1.displays only records that meet conditions
2.specify a number or percentage of records to display
3.complex filtering requirements
4.conditional formatting that displays doubled cells
5.arranges records in a table by the value
1.Scenario Manager
2.Scenario Summary Report
3.Scenario
4.Goal seek
5.Optimization model - CORRECT ANSWER: 1.Enables you to define and manage
scenarios to compare how they affect results
2.A worksheet that contains scenario results
3.Detailed sets of values that represent different possible situations
4.A tool that identifies the necessary input value to obtain a desired goal
5.Finds that highest, lowest, or exact value for one particular result by adjusting values
for selected variables
1.Slicer
2.Filter
3.Calculated Field
4.PivotChart
5.Slicer caption - CORRECT ANSWER: 1.A small window containing one button for
each unique item in a field so that you can filter the PivotTable quickly
, 2.Excludes particular categories or values
3.A user-defined field that does not exist int he original dataset
4.An interactive graphical representation of the data in a PivotTable
5.Text that displays in the header at the top of the slicer window
10 - CORRECT ANSWER: How many chart types does Excel offer?
15 - CORRECT ANSWER: The default row height is ________ points.
16,384 - CORRECT ANSWER: Each Excel worksheet has over ___________ possible
columns.
20xx - CORRECT ANSWER: When you enter a two digit year that is less than 30, XL
changes the year to
8.43 - CORRECT ANSWER: The default column width is _______ characters.
A chart is: - CORRECT ANSWER: a visual depiction of numerical data
A chart sheet: - CORRECT ANSWER: contains a single chart and no spreadsheet data.
A chart__ controls which data series and categories are visible in a chart. - CORRECT
ANSWER: filter
A nested function: - CORRECT ANSWER: contains another function embedded inside
one or more of its arguments.
A pie chart - CORRECT ANSWER: shows each data point in proportion to the whole
data series as a slice in a circular pie.
