Excel-Business Modeling Terms And
Answers
ABSt-tCORRECTttANSWER-absolutetvalue
ad-hoctwayt-tCORRECTttANSWER-Changetatcelltheretandtseetthetresult
Changetanothertcellttheretandtseetthetresult
Changetseveraltcellsttogethertandtseetthetresult
ANDt-tCORRECTttANSWER-checkstiftalltargumentstarettrue
areatchartt-tCORRECTttANSWER-
liketatlinetchart,tbuttdisplaystdifferenttcolourstintthetareastbelowtthetlines
automatictupdatingt-tCORRECTttANSWER-
Iftyoutgotandtchangetatparticulartcelltvalue,talltothertformulastbasedtontthattcelltwilltbetautom
aticallytrecalculatedtandtdisplayed
bartchartt-tCORRECTttANSWER-displaytdatatusingtat"horizontal"tbartgraph
cellt-tCORRECTttANSWER-cantholdtnumber,tpiecetofttext,tortatformula
columnt-tCORRECTttANSWER-horizontaltletterstintexcel
columntchartt-tCORRECTttANSWER-displaytdatatusingtat"vertical"tbartgraph
CONCATENATEt-tCORRECTttANSWER-formtcomplexttexttstrings
COUNTIFt-tCORRECTttANSWER-conditionaltcounting
Ctrl+ct-tCORRECTttANSWER-totcopy
Ctrl+vt-tCORRECTttANSWER-totpaste
Ctrl+xt-tCORRECTttANSWER-totcut
DatatTabt-tCORRECTttANSWER-sorting/filteringtandtanalysisttools
DatatTablet-tCORRECTttANSWER-
Giventatformulatthattusestonetorttwotvariables,tproducestattabletfortseeingthowtthetresulttoftt
hetformulatchangestwithtchangesttotthetvariable(s)
databaset-tCORRECTttANSWER-antorganizedtcollectiontoftdata
Answers
ABSt-tCORRECTttANSWER-absolutetvalue
ad-hoctwayt-tCORRECTttANSWER-Changetatcelltheretandtseetthetresult
Changetanothertcellttheretandtseetthetresult
Changetseveraltcellsttogethertandtseetthetresult
ANDt-tCORRECTttANSWER-checkstiftalltargumentstarettrue
areatchartt-tCORRECTttANSWER-
liketatlinetchart,tbuttdisplaystdifferenttcolourstintthetareastbelowtthetlines
automatictupdatingt-tCORRECTttANSWER-
Iftyoutgotandtchangetatparticulartcelltvalue,talltothertformulastbasedtontthattcelltwilltbetautom
aticallytrecalculatedtandtdisplayed
bartchartt-tCORRECTttANSWER-displaytdatatusingtat"horizontal"tbartgraph
cellt-tCORRECTttANSWER-cantholdtnumber,tpiecetofttext,tortatformula
columnt-tCORRECTttANSWER-horizontaltletterstintexcel
columntchartt-tCORRECTttANSWER-displaytdatatusingtat"vertical"tbartgraph
CONCATENATEt-tCORRECTttANSWER-formtcomplexttexttstrings
COUNTIFt-tCORRECTttANSWER-conditionaltcounting
Ctrl+ct-tCORRECTttANSWER-totcopy
Ctrl+vt-tCORRECTttANSWER-totpaste
Ctrl+xt-tCORRECTttANSWER-totcut
DatatTabt-tCORRECTttANSWER-sorting/filteringtandtanalysisttools
DatatTablet-tCORRECTttANSWER-
Giventatformulatthattusestonetorttwotvariables,tproducestattabletfortseeingthowtthetresulttoftt
hetformulatchangestwithtchangesttotthetvariable(s)
databaset-tCORRECTttANSWER-antorganizedtcollectiontoftdata