ALI BAGHERI MSIS 3223 EXAM 1
QUESTIONS 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