Tentamen (uitwerkingen)
MIS112 Study questions Solved 100% Correct
- Vak
- Instelling
MIS112 Study questions Solved 100% Correct
[Meer zien]Voorbeeld 3 van de 22 pagina's
Voorbeeld 3 van de 22 pagina's
In winkelwagen
In winkelwagen
gesponsord bericht van onze partner
Verkoper
Volgen
Examsplug
Ontvangen beoordelingen
Voorbeeld van de inhoud
MIS112 Study questions Solved 100% CorrectWhich of the following methods is a VALID way to get into cell edit mode? - Answer
Selecting the cell that you want to edit, and then clicking in the Formula bar
In Row 2 (Col B), which of the following formatting types has been applied to
"3419.25041" to make it appear as "$3,419.25" ? - Answer Currency
Which keyboard shortcuts can be used to move the active cell one column to the left? -
Answer Left arrow or Shift + Tab
You select a cell with data "120" in an Excel worksheet and press the "Delete" key on
your keyboard. Which of the following holds TRUE? - Answer only the contents of the
cell are removed (not formatting)
What happens if you try to store a number greater than 15 digits in Excel ? - Answer
Replace the digits exceeding 15 with the number zero
What is metadata? - Answer Descriptive information about a workbook
Which of the following is the file format of the Excel 97-2003 workbook? - Answer .xls
What is the name of the company that created Excel? - Answer Microsoft
In the attached Excel workbook PS1_Comments_Calculation.xlsx , which of the following
formulas can be used to calculate Sophie's total score in both the exams? - Answer
=B4+C4
,To calculate the percentage of the total widget sales made by the top 5 employees,
which of the following formulae would you enter in cell "C22" (shaded purple) - Answer
=C20/F8
In the Top Salespersons list, which feature can be used to populate the numbers "3,"
"4," and "5" in cells "A17," "A18," and "A19," respectively? - Answer autofill
Does deleting a cell by pressing the Delete key also delete the conditional formatting on
the cell? - Answer no
When a range of cells is selected, which of the following occurs? - Answer all selected
cells are bounded by a selection box, and all but the active cell in the range are
highlighted/shaded
Which type of chart does not allow format changes to the Plot area?
-Treemap
-None of the (other) options provided is correct
-Thermometer chart
-Bar chart - Answer None of the (other) options provided is correct
how do you access cell formatting options? - Answer Ctrl+1
After you have selected the data to create a chart, which of the following is the correct
sequence of options needed to create a clustered column chart? - Answer Insert -->
Charts --> Column --> Clustered Column
A chart in an Excel worksheet provides a visual representation of which of the following?
- Answer numeric values
, Examine the attached workbook. If you want to remove chart labels, where do you find
the options to do so within the Design tab (Chart Tools)? - Answer Add Chart Element >
Data Labels
To move "Chart 1" in "Sheet1" to a new Excel worksheet named "MyChart", which
options will you use? - Answer Click on: (Chart Tools) Design tab --> Move chart
(Location) --> New Sheet (option)
Which of the following is NOT a state an Excel workbook can be in? - Answer
Which of the following is a VALID method of hiding rows or columns? - Answer Home
(ribbon tab), (then) Format (in the Cells group) --> Hide & Unhide (from the drop down
list)
Which of the following View ribbon tab options was used to display the horizontal bar
between the nonconsecutive rows containing "Astoria, OR" and "Victoria, TX"? - Answer
Split
A single element in a worksheet that can hold a value, some text, or a formula is
referred to as which of the following? - Answer cell
If you copy cell "B6" and paste it as a formula in cell "C6," will it produce the correct
total for Year 2? - Answer Yes, the formula range will be adjusted automatically
Charts are dynamic, e.g., they change as the underlying data changes. Is this an accurate
statement? - Answer Yes, by default they are dynamic.
After you create a chart, which of the following actions can you perform on it? - Answer
change the chart type, formatting, and data series
Voordelen van het kopen van samenvattingen bij Stuvia op een rij:
Verzekerd van kwaliteit door reviews
Stuvia-klanten hebben meer dan 700.000 samenvattingen beoordeeld. Zo weet je zeker dat je de beste documenten koopt!
Snel en makkelijk kopen
Je betaalt supersnel en eenmalig met iDeal, creditcard of Stuvia-tegoed voor de samenvatting. Zonder lidmaatschap.
Focus op de essentie
Samenvattingen worden geschreven voor en door anderen. Daarom zijn de samenvattingen altijd betrouwbaar en actueel. Zo kom je snel tot de kern!
Veelgestelde vragen
Wat krijg ik als ik dit document koop?
Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.
Tevredenheidsgarantie: hoe werkt dat?
Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.
Van wie koop ik deze samenvatting?
Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper Examsplug. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor €12,45. Je zit daarna nergens aan vast.
Is Stuvia te vertrouwen?
4,6 sterren op Google & Trustpilot (+1000 reviews)
Afgelopen 30 dagen zijn er 73091 samenvattingen verkocht
Opgericht in 2010, al 14 jaar dé plek om samenvattingen te kopen