**Computer Science**

**Class-7**

**Chapter-3 Formulas in MS Excel**

**A. Tick the correct option:**

1. An Excel formula always begins with-

a. a plus sign(+) b. a minus sign(-) c. an equal sign(=) d. None of these

**Answer: an equal (=)**

2. Which of the following is an example of function?

a. G5 b. Sum c. + d. None of these

**Answer: Sum**

3. Which of the following is an example of operator?

a. G5 b. 4 c. * d. None of these

**Answer: ***

4. ________ are ready-made formulas in MS Excel.

a. Operators b. Cell references c. Functions d. None of these

**Answer: Functions**

**B. Write true or false:**

1. MS Excel displays three sheet in a worksheet named as sheet1, sheet2 and sheet3.

**Answer: T**

2. Numerical formula allow you to manipulate text strings.

**Answer: F**

3. The ampersand operator is used to link one or more text strings.

**Answer: T**

4. Count number function returns the smallest value in a series.

**Answer: F**

5. A sheet tab cannot be renamed.

**Answer: F**

6. Average function finds the average of the numbers given to it as a argument.

**Answer: T**

7. The (+) sign helps you to concatenate string.

**Answer: F**

**C. Answer the following questions:**

1. What is a formula in excel? Explain with help of an example.

**Answer:**Formulas are one of the most commonly used features of MS Excel. A Formula is an expression that includes cell numbers, addresses, arithmetic operators and parenthesis.

2. What are operators?

**Answer:**Operators are symbols, these are used to perform calculations on the given values. Some operators are:

1. + for Addition

2. - for Subtraction

3. * for Multiplication

4. / for Division

3. What is concatenation?

**Answer:**The procedure of linking the text string in a series is called concatenation. The &(ampersand) operator is used to link one or more text strings. Always enclose text strings within double quotes.

4. Write the steps to create a text formula.

**Answer:**To create text formula, perform the following steps:

1. Click on A10 cell where you want to display the result of formula.

2. Type the formula as =A2& "has obtained" & D2&" percent marks".

3. Press the enter key to view the result.

5. What are functions? Name some of the functions.

**Answer:**Functions are ready-made formulas in Excel, which allow you to perform simple and complex mathematical calculations. Some functions are:

1. Sum

2. Count

3. Min

4. Max

6. Define average function.

**Answer:**Average function finds the average of the numbers given to it as argument. To calculate an average, MS Excel adds up the values in the selected range and then divides that total by the number of non-blank cells in the range.

7. Write the steps to use Max function.

**Answer:**To use Max function, perform the following function:

1. Select the cell where MAX function will be entered.

2. Click on the formula tab.

3. Click on the AutoSum button.

4. Change the range of cells.

5. Press the Enter key.

8. What is AutoSum feature?

**Answer:**AutoSum feature is one of the most popular features available in MS Excel. It helps to automatically total the contents of cells.

To use AutoSum feature, perform the following steps:

1. Click in the cell.

2. Click on the AutoSum in the editing group.

3. Click on the enter button.

## No comments:

## Post a Comment