Excel Multiple Choice =)?

1.When a formula is copied, which type of cell reference adjusts completely to the new cell position?


a.Mixed with relative row number.c.Absolute.


b.Mixed with relative column name.d.Relative.





2.To override the order of precedence, which of the following is used to enclose parts of a formula?


a.Dollar signc.Parentheses


b.Plus signd.Ampersand





3.What is the result of this formula: =1+2*3-1?


a.4c.8


b.6d.10





4.What is the result of this formula: =(2+3)*4/2?


a.4c.8


b.6d.10





5.Which arithmetic operator is used to concatenate two or more strings?


a.‘ (single quotation mark) c.! (exclamation point)


b.%26amp; (ampersand) d.^ (caret)





6.In a formula, which pair of arithmetic operators does NOT have the same precedence?


a.= and %26lt; c.* and /


b.+ and - d.%26amp; and %26lt;





7.What is the result of the operation =(1+2)*(3-1)?


a.4c.6


b.5d.7

Excel Multiple Choice =)?
Looks to me like someone needs help with their homework.
Reply:1. d


2. c


3. b


4. d


5. a (I think this is the only one I am not sure of)


6. d (%26amp; is not an arithmetic operator)


7. c