A Name the following.

1. Sign with which a formula begins in Excel. equal to (=) sign
2. Three types of data a formula consists of: Values, Cell addresses, Functions
3. Three relational operators: Less than, Greater than, Equal to
4. Three logical operators: Logical AND, Logical OR, Logical NOT
5. Two arithmetic operators: Addition (+), Subtraction (-)

B Match the columns.

1. #### → Column is not wide enough to display the number
2. #NAME? → Excel does not recognize the text in a formula
3. #N/A → Data is not available
4. #VALUE! → Formula contains an invalid operation
5. #DIV/0! → Division by zero is being performed.

C Fill in the blanks.

1. An absolute reference is specified using $ sign along with the column and row number of the cell.
2. Arithmetic operators perform calculations with only numeric value.
3. Logical operators are used to compare two or more relational expressions.
4. Relational and Logical operators give result in true or false.
5. Compound formula requires more than one operator to perform a calculation.

D State whether the given statements are true or false.

1. Arithmetic operators give the result in true or false. FALSE
2. The user might get errors while performing calculations. TRUE
3. Mixed reference is a combination of relative reference and absolute reference. TRUE
4. The Divide function returns the sum total of the range values. FALSE
5. The MAX function returns the largest value in the given range. TRUE

E Write the steps to perform the following tasks.

1. Use a basic formula.
   By using only one type of operator in the formula.
2. Enter a compound formula.
   By using more than one type of operator in the formula.
3. Use circular reference.
   By using the same cell to enter the formula which is a part of the formula itself.
4. Use SUM and AVERAGE functions.
   =SUM(set of values)
   =AVERAGE(set of values)
5. Use LCM and GCD functions.
   =LCM(set of values)
   =GCD(set of values)

F Answer the following questions.

1. Differentiate between relative, absolute and mixed references.
   In relative reference, the formula changes according to the change in position of the cell pointer. In absolute reference, the cell is made constant by making both column and row constant. In mixed reference, either the column or the row is made constant.
2. How are functions different from formulas?
   Functions are predefined commands in Excel, whereas formulas are customized commands in Excel.
3. Define the commonly used functions in Excel.
   The SUM() function finds the sum of a set of values.
   The AVERAGE() function finds the average of a set of values..
   The MAX() function finds the greatest number in a given set.
   The MIN() function finds the smallest number in a given set.
   The LCM() function finds the LCM of a set of values.
   The GCD() function finds the GCD of a set of values.
4. Enlist the rules to use functions.
   a. A function must begin with an equal to sign.
   b. A function name must be valid.
   c. A function name is followed by opening and closing parenthesis.
   d. Arguments should be enclosed within the parentheses.
5. Write the steps to insert a function.
   a. By directly inserting a function in a cell.
   b. By inserting a function using the Formula Bar.
   c. By using the Function Library group present in the Formulas tab.