SOLUTIONS FOR CLASS 9 CHAPTER EDITING DATA IN A SPREADSHEET

Answer the following questions:

1. List the types of data that you can enter in a spreadsheet.

Ans. We we can enter three types of data in a spreadsheet as Numbers, Text, and Formulas.

2. What is a compound formula? Give an example. 

Ans.  Compound formulas are used when we need more than one operator. example- In calculating Simple Interest. P*R*T /100.

3. Distinguish between formulas and functions. 

Ans. 

• Formulas are equations that perform calculations.on values. It is an expression that can include cell addresses, numbers, arithmetic operators, and parenthesis. The result of the calculation is displayed in the cell where the formula is entered. The formula must begin with an '=' symbol followed by cell reference and operaters. We can use either uppercase or lower case letters while entering the cell address in a formula. example- = A2+B2
• Functions are pre-designed formulas to perform simple and complex calculations. Functions eliminate the chance to white wrong formulas. They accept Arguments and return values. Since a function cannot exist on its own, it must always be a part of a formula. Functions were made up of two parts- structure and Arguments. examples- = SUM (AL: A4)

4. Explain the use of MAX and MIN functions.

Ans. The MAX function returns the largest value among the seat of values in a given range of cells. This function only considers numuric entries and logical values as its arguments. If there are no valid arguments within the MAX function, it returns a value of 0.

The MIN function returns the smallest value among the seat of values in a given range of cells. This function only considers numeric entries and, logical values as its arguments. If there are no valid arguments within the MAX function, it returns a value of 0.

5. Describe the Use of the COUNT () function. 

Ans. This function counts the number of numeric entries, formulas, and date entries in a given range of cells. example- = COUNT (A4:04)