L-5 Advance in Ms-Excel / Clas-5 Computer

 

Class – 5^th

Subject : Computer

L-5 Advance in Ms Excel

Paste and label components of Ms-Excel window components

Q : Define Ms-Excel.

Ans:Microsoft Excel is a software program produced by Microsoft that allows users to organize, format and calculate data with formulas using a spreadsheet system. This software is part of the Microsoft Office suite 

Q : Define Formula.

Ans : A formula is an equation that makes calculations based on the data in your spreadsheet. Formulas are entered into a cell in your worksheet. They must begin with an equal sign, followed by the addresses of the cells that will be calculated upon, with an appropriate operand placed in between.

Q : Define Function .

Ans : A function is a predefined formula that performs calculations using specific values in a particular order. Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.

Make a list of Different function

S.No.	Function	Use	Syntax
1	Sum	It is used to calculate the sum of given range similar to Autosum Function.	=SUM(Number1, Number2……)
2	Average	It is used to calculate the average of given range of numeric values.	=AVERAGE ( Number1:Number2)
3	Maximum	It is used to find out the maximum value ( Largest Value) from a given range of numeric values.	=MAX ( Number1:Number2)
4	Minimum	It is used to find out the minimum value ( smallest Value) from a given range of numeric values.	=MIN ( Number1:Number2)

 

A. Fill in the blanks :

range of, chart, ascending , tabular, sorting, descending

1. Comparison of data in Microsoft Excel can be done with the help of

Chart .

2. In MS Excel data can be arranged in tabular  form.

3. Autosum function can be used only with range of  cells.

4. Sorting can be ascending  or descending order.

5. sorting   is used to arrange data in smallest to highest order.

35B. Very Short Answer Questions:

1)  Give two uses of MS Excel.

Ans: 1) Easiest way to perform calculation

2) Automatically recalculation if altered the data.

 

2)  What is Autosum Function?

Ans: Autosum function is used to calculate the sum of given range of numeric values.

 

C. Short Answer Questions:

1) Differentiate between Max Function and Min Function.

Ans:

Max Function	Min Function
It is used to find out the maximum value ( Largest Value) from a given range of numeric values.	It is used to find out the minimum value ( smallest Value) from a given range of numeric values.
Syntax of MAX Function =MAX ( Number1:Number2)	Syntax of MIN Function =MIN ( Number1:Number2)

 

 

2) Define Average Function.

Ans: Average function is used to calculate the average of given range of numeric values.

Syntax of AVERAGE Function

=AVERAGE ( Number1:Number2)

 

D. Long Answer Questions:

1)   Define Sum Function.

Ans: In SUM function is used to calculate the range of cells to calculate their sum. Syntax of SUM Function

=SUM(Number1, Number2……)

 

2)   What is sorting?

Ans: SORTING : it is the process to arrange the data in ascending or descending order. Data can be alphabetic or Numeric

Ascending Order : It is used to arrange data from smallest to highest order.

Descending Order : It is used to arrange data from highest to smallest  order.

  

E. Name the following:

1)   Easiest way to perform calculation.

Ans: Ms-Excel

 

2)   It can be used only with contiguous cells.

Ans: Autosum

 

3)   It is used to arrange data in smallest to highest order.

Ans: Sorting : Ascending