MISY 5325 MS Excel Midterm Exam || Most Recent Exam 2026
-2027 Actual Complete Real Exam Questions And Correct
Answers (Verified Answers) Already Graded A+ |
Guaranteed Success!! Newest Exam || Just
Released!!
The Anne Cole data point has been selected for you. Rotate the
pie chart exactly 200° so this data point appears at the left side
of the chart near the legend. - ANSWER -On the Chart Tools
Format tab, in the Current Selection group, click the Format
Selection button to open the Format Data Point task pane. In
the Angle of first slice box, type the 200 and press Enter.
Convert the table to a normal range. - ANSWER -On the Table
Tools Design
tab, in the Tools group, click the Convert to Range
button. Click Yes.
Collapse the entire outline to show just the subtotals. -
ANSWER -Click the 2
outline symbol at the left of the column
headings.
Use Goal Seek to find the value for cell D12 that will result in a
value of
,$650,000 for cell B15. Accept the solution. - ANSWER -On the
Data tab, in the
Data Tools group, click the What-If Analysis button, and click
Goal Seek... Enter 650000 in the To value box. Enter D12 in the
By changing cell box. Click OK. Click OK.
Modify the number format so no decimal places are visible after
the decimal point. - ANSWER -On the Home tab, in the Number
group, click the Decrease Decimal button twice.
The 2016 data point in the Gross Profit data series has been
selected. Change the outline width to 2 1/4 pt. - ANSWER -On
the Chart Tools Format tab, Shape Styles group, click the
Shape Outline button, point to Weight, and select 2 1/4 pt.
Import data from the text file StudentGPA into the selected cell
in the current worksheet. Data in the file are delimited by
commas, and the file does include a header row. Do not modify
any of the column data formats. - ANSWER -Import External
Data - Text - StudentGPA - Okay - Okay
In cell E15, enter a formula to find the lowest line item cost
this month (cells
E2:E14). - ANSWER -
=MIN(Range)
Switch to the view that shows all the worksheet elements as
they will print, including headers and footers. - ANSWER -Page
Layout mini button by Zoom Slider
,Modify the status bar so it displays the results of the MIN
function for the
selected cells. - ANSWER -Right Click Status Bar
(at bottom)
Cells D1:D6 have been cut. Insert them at the current
worksheet location (cell
C1). - ANSWER -Home - Insert- Insert
Cut Cells
Use Format Painter to copy the formatting from cell D1 and
apply it to cell E1. - ANSWER -Click Paintbrush Icon on Home
Tab (located by Paste/Clipboard) - Click on desired cell
Show the tracer arrows for the selected cell to display arrows to
the cells containing formulas that reference the value or
formula in the selected cell. - ANSWER -Formulas Tab - Formula
Auditing - Trace Dependents
Unlock the selected cells so the user can edit the cells when
the worksheet is
protected. - ANSWER -Home Tab - Cells - Format (arrow)
- Lock Cell
Add Column Sparklines to cells F2:F11 to represent the
values in B2:E11. -
ANSWER -Insert Tab - Sparklines Group
– Column
, Filter the data in place so that only rows where the Category
value is Meals and
the Cost value is greater than 20 are shown. The criteria range
has been set up
for you in cells A1:C2. - ANSWER -Data Tab - Sort and Filter
- Advanced
Modify the worksheet so the first row is always visible
when you scroll the
worksheet down. - ANSWER -View Tab -
Freeze Panes
Remove duplicate rows where data in all the columns are
identical. - ANSWER
-Table Tools Design Tab - Tools Group - Remove
Duplicates - OK - OK
Add markers for all the data points in this Sparkline
group. - ANSWER -
Sparkline Tools Design Tab - Show Group -
Markers Checkbox
Add the Bonus field to the PivotTable. - ANSWER -Scroll
down in Fields -
Check Bonus
checkbox
Enter a formula in cell B4 using the VLOOKUP function to find
the meaning for the medical abbreviation listed in cell A4. Use
-2027 Actual Complete Real Exam Questions And Correct
Answers (Verified Answers) Already Graded A+ |
Guaranteed Success!! Newest Exam || Just
Released!!
The Anne Cole data point has been selected for you. Rotate the
pie chart exactly 200° so this data point appears at the left side
of the chart near the legend. - ANSWER -On the Chart Tools
Format tab, in the Current Selection group, click the Format
Selection button to open the Format Data Point task pane. In
the Angle of first slice box, type the 200 and press Enter.
Convert the table to a normal range. - ANSWER -On the Table
Tools Design
tab, in the Tools group, click the Convert to Range
button. Click Yes.
Collapse the entire outline to show just the subtotals. -
ANSWER -Click the 2
outline symbol at the left of the column
headings.
Use Goal Seek to find the value for cell D12 that will result in a
value of
,$650,000 for cell B15. Accept the solution. - ANSWER -On the
Data tab, in the
Data Tools group, click the What-If Analysis button, and click
Goal Seek... Enter 650000 in the To value box. Enter D12 in the
By changing cell box. Click OK. Click OK.
Modify the number format so no decimal places are visible after
the decimal point. - ANSWER -On the Home tab, in the Number
group, click the Decrease Decimal button twice.
The 2016 data point in the Gross Profit data series has been
selected. Change the outline width to 2 1/4 pt. - ANSWER -On
the Chart Tools Format tab, Shape Styles group, click the
Shape Outline button, point to Weight, and select 2 1/4 pt.
Import data from the text file StudentGPA into the selected cell
in the current worksheet. Data in the file are delimited by
commas, and the file does include a header row. Do not modify
any of the column data formats. - ANSWER -Import External
Data - Text - StudentGPA - Okay - Okay
In cell E15, enter a formula to find the lowest line item cost
this month (cells
E2:E14). - ANSWER -
=MIN(Range)
Switch to the view that shows all the worksheet elements as
they will print, including headers and footers. - ANSWER -Page
Layout mini button by Zoom Slider
,Modify the status bar so it displays the results of the MIN
function for the
selected cells. - ANSWER -Right Click Status Bar
(at bottom)
Cells D1:D6 have been cut. Insert them at the current
worksheet location (cell
C1). - ANSWER -Home - Insert- Insert
Cut Cells
Use Format Painter to copy the formatting from cell D1 and
apply it to cell E1. - ANSWER -Click Paintbrush Icon on Home
Tab (located by Paste/Clipboard) - Click on desired cell
Show the tracer arrows for the selected cell to display arrows to
the cells containing formulas that reference the value or
formula in the selected cell. - ANSWER -Formulas Tab - Formula
Auditing - Trace Dependents
Unlock the selected cells so the user can edit the cells when
the worksheet is
protected. - ANSWER -Home Tab - Cells - Format (arrow)
- Lock Cell
Add Column Sparklines to cells F2:F11 to represent the
values in B2:E11. -
ANSWER -Insert Tab - Sparklines Group
– Column
, Filter the data in place so that only rows where the Category
value is Meals and
the Cost value is greater than 20 are shown. The criteria range
has been set up
for you in cells A1:C2. - ANSWER -Data Tab - Sort and Filter
- Advanced
Modify the worksheet so the first row is always visible
when you scroll the
worksheet down. - ANSWER -View Tab -
Freeze Panes
Remove duplicate rows where data in all the columns are
identical. - ANSWER
-Table Tools Design Tab - Tools Group - Remove
Duplicates - OK - OK
Add markers for all the data points in this Sparkline
group. - ANSWER -
Sparkline Tools Design Tab - Show Group -
Markers Checkbox
Add the Bonus field to the PivotTable. - ANSWER -Scroll
down in Fields -
Check Bonus
checkbox
Enter a formula in cell B4 using the VLOOKUP function to find
the meaning for the medical abbreviation listed in cell A4. Use
