Study Guides (380,000)
CA (150,000)
UW (6,000)
CS (400)
CS100 (40)
online (4)
Final

CS100 Final: Final+Review+Package+W2014+Solutions.pdf


Department
Computer Science
Course Code
CS100
Professor
online
Study Guide
Final

This preview shows pages 1-3. to view the full 23 pages of the document.
Review Package
Winter 2014
!
Overview
"#$%!&'($')!*+,-+.'!)+%!,/'+0'1!23!0#'!45!677!89%0/:,0$;9+<!5:==;/0!>%%$%0+90%?!80!
$%!2+%'1!;9!+<<!0#'!,;:/%'!@+0'/$+<A!%;@'!;B!)#$,#!3;:!@+3!#+('!%''9!;9!=/'($;:%!
+%%$.9@'90%?!C+-'!%:/'!0;!%0:13!0#'!@+0'/$+<!before!3;:!%0+/0!;9!0#$%!=+,-+.'?!><%;A!
2'!%:/'!0;!9;0'!0#+0!0#$%!=+,-+.'!$%!not$$90'91'1!0;!2'!+!%+@=<'!;/!=/+,0$,'!examA!
2:0!0;!%:==<'@'90!3;:/!;)9!%0:13$9.?!D'!%0/;9.<3!'9,;:/+.'!3;:!0;!0/3!0;!,;@=<'0'!
0#$%!=+,-+.'!)$0#;:0!+93!;:0%$1'!#'<=?!!E;;1!F:,-G!
!
Section 1: Excel
6? F$%0!0#'!=+/+@'0'/%!+91!=/;($1'!+!2/$'B!'H=<+9+0$;9!;B!0#'!B;<<;)$9.!
B:9,0$;9%?!
!
VLOOKUP$
5'+/,#'%!0#'!<'B0@;%0!,;<:@9!;B!+!0+2<'!B;/!+!(+<:'!0#+0!3;:!%=',$B3A!0#'9!/'0:/9%!+!
(+<:'!A!0+-'9!B/;@!0#'!,;<:@9!0#+0!3;:!%=',$B3!+91!!0#'!@+0,#$9.!/;)?!89!.'9'/+<A!
IFJJKL*!0+-'%!M!=+/+@'0'/%!+%!B;<<;)%N!
6O! 0#'!(+<:'!0;!@+0,#!$9!0#'!<;;-:=!0+2<'!P0#'!%'+/,#!-'3O!
QO! 0#'!0+2<'!0;!%'+/,#!B;/!+!@+0,#!P0#'!-'3!$%!@+0,#'1!+.+$9%0!0#'!<'B0@;%0!
,;<:@9O!
RO!0#'!,;<:@9!,;90+$9$9.!0#'!(+<:'!0;!2'!/'0:/9'1!P0#'!<'B0@;%0!,;<:@9!$%!
,;<:@9!6O!
MO!!!)#'0#'/!0#'!,<;%'%0!P<'%%!0#+9!;/!'S:+<O!@+0,#!$%!0;!2'!B;:91!P"&LTO!;/!+9!
'H+,0!@+0,#!$%!/'S:$/'1!!!!!!PU>F5TO!
!
!
INDIRECT$
8VW8&T4"!0+-'%!+!<+2'<!+%!$0%!;9<3!=+/+@'0'/!+91!0/'+0%!0#+0!<+2'<!+%!$B!$0!)'/'!+!,'<<!
+11/'%%A!,'<<!/+9.'A!;/!,'<<!9+@'?!80!/'0:/9%!0#'!,;90'90%!;B!0#'!,'<<!0#+0!#+%!0#+0!9+@'!
;/!+11/'%%?!
!

Only pages 1-3 are available for preview. Some parts have been intentionally blurred.

!
$
CONCATENATE$
U;/@%!;9'!<+2'<!23!=<+,$9.!'+,#!<+2'<!;/!(+<:'!B/;@!0#'!@'90$;9'1!,'<<%!+91!
,;9%0+90%!'91!0;!'91!$9!0#'!;/1'/!.$('9X!0#'!YZ[!;='/+0;/!=/;($1'%!+9!+<0'/9+0$('!
@',#+9$%@!B;/!,;9,+0'9+0$9.!<+2'<%?!
!
\4JV4>"TV>"TP%0/$9.6A%0/$9.Q??O!
\%0/$9.6!Z!%0/$9.Q!Z!]!
!
!
IF$
"#'!8U!B:9,0$;9!$%!:%'1!)#'9!3;:!)+90!0;!1$%=<+3!;/!,+<,:<+0'!+!<+2'<!;/!(+<:'!0#+0!$%!
,;91$0$;9+<!;9!$9B;/@+0$;9!%0;/'1!$9!0#'!%=/'+1%#''0?!
!
\8UP<;.$,+<!,;91$0$;9A!(+<:'!)#'9!0/:'A!(+<:'!)#'9!B+<%'O!
!
$
COUNTIF$
4;:90%!0#'!9:@2'/!;B!,'<<%!0#+0!@''0!0#'!.$('9!,/$0'/$;9!
!
\4JLV"8UP/+9.'A!,/$0'/$;9O!
!
/+9.'N!/+9.'!,;90+$9$9.!,'<<%!0;!2'!,;:90'1!
,/$0'/$;9N!<;.$,+<!,;91$0$;9!0;!2'!@'0!B;/!$9,<:1$9.!,'<<!$9!0#'!,;:90!
!
!
MID$
TH0/+,0%!+!%=',$B$,!9:@2'/!;B!,#+/+,0'/%!B/;@!+!<+2'<!%0+/0$9.!+0!0#'!=;%$0$;9!%=',$B$'1!
!
\C8WP0'H0A!%0+/0^9:@A!9:@^,#+/%O!
!
0'H0N!<+2'<!0#+0!3;:!)+90!0;!'H0/+,0!B/;@!
%0+/0^9:@N!%0+/0$9.!=;%$0$;9!
9:@^,#+/%N!9:@2'/!;B!,#+/+,0'/%!0;!2'!'H0/+,0'1!
!

Only pages 1-3 are available for preview. Some parts have been intentionally blurred.

Q? TH=<+$9!0#'!1$BB'/'9,'%!2'0)''9!+!/'<+0$('!,'<<!/'B'/'9,'!+91!+9!+2%;<:0'!,'<<!
/'B'/'9,'?!D#'9!+91!)#3!$%!$0!:%'B:<!0;!9+@'!=+/0$,:<+/!,'<<%!+91_;/!/+9.'%`!
!
&'<+0$('!/'B'/'9,'%!+1a:%0!)#'9!0#'3!+/'!,;=$'1!B/;@!;9'!,'<<!0;!+9;0#'/!;/!%=/'+1!
+<;9.!+!/;)!;/!,;<:@9?!>2%;<:0'!/'B'/'9,'%!P$91$,+0'1!23!b!;/!9+@'1!/'B'/'9,'%O!)$<<!
9;0!,#+9.'!)#'9!0#'3!+/'!,;=$'1!;/!%=/'+1?!80!$%!:%'B:<!0;!9+@'!,'<<%!;/!,'<<!/+9.'%!0;!
@+-'!$0!'+%$'/!B;/!:%'/%!;B!3;:/!%=/'+1%#''0!0;!:91'/%0+91!+91!<'%%!=/;9'!0;!'//;/?!c3!
1'B+:<0A!+!9+@'1!/'B'/'9,'!$%!+2%;<:0'!+91!0#'/'B;/'!)$<<!9;0!,#+9.'!$0%!@'+9$9.!
)#'9!$0!$%!,;=$'1!;/!%=/'+1?!
!
R? FEDS$Swag$Sale$
The+Federation+of+Student%!PUTW5O!$%!#+($9.!+!5)+.!5+<'!)#'/'!%0:1'90%!,+9!
=:/,#+%'!(+/$;:%!$0'@%!;B!,<;0#$9.!0;!%#;)!0#'$/!%,#;;<!%=$/$0?!";!#'<=!-''=!
0/+,-!;B!0#'$/!;/1'/%!+91!%+<'%A!UTW5!:%'%!+9!'<',0/;9$,!%=/'+1%#''0?!!
!
"#'!(+/$;:%!,<;0#$9.!03='%!;9!%+<'!+/'N!d;;1$'%A!4+/1$.+9%!+91!"e%#$/0%?!
50:1'90%!,+9!2:3!+<<!0#/''!$0'@%!B;/!+!/'1:,'1!=/$,'!Pd4"!4;@2;O?!50:1'90%!
)#;!=:/,#+%'!0#'$/!Y%)+.[!2'B;/'!6feg+9eQ76R!=+3!+9!YT+/<3!c$/1!*/$,'[?!89!
+11$0$;9!0;!0#$%A!%0:1'90%!)#;!(;<:90''/!)$0#!+!UTW5!%'/($,'!.'0!bh!;BB!
/'.+/1<'%%!;B!)#+0!0#'3!2:3!+91!0#'!1+0'!;B!0#'$/!=:/,#+%'?!!
!
UTW5!;BB'/%!+!B/''!=+$/!;B!C+<$2:!%:9.<+%%'%!B;/!'('/3!=:/,#+%'!;B!+!d4"!
4;@2;?!
!
UTW5!:%'%!+!a:%0e$9e0$@'!$9('90;/3!%3%0'@!$9!)#$,#!0#'3!=<+,'!;/1'/%!B;/!
0#'$/!%)+.!$0'@%!+%!%;;9!+%!0#'3!+/'!=:/,#+%'1?!"#'!$0'@%!+/'!0#'9!@+1'!
+(+$<+2<'!B;/!%0:1'90%!0;!=$,-!:=!;9,'!0#'3!+//$('?!"+-'!+!B')!@;@'90%!0;!
%0:13!0#'!%=/'+1%#''0!%,/''9%#;0!;9!0#'!B;<<;)$9.!=+.'A!+91!+9%)'/!0#'!
S:'%0$;9%!0#+0!B;<<;)?!!
!
! !
You're Reading a Preview

Unlock to view full version