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

 

Class – 5^th

Subject: Computer Science

L-5 Advance in Ms – Excel

Class Test

Fill in the blanks

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

2) ____________ 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 ______________.

4) Sorting can be _____________ and _______________ order.

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

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

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

8) Autosum function can be used only with _________________ cells.

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

10) _________________ is spreadsheet software.