INSTRUCTIONS:
On the tabs of this excel you will nd a number of dierent tasks that require you to use your knowledge of Excel funcons to solve. This test is simly meant to give us an idea of what you know about Excel as it is o!en used in our line of work. "lease comlete as many tests tests as you can and solve solve them using the most eecve funcon. #n many situaons it would be ossible to comlete the task by manually tying. $O %OT use this method& as the test test is meant to gauge your your ability to use excel funcons.
%ame
$ate
'mount "aid
%ame (ane (uan 2ary (ohn
$ate
'mount "aid )*+*+,-+ 0*-1*+,,, +*-*+,,3*+3*+,--
/,.,, 0/.,, 1,.,, 0+.,,
'verage INSTRUCTIONS:
4se an excel funcon to average the above amounts.
%ame
$ate "aid
'mount
%ame 5ellington Texas #nstruments 7'E 8ockheed 2arn
Instrucons: 'ly a lter to this age so that only those amounts that are -,, or more are shown.
:tate
$ate "aid
'mount /*-)*+,-+ 6*-*+,-3 )*+,*+,-9*-/*+,-+
-/,.,, 0/.,, +,.,, -,,.,,
:tate ;irginia Texas %ew 2exico
:econd 5ord
=irst 5ord
:econd 5ord ilot driver fall
=irst 5ord >et car free
Examle? trailer
tractor
tractor trailer
%ame
$etecon
INSTRUCTIONS:
4se a formula to combine the above terms so that they form a hrase as in the examle?
%ame 'le 'ricot 'vocado 7anana 7readfruit 'le 7lackberry 7lackcurrant 7lueberry 7oysenberry
$etecon
INSTRUCTIONS:
4sing a single formula& detect all of the dulicates in the above list. #f the term has already aeared in the list& then your formula should dislay it on the same row& if the term has not already aeared on the list then your formula should dislay %*'.
%ame
"rice
%ame 'nise 7asil oram 'nise "arsley 7asil :age 'nise INSTRUCTIONS:
"rice ,./, ,.+/ -.,, +.,, +.+, +.,, ,.0/ ,.), ,.99 ,.66 ,.6,.)6 ,.91 ,.+/ -.,,
:um of "rice %ame Total 'nise -.97asil -.91 oram ,.66 "arsley ,.)6 :age ,.+/ @rand Total -6.39
ARM Loan Information
ARM Loan Information
Type of Loan: Home Value
FHA $210,527 UFMIP
Ente Loan Amount Hee: Tem "yea# *tat)n+ )ntee#t ate -uent ate afte f).e/ tem f)n
$200,000 Loan Amount ! UFMIP %0 7&' E(u)ty 27500' %%750'
E.ta -o#t E
$000
INSTRUCTIONS:
U#e an E.el fomula to e3 )f -2 ell )# a 4FHA4 Loan Ten e.eute te follo)n+ #tep#: In ell E% 6 If te 4Type of Loan4 FHA, mult)ply te alue )n -8 9y 00175, )f not etun 0 In ell E8 6 If te 4Type of Loan4 FHA, mult)ply te alue )n -8 9y 10175, )f )t )# not an FHA Loan, ten etun te alue )n -8 In ell E5 6 If te 4Type of Loan4 FHA, mult)ply te alue )n -% 9y 7&, )f not etun 0
Character Strings
Result
Character Strings
Result
3/)+603-1,A60/ 6)-+9,60A0036,/ )9,-0)3/A3/ /+,)/3-+6A990+
INSTRUCTIONS:
Examle of how it should look like a!er you aly your formula? 01/)9+A3+9 0/++3)A66
3+9 66
