Exam (elaborations)
ALI BAGHERI MSIS 3223 EXAM 1 QUESTIONS WITH CORRECT ANSWERS.
- Course
- Institution
ALI BAGHERI MSIS 3223 EXAM 1 QUESTIONS WITH CORRECT ANSWERS.
[Show more]
Content preview
ALI BAGHERI MSIS 3223 EXAM 1QUESTIONS WITH CORRECT ANSWERS
•Common aamathematical aaoperators aaare aaused aa- aaAnswer aa-addition aa(+)
-subtraction aa(-)
-multiplication aa(*)
-division aa(/)
-exponentiation aa(^)
Relative aareferences aa- aaAnswer aaA2, aaC5, aaD10
Absolute aareferences aa- aaAnswer aa$A$2, aa$C5, aaD$10
Using aaa aa$ aasign aabefore aaa aarow aalabel aa(for aaexample, aaB$4) aakeeps aathe
aareference aafixed aato aarow aa4 aabut aaallows aathe aacolumn aareference aato aachange aaif
aathe aaformula aais aacopied aato aaanother aacell. aa- aaAnswer aa
Using aaa aa$ aasign aabefore aaa aacolumn aalabel aa(for aaexample, aa$B4) aakeeps aathe
aareference aato aacolumn aaB aafixed aabut aaallows aathe aarow aareference aato aachange aa-
aaAnswer aa
Using aaa aa$ aasign aabefore aaboth aathe aarow aaand aacolumn aalabels aa(for aaexample,
aa$B$4) aakeeps aathe aareference aato aacell aaB4 aafixed aano aamatter aawhere aathe
aaformula aais aacopied. aa- aaAnswer aa
SUM aaIF, aaAVERAGE aaIF, aaSUM aaIFS, aaand aaAVERAGE aaIFS aa- aaAnswer aacan
aabe aaused aato aaembed aaIF aalogic aawithin aamathematical aafunctions.
SUMIF aaSum aarange aa- aaAnswer aaan aaoptional aaargument aathat aaallows aayou aato
aaadd aacells aain aaa aadifferent aarange.
Net aaPresent aaValue aa(or aadiscounted aacash aaflow) aa- aaAnswer aameasures aathe
aaworth aaof aaa aastream aaof aacash aaflows, aataking aainto aaaccount aathe aatime aavalue
aaof aamoney.
range aaname aa- aaAnswer aais aaa aadescriptive aalabel aaassigned aato aaa aacell aaor
aarange aaof aacells. aaThere aaare aaseveral aaways aato aacreate aarange aanames aain
aaExcel
-Name aabox
,-Create aafrom aaSelection
-Define aaName
Paste aaSpecial aa- aaAnswer aa•Copy aathe aarange aaof aacells aaof aainterest aaand aaclick
aaon aathe aacell aawhere aayou aawant aato aapaste aathe aaresults. aaExamples:
-To aapaste aaonly aathe aavalues aain aacells aa(not aathe aaformulas), aaselect aaValues aaand
aathen aaclick aaOK.
-To aatranspose aadata aain aacolumns aato aarows aaand aavice aaversa, aause aaTranspose.
Concatenation aa- aaAnswer aa•To aaconcatenate aameans aato aajoin. aaIn aamany
aaapplications, aayou aamight aawish aato aatake aatext aadata aathat aaare aain aadifferent
aacolumns aaand aajoin aathem aatogether aa(for aaexample, aafirst aaand aalast aanames).
aaThe aaExcel aafunction aaCONCATENATE(text1, aatext2, aa. aa. aa. aa, aatext30) aacan aabe
aaused aato aajoin aaup aato aa30 aatext aastrings aainto aaa aasingle aastring.
-Suppose aathat aacell aaA1 aacontains aathe aalast aaname aaSmith, aaand aacell aaB1
aacontains aathe aafirst aaname aaJohn. aaThen aaCONCATENATE(B1, aa" aa", aaA1) aawill
aaresult aain aathe aatext aastring aaJohn aaSmith.
Error aaValues aa- aaAnswer aa•#DIV/0!—A aaformula aais aatrying aato aadivide aaby aazero.
•#N/A—"Not aaavailable," aameaning aathat aathe aaformula aacould aanot aareturn aaa
aaresult.
•#NAME?—An aainvalid aaname aais aaused aain aaa aaformula.
•#NUM!—An aainvalid aaargument aais aaused aain aaa aafunction, aasuch aaas aaa aanegative
aanumber aain aaSQRT.
•#REF!—A aaformula aacontains aaan aainvalid aacell aareference.
•#VALUE!—Excel aacannot aacompute aaa aafunction aabecause aaof aaan aainvalid
aaargument.
IFERROR aaFunction aa- aaAnswer aa•IFERROR(value, aavalue_if_error) aadisplays aaa
aaspecific aavalue aaif aaan aaerror aais aapresent.
•For aaexample, aaif aayou aaare aacomputing aaA1/B1, aathen aaif aaB1 aais aazero aaor
aablank, aathen
= aaIFERROR(A1/B1, aa" aa")
will aadisplay aaa aablank aacell aainstead aaof aa#DIV/0!;
Data aaanalytics aa- aaAnswer aaare aaproviding aabenefits aato aabusinesses aafrom aathe
aabeginning aaof aaa aastartup, aafacilitating aaexpansive aagrowth, aaand aaexploding aathem
aainto aalarge, aaformidable aacompanies.
Business aaAnalytics aa- aaAnswer aais aas aathe aause aaof:•data,
•information aatechnology,
•statistical aaanalysis,
•quantitative aamethods, aaand
•mathematical aaor aacomputer-based aamodels aato aahelp aamanagers aagain aaimproved
aainsight aaabout aatheir aabusiness aaoperations aaand aamake aabetter, aafact-based
aadecisions.
, Pricing aa- aaAnswer aasetting aaprices aafor aaconsumer aaand aaindustrial aagoods,
aagovernment aacontracts, aaand aamaintenance aacontracts
Customer aasegmentation aa- aaAnswer aaidentifying aaand aatargeting aakey aacustomer
aagroups aain aaretail, aainsurance, aaand aacredit aacard aaindustries
Merchandising aa- aaAnswer aadetermining aabrands aato aabuy, aaquantities, aaand
aaallocations
Location aa- aaAnswer aafinding aathe aabest aalocation aafor aabank aabranches aaand
aaATMs, aaor aawhere aato aaservice aaindustrial aaequipment
Supply aaChain aaDesign aa- aaAnswer aadetermining aathe aabest aasourcing aaand
aatransportation aaoptions aaand aafinding aathe aabest aadelivery aaroutes
Staffing aa- aaAnswer aaensuring aaappropriate aastaffing aalevels aaand aacapabilities, aaand
aahiring aathe aaright aapeople
Health aacare aa- aaAnswer aascheduling aaoperating aarooms aato aaimprove aautilization,
aaimproving aapatient aaflow aaand aawaiting aatimes, aapurchasing aasupplies, aaand
aapredicting aahealth aarisk aafactors
Benefits aa- aaAnswer aareduced aacosts, aabetter aarisk aamanagement, aafaster
aadecisions, aabetter aaproductivity aaand aaenhanced aabottom-line aaperformance aasuch
aaas aaprofitability aaand aacustomer aasatisfaction.
Challenges aa- aaAnswer aalack aaof aaunderstanding aaof aahow aato aause aaanalytics,
aacompeting aabusiness aapriorities, aainsufficient aaanalytical aaskills, aadifficulty aain
aagetting aagood aadata aaand aasharing aainformation, aaand aanot aaunderstanding aathe
aabenefits aaversus aaperceived aacosts aaof aaanalytics aastudies.
Commercial aasoftware aa- aaAnswer aa-IBM aaCognos aaExpress
-SAS aaAnalytics
-Tableau
Spreadsheets aa- aaAnswer aa-Widely aaused
-Effective aafor aamanipulating aadata aaand aadeveloping aaand aasolving aamodels
-Support aapowerful aacommercial aaadd-ons
-Facilitate aacommunication aaof aaresults
Descriptive aaanalytics aa- aaAnswer aathe aause aaof aadata aato aaunderstand aapast aaand
aacurrent aabusiness aaperformance aaand aamake aainformed aadecisions
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 LucieLucky. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.49. 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