<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv=Content-Type content="text/html; charset=unicode"> <meta name=ProgId content=Word.Document> <meta name=Generator content="Microsoft Word 12"> <meta name=Originator content="Microsoft Word 12"> <link rel=File-List href="cis100EX1-f11_files/filelist.xml"> <title>CIS 100 -- Excel Assignment 1</title> <!--[if gte mso 9]><xml> <o:DocumentProperties> <o:Author>computer science</o:Author> <o:LastAuthor>computer science</o:LastAuthor> <o:Revision>2</o:Revision> <o:TotalTime>6</o:TotalTime> <o:Created>2010-09-02T18:16:00Z</o:Created> <o:LastSaved>2010-09-02T18:22:00Z</o:LastSaved> <o:Pages>1</o:Pages> <o:Words>902</o:Words> <o:Characters>4197</o:Characters> <o:Company>Spelman College</o:Company> <o:Lines>34</o:Lines> <o:Paragraphs>10</o:Paragraphs> <o:CharactersWithSpaces>5089</o:CharactersWithSpaces> <o:Version>12.00</o:Version> </o:DocumentProperties> </xml><![endif]--> <link rel=themeData href="cis100EX1-f11_files/themedata.thmx"> <link rel=colorSchemeMapping href="cis100EX1-f11_files/colorschememapping.xml"> <!--[if gte mso 9]><xml> <w:WordDocument> <w:Zoom>BestFit</w:Zoom> <w:SpellingState>Clean</w:SpellingState> <w:GrammarState>Clean</w:GrammarState> <w:TrackMoves/> <w:TrackFormatting/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:DontVertAlignCellWithSp/> <w:DontBreakConstrainedForcedTables/> <w:DontVertAlignInTxbx/> <w:Word11KerningPairs/> <w:CachedColBalance/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="&#45;-"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true" DefSemiHidden="true" DefQFormat="false" DefPriority="99" LatentStyleCount="267"> <w:LsdException Locked="false" Priority="0" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" Name="toc 9"/> <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/> <w:LsdException Locked="false" Priority="10" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" Priority="11" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" Priority="22" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="59" SemiHidden="false" UnhideWhenUsed="false" Name="Table Grid"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/> <w:LsdException Locked="false" Priority="34" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--> <style> <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-1610611985 1107304683 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast;} h1 {mso-style-priority:9; mso-style-unhide:no; mso-style-qformat:yes; mso-style-link:"Heading 1 Char"; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; page-break-after:avoid; mso-outline-level:1; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; font-weight:bold;} h2 {mso-style-noshow:yes; mso-style-priority:9; mso-style-qformat:yes; mso-style-link:"Heading 2 Char"; mso-style-next:Normal; margin-top:10.0pt; margin-right:0in; margin-bottom:0in; margin-left:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan lines-together; page-break-after:avoid; mso-outline-level:2; font-size:13.0pt; font-family:"Cambria","serif"; mso-ascii-font-family:Cambria; mso-ascii-theme-font:major-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:major-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:major-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:major-bidi; color:#4F81BD; mso-themecolor:accent1; font-weight:bold;} p {mso-style-priority:99; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast;} span.Heading1Char {mso-style-name:"Heading 1 Char"; mso-style-priority:9; mso-style-unhide:no; mso-style-locked:yes; mso-style-link:"Heading 1"; mso-ansi-font-size:14.0pt; mso-bidi-font-size:14.0pt; font-family:"Cambria","serif"; mso-ascii-font-family:Cambria; mso-ascii-theme-font:major-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:major-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:major-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:major-bidi; color:#365F91; mso-themecolor:accent1; mso-themeshade:191; font-weight:bold;} p.h1, li.h1, div.h1 {mso-style-name:h1; mso-style-unhide:no; margin-top:5.0pt; margin-right:0in; margin-bottom:5.0pt; margin-left:0in; mso-pagination:widow-orphan; page-break-after:avoid; layout-grid-mode:char; font-size:24.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; font-weight:bold;} p.h2, li.h2, div.h2 {mso-style-name:h2; mso-style-unhide:no; margin-top:5.0pt; margin-right:0in; margin-bottom:5.0pt; margin-left:0in; mso-pagination:widow-orphan; page-break-after:avoid; layout-grid-mode:char; font-size:18.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; font-weight:bold;} p.style1, li.style1, div.style1 {mso-style-name:style1; mso-style-unhide:no; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; text-align:center; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast;} span.Heading2Char {mso-style-name:"Heading 2 Char"; mso-style-noshow:yes; mso-style-priority:9; mso-style-unhide:no; mso-style-locked:yes; mso-style-link:"Heading 2"; mso-ansi-font-size:13.0pt; mso-bidi-font-size:13.0pt; font-family:"Cambria","serif"; mso-ascii-font-family:Cambria; mso-ascii-theme-font:major-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:major-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:major-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:major-bidi; color:#4F81BD; mso-themecolor:accent1; font-weight:bold;} span.SpellE {mso-style-name:""; mso-spl-e:yes;} span.GramE {mso-style-name:""; mso-gram-e:yes;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-size:10.0pt; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} /* List Definitions */ @list l0 {mso-list-id:91585256; mso-list-template-ids:-229065624;} @list l0:level1 {mso-level-number-format:bullet; mso-level-text:·ð; mso-level-tab-stop:.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Symbol;} @list l1 {mso-list-id:500047580; mso-list-template-ids:699200840;} @list l1:level1 {mso-level-number-format:bullet; mso-level-text:·ð; mso-level-tab-stop:.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Symbol;} @list l2 {mso-list-id:644359622; mso-list-template-ids:-977134698;} @list l2:level1 {mso-level-number-format:bullet; mso-level-text:·ð; mso-level-tab-stop:.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Symbol;} @list l2:level2 {mso-level-number-format:bullet; mso-level-text:·ð; mso-level-tab-stop:1.0in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Symbol;} @list l3 {mso-list-id:667026283; mso-list-template-ids:-1656820432;} @list l3:level1 {mso-level-number-format:bullet; mso-level-text:·ð; mso-level-tab-stop:.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Symbol;} @list l4 {mso-list-id:1179462256; mso-list-template-ids:-2141403382;} @list l4:level1 {mso-level-number-format:bullet; mso-level-text:·ð; mso-level-tab-stop:.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Symbol;} ol {margin-bottom:0in;} ul {margin-bottom:0in;} --> </style> <!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman","serif";} </style> <![endif]--> <meta http-equiv=Content-Language content=en-us> <!--[if gte mso 9]><xml> <o:shapedefaults v:ext="edit" spidmax="1026"/> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext="edit"> <o:idmap v:ext="edit" data="1"/> </o:shapelayout></xml><![endif]--> </head> <body lang=EN-US style='tab-interval:.5in'> <div class=Section1> <p class=h1 align=center style='text-align:center'>CIS 100 -- Excel Assignment 1</p> <p class=h2>Overview </p> <p class=MsoNormal>This first Excel assignment is based partially on your lab just to get you started. You are to prepare two tables.<span style='mso-spacerun:yes'>  </span>Each table will reside on a separate worksheet, so you are only going to need one Excel file. </p> <p class=MsoNormal><o:p>&nbsp;</o:p></p> <p class=MsoNormal>The first table is similar to the credit-card information table that we prepared in lab. If you recall, the table showed how much credit-card debt you might acquire during college (the final balance was $2729.89). In this assignment, we are going to pay it off. Change the interest rate to 14 percent. Make the starting balance $2729.89. Use the same column headings as in the lab table and continue the table to the months after you graduate. Assuming you charge $300 per month and you pay $400 per month, add rows to the table until you have paid off your debt (that is, until the balance is between zero and 100 dollars). In this scenario, we assumed that you diligently paid $400 per month on your credit card until the balance was almost paid off.<span style='mso-spacerun:yes'>  </span>Most credit cards, however, suggest minimum monthly payments that are well below $400 per month.<span style='mso-spacerun:yes'>  </span>Let us assume that the criterion for calculating the minimum monthly payment on this credit card is 2% of your balance or $10.00 whichever is higher.<span style='mso-spacerun:yes'>  </span>Add another column to the table that will show the minimum monthly payment. (<span class=GramE><span class=grame>hint</span></span>: use the Max function)</p> <p class=MsoNormal style='margin-left:.25in'><o:p>&nbsp;</o:p></p> <h1><span style='mso-fareast-font-family:"Times New Roman"'>To Do<o:p></o:p></span></h1> <ul style='margin-top:0in' type=disc> <li class=MsoNormal style='mso-list:l1 level1 lfo1;tab-stops:list .5in'><span style='mso-fareast-font-family:"Times New Roman"'>Select the first worksheet and rename it to  <span class=SpellE>CreditCard</span> <o:p></o:p></span></li> <li class=MsoNormal style='mso-list:l1 level1 lfo1;tab-stops:list .5in'><span style='mso-fareast-font-family:"Times New Roman"'>Put your name in cell A1. <o:p></o:p></span></li> <li class=MsoNormal style='mso-list:l1 level1 lfo1;tab-stops:list .5in'><span style='mso-fareast-font-family:"Times New Roman"'>Make a credit-card table on the first worksheet as described. . <o:p></o:p></span></li> <li class=MsoNormal style='mso-list:l1 level1 lfo1;tab-stops:list .5in'><span style='mso-fareast-font-family:"Times New Roman"'>Have the interest rate of 14 percent as a separate labeled cell. <o:p></o:p></span></li> <li class=MsoNormal style='mso-list:l1 level1 lfo1;tab-stops:list .5in'><span style='mso-fareast-font-family:"Times New Roman"'>Have the minimum payment percent of 2 percent as a separate labeled cell. <o:p></o:p></span></li> <li class=MsoNormal style='mso-list:l1 level1 lfo1;tab-stops:list .5in'><span style='mso-fareast-font-family:"Times New Roman"'>The table should have the following columns: <o:p></o:p></span></li> </ul> <div align=center> <table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 style='border-collapse:collapse;mso-yfti-tbllook:1184;mso-padding-alt:0in 2.25pt 0in 2.25pt'> <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes'> <td width=26 style='width:19.2pt;border:solid windowtext 1.0pt;mso-border-alt: solid windowtext .75pt;padding:0in 2.25pt 0in 2.25pt'> <p class=MsoNormal align=center style='text-align:center'>Payment Number</p> </td> <td width=64 style='width:48.0pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .75pt;mso-border-alt:solid windowtext .75pt; padding:0in 2.25pt 0in 2.25pt'> <p class=MsoNormal align=center style='text-align:center'>Month</p> </td> <td width=38 style='width:.4in;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .75pt;mso-border-alt:solid windowtext .75pt; padding:0in 2.25pt 0in 2.25pt'> <p class=MsoNormal align=center style='text-align:center'>Old Balance</p> </td> <td width=63 style='width:47.25pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .75pt;mso-border-alt:solid windowtext .75pt; padding:0in 2.25pt 0in 2.25pt'> <p class=MsoNormal align=center style='text-align:center'>Interest Charged</p> </td> <td width=72 style='width:.75in;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .75pt;mso-border-alt:solid windowtext .75pt; padding:0in 2.25pt 0in 2.25pt'> <p class=MsoNormal align=center style='text-align:center'>Charges</p> </td> <td width=72 style='width:.75in;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .75pt;mso-border-alt:solid windowtext .75pt; padding:0in 2.25pt 0in 2.25pt'> <p class=MsoNormal align=center style='text-align:center'>Amount Paid</p> </td> <td width=60 valign=top style='width:45.0pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .75pt;mso-border-alt: solid windowtext .75pt;padding:0in 2.25pt 0in 2.25pt'> <p class=MsoNormal align=center style='text-align:center'>New Balance</p> </td> <td width=72 style='width:.75in;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .75pt;mso-border-alt:solid windowtext .75pt; padding:0in 2.25pt 0in 2.25pt'> <p class=MsoNormal align=center style='text-align:center'>Minimum Payment</p> </td> </tr> </table> </div> <p class=MsoNormal align=center style='text-align:center'>All entries in columns ``old,'' ``interest  , ``new'', and ``<span class=SpellE>minPymt</span> must be formulas. </p> <ul style='margin-top:0in' type=disc> <li class=MsoNormal style='mso-list:l3 level1 lfo2;tab-stops:list .5in'><span style='mso-fareast-font-family:"Times New Roman"'>Use formulas to add up the ``charges'' and ``paid'' columns. <o:p></o:p></span></li> </ul> <p class=MsoNormal style='margin-left:.25in'><o:p>&nbsp;</o:p></p> <p class=MsoNormal>The second table is similar to the bank account table that we did in lab. We want to compare two people's investment strategies after graduating. Britney decides that, even though it will be difficult on her budget, she'll invest $1,200 a year ($100 a month) in a stock mutual fund. She hopes that starting early will allow her to retire early. After 10 years, though, she decides that, with her kids in school and such, she can no longer afford it, and she stops investing money.</p> <p class=MsoNormal>&nbsp;Meanwhile, <span class=SpellE>Jazmine</span> doesn't invest any money when she graduates, reasoning that she can't afford it right away, but she'll be able to afford it later. After 10 years, she decides that she can't put it off any longer, so she starts investing $1,200 a year in the same mutual fund as Britney. Let's assume that the mutual fund earns an average return of 4 percent per year (earnings are like interest, but called something different). Start the table when both women are 22, and stop when they are both 62. </p> <p class=MsoNormal><o:p>&nbsp;</o:p></p> <p class=MsoNormal><b style='mso-bidi-font-weight:normal'><span style='font-size:12.0pt;mso-bidi-font-size:10.0pt'>To Do<o:p></o:p></span></b></p> <p class=MsoNormal><o:p>&nbsp;</o:p></p> <ul style='margin-top:0in' type=disc> <li class=MsoNormal style='mso-list:l0 level1 lfo3;tab-stops:list .5in'><span style='mso-fareast-font-family:"Times New Roman"'>Select the second worksheet and rename it to Investments <o:p></o:p></span></li> <li class=MsoNormal style='mso-list:l0 level1 lfo3;tab-stops:list .5in'><span style='mso-fareast-font-family:"Times New Roman"'>Put your name in cell A1. <o:p></o:p></span></li> <li class=MsoNormal style='mso-list:l0 level1 lfo3;tab-stops:list .5in'><span style='mso-fareast-font-family:"Times New Roman"'>Make an investment table on the second worksheet as described. <o:p></o:p></span></li> <li class=MsoNormal style='mso-list:l0 level1 lfo3;tab-stops:list .5in'><span style='mso-fareast-font-family:"Times New Roman"'>Have the average earnings rate of 4% as a separate labeled cell. <o:p></o:p></span></li> <li class=MsoNormal style='mso-list:l0 level1 lfo3;tab-stops:list .5in'><span style='mso-fareast-font-family:"Times New Roman"'>Have the contributions (investment amount) as a separate labeled cell. <o:p></o:p></span></li> <li class=MsoNormal style='mso-list:l0 level1 lfo3;tab-stops:list .5in'><span style='mso-fareast-font-family:"Times New Roman"'>The table should have the following columns (these are abbreviated so they will fit; you should spell things out): <o:p></o:p></span></li> </ul> <div align=center> <table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 style='border-collapse:collapse;mso-yfti-tbllook:1184;mso-padding-alt:0in 2.25pt 0in 2.25pt'> <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes'> <td width=38 style='width:.4in;border:solid windowtext 1.0pt;mso-border-alt: solid windowtext .75pt;padding:0in 2.25pt 0in 2.25pt'> <p class=MsoNormal>Age</p> </td> <td width=38 style='width:.4in;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .75pt;mso-border-alt:solid windowtext .75pt; padding:0in 2.25pt 0in 2.25pt'> <p class=MsoNormal>Balance</p> </td> <td width=51 style='width:38.4pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .75pt;mso-border-alt:solid windowtext .75pt; padding:0in 2.25pt 0in 2.25pt'> <p class=MsoNormal align=right style='text-align:right'>Earnings</p> </td> <td width=90 style='width:67.2pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .75pt;mso-border-alt:solid windowtext .75pt; padding:0in 2.25pt 0in 2.25pt'> <p class=MsoNormal align=right style='text-align:right'>Contributions</p> </td> <td width=38 style='width:.4in;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .75pt;mso-border-alt:solid windowtext .75pt; padding:0in 2.25pt 0in 2.25pt'> <p class=MsoNormal align=right style='text-align:right'>Balance</p> </td> <td width=51 style='width:38.4pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .75pt;mso-border-alt:solid windowtext .75pt; padding:0in 2.25pt 0in 2.25pt'> <p class=MsoNormal align=right style='text-align:right'>Earnings</p> </td> <td width=90 valign=top style='width:67.2pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .75pt;mso-border-alt: solid windowtext .75pt;padding:0in 2.25pt 0in 2.25pt'> <p class=MsoNormal align=right style='text-align:right'>Contributions</p> </td> <td width=90 style='width:67.2pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .75pt;mso-border-alt:solid windowtext .75pt; padding:0in 2.25pt 0in 2.25pt'> <p class=MsoNormal align=right style='text-align:right'>Caught up?</p> </td> </tr> </table> </div> <p class=MsoNormal align=center style='margin-left:.5in;text-align:center'>The columns on the left are for Britney; the columns on the right are for <span class=SpellE>Jazmine</span>. </p> <ul style='margin-top:0in' type=disc> <li class=MsoNormal style='mso-list:l4 level1 lfo4;tab-stops:list .5in'><span style='mso-fareast-font-family:"Times New Roman"'>All entries in the ``earnings'' column must be formulas. All entries in the ``balance'' column must be formulas except the first, which is zero. The contribution columns should refer to the labeled cell. <o:p></o:p></span></li> <li class=MsoNormal style='mso-list:l4 level1 lfo4;tab-stops:list .5in'><span style='mso-fareast-font-family:"Times New Roman"'>Compute the total contributions for each person using a formula. Place the formulas in the appropriate cells below the contribution columns. <o:p></o:p></span></li> <li class=MsoNormal style='mso-list:l4 level1 lfo4;tab-stops:list .5in'><span style='mso-fareast-font-family:"Times New Roman"'>In the Caught up? <span class=GramE><span class=grame>column</span></span> use a formula to indicate when <span class=SpellE>Jazmine s</span> investment strategy catches up to Britney s.<span style='mso-spacerun:yes'>  </span>The formula will display an x in the cell for the row where Jasmine s balance is greater than or equal to Britney s. <o:p></o:p></span></li> </ul> <p class=MsoNormal><b style='mso-bidi-font-weight:normal'><span style='font-size:12.0pt;mso-bidi-font-size:10.0pt'>To Do<o:p></o:p></span></b></p> <p class=MsoNormal><o:p>&nbsp;</o:p></p> <ul style='margin-top:0in' type=disc> <li class=MsoNormal style='mso-list:l2 level1 lfo5;tab-stops:list .5in'><span style='mso-fareast-font-family:"Times New Roman"'>Select the third worksheet and rename it Questions<o:p></o:p></span></li> <li class=MsoNormal style='mso-list:l2 level1 lfo5;tab-stops:list .5in'><span style='mso-fareast-font-family:"Times New Roman"'>Put your name in cell A1. <o:p></o:p></span></li> <li class=MsoNormal style='mso-list:l2 level1 lfo5;tab-stops:list .5in'><span style='mso-fareast-font-family:"Times New Roman"'>Type in an answer to each of the following questions. You may have to do additional calculations. For example, computing the sum of all of your purchases using the sum function on the Credit Card worksheet.<o:p></o:p></span></li> <ul type=disc> <li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l2 level2 lfo5;tab-stops:list 1.0in'><span style='mso-fareast-font-family:"Times New Roman"'>Question1: how long will it take you to pay off the Credit Card? <o:p></o:p></span></li> <li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l2 level2 lfo5;tab-stops:list 1.0in'><span style='mso-fareast-font-family:"Times New Roman"'>Question2: what is the total cost of all the stuff you bought? <o:p></o:p></span></li> <li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l2 level2 lfo5;tab-stops:list 1.0in'><span style='mso-fareast-font-family:"Times New Roman"'>Question3: what is the total amount you paid? <o:p></o:p></span></li> <li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l2 level2 lfo5;tab-stops:list 1.0in'><span style='mso-fareast-font-family:"Times New Roman"'>Question4: how much do Britney and <span class=SpellE>Jazmine</span> have to retire on? <o:p></o:p></span></li> <li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l2 level2 lfo5;tab-stops:list 1.0in'><span style='mso-fareast-font-family:"Times New Roman"'>Question5: when did <span class=SpellE>Jazmine's</span> investment strategy catch up to Britney's? <o:p></o:p></span></li> <li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l2 level2 lfo5;tab-stops:list 1.0in'><span style='mso-fareast-font-family:"Times New Roman"'>Question6: how much did each woman put into the fund? <o:p></o:p></span></li> <li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l2 level2 lfo5;tab-stops:list 1.0in'><span style='mso-fareast-font-family:"Times New Roman"'>Bonus Question7: what average earnings rate gives them both about the same amount of money to retire on? <o:p></o:p></span></li> </ul> </ul> <p class=MsoNormal><a name=SECTION00030000000000000000><b style='mso-bidi-font-weight: normal'><span style='font-size:12.0pt;mso-bidi-font-size:10.0pt'>Turn In</span></b></a><b style='mso-bidi-font-weight:normal'><span style='font-size:12.0pt;mso-bidi-font-size: 10.0pt'><o:p></o:p></span></b></p> <p style='tab-stops:1.0in 4.0in'>Upload and submit your assignment file and rubric <a href="CIS100-EX1-grades.xlsx">grade sheet file</a> into your <span class=SpellE>Myitlab</span> assignment.</p> <p class=MsoNormal><b style='mso-bidi-font-weight:normal'><span style='font-size:12.0pt;mso-bidi-font-size:10.0pt'>Time <o:p></o:p></span></b></p> <p style='tab-stops:1.0in 4.0in'>This whole assignment should take you less than <span class=GramE>an</span> two hours. If it is taking you longer than that, find someone to ask for help. </p> </div> </body> </html>