SAR MIS112 EXAM QUESTIONS WITH ALL CORRECT ANSWERS
4 keer bekeken 0 keer verkocht
Vak
SAR MIS112
Instelling
SAR MIS112
SAR MIS112 EXAM QUESTIONS WITH ALL CORRECT ANSWERS
Which of the following is an object that contains the actual data in the chart?
Plot area
Pie area
Bar area
Column are - Answer-Plot area
Fill in the blank: Every chart type has a set of ____ that you can choose from (with settings...
sar mis112 exam questions with all correct answers
Geschreven voor
SAR MIS112
SAR MIS112
Verkoper
Volgen
Scholarsstudyguide
Ontvangen beoordelingen
Voorbeeld van de inhoud
SAR MIS112 EXAM QUESTIONS WITH
ALL CORRECT ANSWERS
Which of the following is an object that contains the actual data in the chart?
Plot area
Pie area
Bar area
Column are - Answer-Plot area
Fill in the blank: Every chart type has a set of ____ that you can choose from (with
settings for chart elements such as a title, data labels, axes, and so on).
Shapes
Categories
Layouts
Attributes - Answer-Layouts
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)?
Add Chart Element > Chart title
Remove Chart Element > Data Labels
Add Chart Element > Data Labels
Remove Chart Element > Chart title - Answer-Add Chart Element > Data Labels
Please examine the attached workbook. The chart was created based on data in cells
A1 through C6. If new data is added in cells A7 through C7, will the chart include the
new data automatically?
PS2_Chart1
Yes
Yes, but only because it is a Stacked Column chart
No
No, this feature is only supported for Clustered Column charts - Answer-No
What is the maximum number of characters a worksheet name can contain?
,31
34
28
32 - Answer-31
Please refer to the attached workbook. What is the width of Column D?
23
35
27
45 - Answer-45
Fill in the blanks: A cell in an Excel worksheet is identified by its address, which consists
of a column ___ and row ___.
letter, number
number, letter
value, range
range, value - Answer-letter, number
Examine the attached workbook. Fill in the blank: You can add a title to the vertical axis
of the chart by using Chart Layouts (Chart Tools "Design" tab) --> Add Chart Element --
> __________
Chart Titles
Legend
Axis Titles
Data Labels - Answer-Axis Titles
Please see the attached workbook.
If you copy cell "B6" and paste it as a formula in cell "C6," will it produce the correct total
for Year 2?
No, because the result will be the total for Quarter 1.
No, because you must directly enter the formula for each quarter in cell C6.
Yes for Excel 2013, but not for previous versions of Excel.
, Yes, the formula range will be adjusted automatically - Answer-Yes, the formula range
will be adjusted automatically
Which of the following function(s) can be used to count error values in a range?
all of the provided choices are valid
ISERROR()
ISERR()
ISNA() - Answer-all of the provided choices are valid
Examine the attached worksheet. We want to display in cells H2 to H8 the names of the
items whose quantity purchased is greater than the Average quantity reported in cell
B10. If the quantity purchased is equal or lower, we want to display 0. Which formula,
entered in H2 and extended to H8, will achieve this?
Formulas_Test_v2.xlsx
=IF(B2>$B$10, A2,0)
=IF(B2>B10, A2,0)
=IFERROR(B2>B10, A2,0)
=IFERROR(B2>$B$10, A2,0) - Answer-=IF(B2>$B$10, A2,0)
Please refer to the figure. In an Excel worksheet, what column name comes directly
after Column Z?
AA
AZ
ZA
ZZ - Answer-AA
Please examine the attached workbook. Given the data in Sheet1, which of the
following steps should be followed to obtain the data in Sheet2 ?
PS1_Sheets
Select cells A1 through D3 in Sheet1 -> Copy -> Transpose -> Go to Sheet2 -> Paste
Select cells A1 through D3 in Sheet1 -> Copy -> Go to Sheet2 -> Paste -> Transpose
It is only possible if done manually
Select cells A1 through D3 in Sheet1 -> Copy -> Go to Sheet2 -> Paste -> Formulas -
Answer-Select cells A1 through D3 in Sheet1 -> Copy -> Go to Sheet2 -> Paste ->
Transpose
Please refer to the figure. Which of the following Excel tabs is NOT visible in a
worksheet by default?
Developer
Review
Home
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 Scholarsstudyguide. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor €12,00. Je zit daarna nergens aan vast.
