MISY 5325 Microsoft Excel: Midterm Exam Study Guide Questions and Answers 100% Correct
7 vues 0 fois vendu
Cours
MISY 5325 Microsoft Excel
Établissement
MISY 5325 Microsoft Excel
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...
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
Les avantages d'acheter des résumés chez Stuvia:
Qualité garantie par les avis des clients
Les clients de Stuvia ont évalués plus de 700 000 résumés. C'est comme ça que vous savez que vous achetez les meilleurs documents.
L’achat facile et rapide
Vous pouvez payer rapidement avec iDeal, carte de crédit ou Stuvia-crédit pour les résumés. Il n'y a pas d'adhésion nécessaire.
Focus sur l’essentiel
Vos camarades écrivent eux-mêmes les notes d’étude, c’est pourquoi les documents sont toujours fiables et à jour. Cela garantit que vous arrivez rapidement au coeur du matériel.
Foire aux questions
Qu'est-ce que j'obtiens en achetant ce document ?
Vous obtenez un PDF, disponible immédiatement après votre achat. Le document acheté est accessible à tout moment, n'importe où et indéfiniment via votre profil.
Garantie de remboursement : comment ça marche ?
Notre garantie de satisfaction garantit que vous trouverez toujours un document d'étude qui vous convient. Vous remplissez un formulaire et notre équipe du service client s'occupe du reste.
Auprès de qui est-ce que j'achète ce résumé ?
Stuvia est une place de marché. Alors, vous n'achetez donc pas ce document chez nous, mais auprès du vendeur ACADEMICMATERIALS. Stuvia facilite les paiements au vendeur.
Est-ce que j'aurai un abonnement?
Non, vous n'achetez ce résumé que pour €7,79. Vous n'êtes lié à rien après votre achat.
