Exam (elaborations)
MIS 2201 Midterm II (UMD) Questions and 100% Correct Verified Solutions| Latest Update
- Course
- Institution
MIS 2201 Midterm II (UMD) Questions and 100% Correct Verified Solutions| Latest Update
[Show more]
Seller
Follow
Content preview
MIS 2201 Midterm II (UMD)Questions and 100% Correct Verified
Solutions| Latest Update
How to create page breaks in Excel - Answer select 'page break', select the row below
where you want to insert the page break (vertical page break) or select the column to
the right of where you want to insert the page break (horizontal page break), and
click 'insert page break'
Creating data series in Excel - Answer data series: A row or column of numbers that are
plotted in a chart is called a data series. You can plot one or more data series in a chart.
1. select range
2. insert tab, column symbol
3. select clustered column
Different kinds of functions in Excel (Statistical, Math & Trig, Logical, etc) - Answer
- Aggregate: calculate a result, which is an aggregate of the range
- Financial: calculate financial information, such as net present value and payments
- Statistical: apply a mathematical process to a group of cells in a worksheet
- Scientific: trigonometry, logarithms and functions that manipulate numbers
, - Logical: test the value of a cell and perform different operations on it depending on
the outcome
- Text: lets you manipulate character data, such as the names of customers,
street addresses and product descriptions
Working with ranges in Excel, selecting non-adjacent ranges - Answer non-adjacent:
hold Ctrl and select additional nonadjacent cell(s)
Formatting text (e.g. wrapping) and numbers (decimal points) in Excel. - Answer
wrap text: in alignment tab, select 'wrap text'
specify decimal points: format menu, click 'format cells', number tab, choose
number item in category list. Decimal place is in right part of window
Absolute and relative addressing - Answer Relative references change when a formula is
copied to another cell.
Absolute references remain constant no matter where they are copied.
Mathematical and Financial formulas (e.g. SUM, MAX, MIN, PMT, etc) -
Answer Mathematical formulas:
- SUM: adds up all values in the range
- AVERAGE: adds up all values in range and divides by number of values
- COUNT: adds up number of values in range
-MAX: finds largest value in range
-MIN: finds smallest value in range
Financial formulas:
- PMT: denotes the periodical payment required to pay off for a particular period of time
with a constant interest rate
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 KenAli. 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)
79271 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now