DATA ANALYSIS IN SPREADSHEET

 

 

1.       Fill in the blanks:

 

(a)    A formula always starts with equal (=) sign , plus (+) sign , or minus (-) sign.

(b)   The AVERAGE function is used to find the average (mean) of arguments.

(c)    Operators can be used for numeric calculations.

(d)   When two operators share the same precedence the order of calculation is from left to right.

(e)   Each cell in the worksheet has an unique address formed by the combination of its intersecting  column and row.

(f)     MIN function is used to find the smallest value Of arguments.

 

2.       Select the most suitable alternative:

 

(a)    Entry of data in the form of text in a worksheet is known as:

Ans:- Text or Label Entry.

 

(b)   The cell address of column A and 10^th Row is:

Ans:- A10

 

(c)    Numbers in a worksheet are aligned towards:

Ans:- Towards the right side of the cells.

 

(d)   Text in a worksheet are a aligned towards:

Ans:- Towards the left side of the cells.

 

(e)   Which if the following function is used to find the largest value from the given range of cells?

Ans:- MAX ( )

 

3.       Differentiate between:

 

(a)    MAX ( ) and MIN ( )

Ans:- MAX ( ) :- This function is used to find the largest value from the given range of cells. Syntax: =MAX( argument1;argument2;……)

           MIN ( ) :- This function is used to find the smallest value from the given range of cells. Syntax: =(argument1;argument2;……)

 

(b)   SUM ( ) and AVERAGE ( )

Ans:- SUM( ) :- This function is used to find the sum of  the values of a range of cells. Syntax: =(argument1;argument2;…..)

           AVERAGE( ):- This function is used to find the average (mean) of the values in a range of cells. Syntax: =AVERAGE(argument1;argument2;…..)

 

(c)    Formula with cell addresses and cell names

Ans:-  Formula with cell addresses:- Each cell in the worksheet has a unique address that is formed by the combination of its intersecting column and row.

Formula with cell names:- Formula can be used along with cell names also. For doing so, you have to fix the name of the cell in the ‘Name Box’. For naming a cell you have to replace the address with required name in the name box. Once named, a user can apply them directly in a formula.

 

4.       Answer the following questions:

 

(a)    What is formula? Explain about the different types of formula used in spreadsheet.

Ans:- FORMULA :- One of the most important features of spreadsheet package is doing calculations. For calculation formulae are send. Formula are enter to perform mathematical operation such as addition, subtraction, multiplication, division, etc. Formula entry in a cell is logical entry. It shows the relationship between different cells.

     Formula can be categorized into three types:

·         Formula with ‘cell addresses’

·         Formula with ‘cell names’

·         Formula with ‘in-built functions’

 

(b)   What is AUTOSUM?

Ans:- Auto Sum button:- It is a shortcut tool for adding the values of a range of cells. To apply this tool, select the range of cells shoes data have to be added, then click on the AutoSum button which lies at the Formula Bar.

 

(c)    What is sorting? Explain the different steps of sorting data in a worksheet.

Ans:-  Sorting refers to the re-arranging of data on the basis of some defined criteria.

    Step of sorting data:-

·