L-5 Advance in Ms – Excel Test Ans/ Class 5th Computer

 

Class – 5^th

Subject: Computer Science

L-5 Advance in Ms – Excel

Class Test

Fill in the blanks

1) A  function  is a predefined formula in Ms-Excel.

2)  Average   is used to calculate the average of given range of numeric value.

3) Comparison of data in Ms- Excel can be done with the help of  Chart .

4) Sorting can be  ascending  and  descending  order.

5)  Sorting  is the process to arrange data in ascending or descending order.

6) In  SUM  function is used to calculate the range of cells to calculate their sum.

7) Descending  is used to arrange data from highest to smallest order.

8) Autosum function can be used only with range of  cells.

9) In Ms- Excel data can be arranged in  tabular  form.

10) Ms-Excel  is spreadsheet software.