1.
<![CDATA[<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078687101/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/0078687101/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
