MIS112 Midterm Exam with questions Solved
100% Correct
a single element in a worksheet that can hold a value, some text, or a formula is
referred to as what - Answer cell
does deleting a cell by pressing the delete key also delete the conditional formatting on
a cell - Answer no
a bar chart is essentially what chart type rotated 90 degrees clockwise - Answer column
after you have selected the data to create a chart, what is the correct sequence of
options needed to create a clustered column chart - Answer insert --> charts --> column
--> clustered column
must a chart be embedded in the same worksheet as its data source - Answer no, a
chart can be embedded or placed in a sheet separate from that of its data source
examine the survey results in the attached workbook (in Sheet2). what type of chart
would be most suitable to represent the survey response data #8 - Answer pie
examine the attached workbook. how can you resize the chart title in chart 1 of sheet 1.
#19 - Answer change font size
which of the following options is NOT available after right clicking on an Excel worksheet
tab - Answer changing the font color in the worksheet
, which of the following methods will keep a heading at the top of a table visible while
you scroll through rows lower down in the worksheet - Answer use freeze panes
which option provided in the view ribbon tab is best to compare two open Excel
workbooks simultaneously in Excel 2016? - Answer view side by side
which of the following function(s) can be used to count error values in a range - Answer
ISERROR(), ISERR(), ISNA()
examine the image in the question. In "C3," we have the supplies address "Tucson, AZ
85721" appearing in a single cell (the formula combines data from cells "E3," "F3,"
"G3"). Which of the following formulas will archive this result #9 - Answer =E3 &", "&F3
&" "&G3
in the formula =ROWS(Asset) * COLUMNS (Asset) that is used to calculate the number of
cells in a range named Asset doesn't work, what does it imply? - Answer the range Asset
consists of non-continuous cells
please examine the attached image. which of the following formulas will calculate the
total number of stores across the four states? #10 - Answer =SUM(B2:B5)
please select the excel function which allows us to answer the question: "How many
days of stock data do I have left?" You may refer to the image in the question #11 -
Answer COUNT()
the easiest way to enter a function into a formula is to use Formula AutoComplete (the
drop-down list the Excel displays while you type a formula). Another way to insert a
function is to used the ______ on the _____ tab - Answer function library group (on the)
formulas
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,48. Je zit daarna nergens aan vast.