Tentamen (uitwerkingen)
MIS112 with questions Solved 100% Correct
- Vak
- Instelling
MIS112 with questions Solved 100% Correct
[Meer zien]Voorbeeld 3 van de 19 pagina's
Voorbeeld 3 van de 19 pagina's
In winkelwagen
In winkelwagen
gesponsord bericht van onze partner
Verkoper
Volgen
Examsplug
Ontvangen beoordelingen
Voorbeeld van de inhoud
MIS112 with questions Solved 100% CorrectWhat does the following formula return? =CHAR(68) - Answer D
Which of the following entries does Excel automatically recognize as a date (using the
U.S. settings)? - Answer None of the answers provided is correct
In Excel, if one enters a time greater than ten thousand hours, it is interpreted as
________ instead of a time value. - Answer a text string
If you want to apply a date format to serial numbers, which of the following choices will
work for you? Assume you have already done the following steps: selected a cell with
the serial number, gone to the Home tab, within that the Number group, clicked the
drop-down arrow in the Number format box) - Answer All of the options provided will
work
Which of the following is TRUE about the DATEDIF() function? - Answer You must enter
it manually
When you activate a cell that contains a date, the formula bar usually shows the cell
contents formatted using the following date format: - Answer None of the answers
provided is correct
To find a working date that falls after a number of days (e.g., 12 business days after
some date), you typically use this function: - Answer WORKDAY()
To get rid of ALL blank spaces in a string (e.g., in "Jo hn Doe "), which Excel function will
you use? - Answer =SUBSTITUTE()
,The _____________ function is used to return a specified number of letters or
characters from the end of a text string. - Answer RIGHT()
To eliminate redundant blank space from the start or end of a string (e.g., " Tucson "),
which Excel function will you use? - Answer =TRIM()
If cell A1 contained the text MR. JOHN Q. PUBLIC, what would the formula
(=PROPER(A1)) return? - Answer Mr. John Q. Public
If a pivot chart is created and the underlying table is deleted, what occurs? - Answer The
pivot chart remains.
Which of the following is one of the ways to create a Pivot Chart? - Answer Insert (tab) -
> Charts (group) -> PivotChart
Examine the attached workbook. The data represents the amount of money a customer
has spent, in a quarter, to buy a product. Create a PivotTable based on the (entire) table
of data in the Sales worksheet. For Row Labels, choose the Product column. Include
Columns C, D, E and F in the Values-area. What is the total revenue (sales in dollars)
generated in Qtr 4 for the Products 'Aniseed Syrup', 'Boston Crab Meat' and
'Camembert Pierrot'?
Pivot_table_test.xlsx - Answer 5156
Ex3.xlsx Please refer to the attached workbook. The ______ , ________ and
________fields are in the Column, Rows and Values section respectively. - Answer
AcctType, branch, count of amount
How do you remove a filter in the PivotTable Field List? - Answer Move the cursor over
the filter icon next to the field name you want to remove the filter from. Click the arrow
that appears, and then choose the Clear Filter From option.
, To remove a single individual field from a report, _______ the check box beside the field
name in the PivotTable Field List. - Answer clear
When do you use the following sequence of commands: PivotTable Tools -> Analyze ->
PivotTable -> Options -> Generate GetPivot Data? - Answer prevent Excel from using
GETPIVOTDATA function
When you create a PivotTable report, each column of your source data becomes a
_____ that you can use in the report. - Answer field
A calculated field must reside in the ________ area of the pivot table. - Answer Values
What is Not the purpose of using Slicers? - Answer Make table more beautiful
When the value of a cell is changed (after conditional formatting is applied), the cell
formatting ______ based on the conditions set. - Answer is updated
Which of the following is NOT one of the methods for 'Conditional Formatting' in Excel?
- Answer Pie Chart
In the following choices, which one is not among the drop-down list of the conditional
formatting on the ribbon? - Answer Number bars
Assume the "range_lookup" parameter in an HLOOKUP function is FALSE. If an exact
match is not found, what value is returned? - Answer #N/A
dataLOOKUP_Ex2.xlsx Please see the attached workbook. What formula (in cell B3)
would return the tax rate for the income in cell B2? - Answer =HLOOKUP(B2, E1:J3, 3)
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 €11,99. 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