Exam (elaborations)
MIS112 Midterm Exam with questions Solved 100% Correct
- Course
- Institution
MIS112 Midterm Exam with questions Solved 100% Correct
[Show more]
Content preview
MIS112 Midterm Exam with questions Solved100% 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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Examsplug. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75632 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now