1 <![CDATA[<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078690358/282013/U2_L1_1.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (26.0K)</a>]]> A) A B) B C) C D) D 2 A) argument B) constraint C) precedent D) scenario 3 A) the Insert menu B) the Format menu C) the Tools menu D) the Data menu 4 A) keeps a cell in view B) protects a cell C) copies a cell's content D) validates the data in a range of cells 5 A) Trace Precedents B) Increase Decimal C) Remove Precedent Arrows D) Remove All Arrows 6 <![CDATA[<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078690358/282013/U2_L1_2.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (29.0K)</a>]]> A) A B) B C) C D) D 7 A) advanced filter B) evaluate formula C) data validation D) solver 8 A) A formula that acts on only those items that meet certain specifications B) A version of a worksheet designed to test one of a number of possible outcomes C) A word or words that represent one cell or a range of cells D) A limit that is set 9 A) A limit that is set B) A formula that acts on only those items that meet certain specifications C) The total of a group of items within a larger set of items D) A value in a formula 10 A) Tools>Formula Auditing>Show Formula Auditing Toolbar B) Tools>Scenarios C) Tools>Error Checking D) Tools>Add-Ins
.
