Exam (elaborations)
Ali Bagheri MSIS 3223 Exam 1 WITH 100- SURE ANSWERS
- Course
- Institution
Ali Bagheri MSIS 3223 Exam 1 WITH 100- SURE ANSWERS
[Show more]
Seller
Follow
Content preview
Ali Bagheri MSIS 3223 Exam 1 WITH 100% SURE ANSWERSEUNICE
Terms in this set (124)
-addition (+)
-subtraction (-)
• Common mathematical operators are used -multiplication (*)
-division (/)
-exponentiation (^)
Relative references A2, C5, D10
Absolute references $A$2, $C5, D$10
Using a $ sign before a row label (for
example, B$4) keeps the reference fixed to
row 4 but allows the column reference to
change if the formula is copied to another
cell.
Using a $ sign before a column label (for
example, $B4) keeps the reference to
column B fixed but allows the row
reference to change
Using a $ sign before both the row and
column labels (for example, $B$4) keeps
the reference to cell B4 fixed no matter
where the formula is copied.
SUM IF, AVERAGE IF, SUM IFS, and can be used to embed IF logic within mathematical functions.
AVERAGE IFS
SUMIF Sum range an optional argument that allows you to add cells in a different range.
Net Present Value (or discounted cash measures the worth of a stream of cash flows, taking into account the time value of
flow) money.
is a descriptive label assigned to a cell or range of cells. There are several ways to
create range names in Excel
range name -Name box
-Create from Selection
-Define Name
• Copy the range of cells of interest and click on the cell where you want to paste the
results. Examples:
Paste Special
-To paste only the values in cells (not the formulas), select Values and then click OK.
-To transpose data in columns to rows and vice versa, use Transpose.
1/9
, • To concatenate means to join. In many applications, you might wish to take text data
that are in different columns and join them together (for example, first and last
names). The Excel function CONCATENATE(text1, text2, . . . , text30) can be used to
Concatenation
join up to 30 text strings into a single string.
-Suppose that cell A1 contains the last name Smith, and cell B1 contains the first name
John. Then CONCATENATE(B1, " ", A1) will result in the text string John Smith.
• #DIV/0!—A formula is trying to divide by zero.
• #N/A—"Not available," meaning that the formula could not return a result.
• #NAME?—An invalid name is used in a formula.
Error Values • #NUM!—An invalid argument is used in a function, such as a negative number in
SQRT.
• #REF!—A formula contains an invalid cell reference.
• #VALUE!—Excel cannot compute a function because of an invalid argument.
• IFERROR(value, value_if_error) displays a specific value if an error is present.
• For example, if you are computing A1/B1, then if B1 is zero or blank, then
IFERROR Function
= IFERROR(A1/B1, " ")
will display a blank cell instead of #DIV/0!;
are providing benefits to businesses from the beginning of a startup, facilitating
Data analytics
expansive growth, and exploding them into large, formidable companies.
is s the use of:•data,
• information technology,
• statistical analysis,
Business Analytics
• quantitative methods, and
• mathematical or computer-based models to help managers gain improved insight
about their business operations and make better, fact-based decisions.
setting prices for consumer and industrial goods, government contracts, and
Pricing
maintenance contracts
identifying and targeting key customer groups in retail, insurance, and credit card
Customer segmentation
industries
Merchandising determining brands to buy, quantities, and allocations
finding the best location for bank branches and ATMs, or where to service industrial
Location
equipment
determining the best sourcing and transportation options and finding the best
Supply Chain Design
delivery routes
Staffing ensuring appropriate staffing levels and capabilities, and hiring the right people
scheduling operating rooms to improve utilization, improving patient flow and
Health care
waiting times, purchasing supplies, and predicting health risk factors
reduced costs, better risk management, faster decisions, better productivity and
Benefits
enhanced bottom-line performance such as profitability and customer satisfaction.
lack of understanding of how to use analytics, competing business priorities,
Challenges insufficient analytical skills, difficulty in getting good data and sharing information,
and not understanding the benefits versus perceived costs of analytics studies.
-IBM Cognos Express
Commercial software -SAS Analytics
-Tableau
2/9
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 mbitheeunice2015. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
81311 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now