Page 1 :
5., 2., 10., Afunction must be followed by opening and closing. anenthesis., 11., SQRT(numberd, function returns a positive square root., 12., function finds the largest number in a range., B., State True or False:, 1. Formulas are only used to perform simple calculations., In Absolute Referencing, the relative position of rows and columns change where, you copy a formula., 3., Combined Reference is a type of cell reference., 4. In Absolute Referencing, dollar '$' sign is used before the cell co-ordinates., 5. Ranges can be used ina formula., 6. Sheet tab cannot be renamed., 7., SUM function is used to find sum of values., It is necessary to open and close parenthesis when you use function in a formula., 8., C., Multiple Choice Questions:, 1. The formula must begin with, a. plus(+) sign, b. minus(-) sign, c. equal to (=) sign, 2., The cell address in the formula is known as, a. Cell printer, b. Cell Reference, c. Cell function, 3., To use the Sheet reference, we have to specify the address in the following way., a. D4! Sheet1, b. Sheet1, D4, c. Sheet1! D4, 4., function returns the remainder after a number is divided by the divisor., a. MOD, b. POWER, c. SUM, function finds the largest number in a range., a. Average(), b. Count(), c. Max(), 6. In MS Excel, there are, /pes of cell references., b. Three, c. Four, a. Two, D., Answer the following:, 1. What is a formula? Why do we use formulas?