MISY 5325 Microsoft Excel: Midterm
Exam Study Guide
Sparkline - ✔️✔️A(n) _____ chart provides a simple way to show to show trends and
variations in a range of data within a single cell.
The 2016 data point in the Gross Profit data series has been selected. Change the
outline width to 2 1/4 pt. - ✔️✔️On the Chart Tools Format tab, Shape Styles group,
click the Shape Outline button, point to Weight, and select 2 1/4 pt.
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. - ✔️✔️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.
quick access toolbar - ✔️✔️
formula bar - ✔️✔️
name box - ✔️✔️
close button - ✔️✔️
title bar - ✔️✔️
columns - ✔️✔️What part of Excel Window is labeled with the ALPHABET
rows - ✔️✔️What part of Excel Windows is labeled with NUMBERS
active cell - ✔️✔️What is the part called that has the BLACK BORDER BOX
Ctrl O - ✔️✔️the shortcut key to open WORKBOOK
Ctrl N - ✔️✔️the shortcut key to open a NEW WORKBOOK
,Ctrl S & F12 - ✔️✔️the shortcut key to SAVE a WORKBOOK
Ctrl P - ✔️✔️the shortcut key to PRINT a WORKBOOK
Ctrl W - ✔️✔️the shortcut key to CLOSE A WORKBOOK
tab/right arrow - ✔️✔️Which key makes you go one cell to the right??
shift tab/left arrow - ✔️✔️Which key makes you go one cell to the left??
enter/down arrow - ✔️✔️Which key makes you go down one cell??
shift enter/up arrow - ✔️✔️Which key makes you go up one cell??
Ctrl Home - ✔️✔️Which key makes you go to call A1??
= - ✔️✔️What symbol shows that you are inserting a formula??
* - ✔️✔️What symbol shows that you are multiplying??
/ - ✔️✔️What symbol shows that you are dividing??
auto sum - ✔️✔️
=B3*C3 - ✔️✔️What formula is in D3??
cell - ✔️✔️Identifies where the column and the row meet??
workbook - ✔️✔️When a Microsoft Excel document is saved, what is it called??
Convert the table to a normal range. - ✔️✔️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. - ✔️✔️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. - ✔️✔️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. -
✔️✔️On the Home tab, in the Number group, click the Decrease Decimal button twice.
, 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. - ✔️✔️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). -
✔️✔️=MIN(Range)
Switch to the view that shows all the worksheet elements as they will print, including
headers and footers. - ✔️✔️Page Layout mini button by Zoom Slider
Modify the status bar so it displays the results of the MIN function for the selected cells.
- ✔️✔️Right Click Status Bar (at bottom)
Cells D1:D6 have been cut. Insert them at the current worksheet location (cell C1). -
✔️✔️Home - Insert- Insert Cut Cells
Use Format Painter to copy the formatting from cell D1 and apply it to cell E1. -
✔️✔️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. - ✔️✔️Formulas Tab -
Formula Auditing - Trace Dependents
Unlock the selected cells so the user can edit the cells when the worksheet is protected.
- ✔️✔️Home Tab - Cells - Format (arrow) - Lock Cell
Add Column Sparklines to cells F2:F11 to represent the values in B2:E11. - ✔️✔️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. - ✔️✔️Data Tab - Sort and Filter - Advanced
Modify the worksheet so the first row is always visible when you scroll the worksheet
down. - ✔️✔️View Tab - Freeze Panes
Remove duplicate rows where data in all the columns are identical. - ✔️✔️Table Tools
Design Tab - Tools Group - Remove Duplicates - OK - OK
Exam Study Guide
Sparkline - ✔️✔️A(n) _____ chart provides a simple way to show to show trends and
variations in a range of data within a single cell.
The 2016 data point in the Gross Profit data series has been selected. Change the
outline width to 2 1/4 pt. - ✔️✔️On the Chart Tools Format tab, Shape Styles group,
click the Shape Outline button, point to Weight, and select 2 1/4 pt.
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. - ✔️✔️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.
quick access toolbar - ✔️✔️
formula bar - ✔️✔️
name box - ✔️✔️
close button - ✔️✔️
title bar - ✔️✔️
columns - ✔️✔️What part of Excel Window is labeled with the ALPHABET
rows - ✔️✔️What part of Excel Windows is labeled with NUMBERS
active cell - ✔️✔️What is the part called that has the BLACK BORDER BOX
Ctrl O - ✔️✔️the shortcut key to open WORKBOOK
Ctrl N - ✔️✔️the shortcut key to open a NEW WORKBOOK
,Ctrl S & F12 - ✔️✔️the shortcut key to SAVE a WORKBOOK
Ctrl P - ✔️✔️the shortcut key to PRINT a WORKBOOK
Ctrl W - ✔️✔️the shortcut key to CLOSE A WORKBOOK
tab/right arrow - ✔️✔️Which key makes you go one cell to the right??
shift tab/left arrow - ✔️✔️Which key makes you go one cell to the left??
enter/down arrow - ✔️✔️Which key makes you go down one cell??
shift enter/up arrow - ✔️✔️Which key makes you go up one cell??
Ctrl Home - ✔️✔️Which key makes you go to call A1??
= - ✔️✔️What symbol shows that you are inserting a formula??
* - ✔️✔️What symbol shows that you are multiplying??
/ - ✔️✔️What symbol shows that you are dividing??
auto sum - ✔️✔️
=B3*C3 - ✔️✔️What formula is in D3??
cell - ✔️✔️Identifies where the column and the row meet??
workbook - ✔️✔️When a Microsoft Excel document is saved, what is it called??
Convert the table to a normal range. - ✔️✔️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. - ✔️✔️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. - ✔️✔️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. -
✔️✔️On the Home tab, in the Number group, click the Decrease Decimal button twice.
, 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. - ✔️✔️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). -
✔️✔️=MIN(Range)
Switch to the view that shows all the worksheet elements as they will print, including
headers and footers. - ✔️✔️Page Layout mini button by Zoom Slider
Modify the status bar so it displays the results of the MIN function for the selected cells.
- ✔️✔️Right Click Status Bar (at bottom)
Cells D1:D6 have been cut. Insert them at the current worksheet location (cell C1). -
✔️✔️Home - Insert- Insert Cut Cells
Use Format Painter to copy the formatting from cell D1 and apply it to cell E1. -
✔️✔️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. - ✔️✔️Formulas Tab -
Formula Auditing - Trace Dependents
Unlock the selected cells so the user can edit the cells when the worksheet is protected.
- ✔️✔️Home Tab - Cells - Format (arrow) - Lock Cell
Add Column Sparklines to cells F2:F11 to represent the values in B2:E11. - ✔️✔️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. - ✔️✔️Data Tab - Sort and Filter - Advanced
Modify the worksheet so the first row is always visible when you scroll the worksheet
down. - ✔️✔️View Tab - Freeze Panes
Remove duplicate rows where data in all the columns are identical. - ✔️✔️Table Tools
Design Tab - Tools Group - Remove Duplicates - OK - OK
