Class 8 | Chapter 8 | Advance Features of Spreadsheet

Advance Features of Spreadsheet (Microsoft Excel)

Write very short answer of the following questions.
a) Is Ms-Word spreadsheet software?
Ans: No, Ms-Word is not spreadsheet software.
b) Which company released Excel program?
Ans: Excel program was released by Microsoft Corporation USA.
c) Which symbol is used to make absolute cell reference?
Ans: $ symbol is used to make absolute cell reference eg: $b$2
d) Which symbol is used to begin formula in Ms-Excel?
Ans: Is equal to (=) symbol is used to begin formula in Ms-Excel.
e) How many types of data sorting are used in Excel?
Ans: There are two types of sorting data either in ascending order or in descending order.
f) Write the symbols used as reference operator.
Ans: Colon (:) symbol is used as reference operator.
g) Write the use of RANK function in excel.
Ans: RANK function is used to find rank from the given number list in excel.
h) How many Row and columns are there in Ms-Excel 2016?
Ans: Each worksheet of Ms-Excel 2016 contain 1,048,576 rows and 16,384 columns.
i) What is the extension of Excel worksheet?
Ans: Dot xls or Dot xlsx (.xls or .xlsx) is the extension of Excel worksheet.

Write short answer of the following questions
a) What is spreadsheet? Write two example.
Ans: Spreadsheet is a software package that accepts data in tabular form in row and columns. Example: Visi calc, Ms-Excel etc.
b) What is Ms-Excel? Write two versions of Ms-Excel.
Ans: Ms-Excel is one of the popular and widely used spreadsheet software developed by Microsoft Corporation USA. Ms-Excel 2007, Ms-Excel 2016 are the two version of Ms-Excel.
c) What is formula? Write the rules of using formula.
Ans: Formula is a sequence of values, cell references and operators that produces a new value from existing values.
Rules for using formula in Excel are given below:
i) The formula always must begin with an equal sign (=)
ii) After inserting formula, press Enter key to confirm it.
iii) The formula are not case sensitive.
iv) The cell address also can be used in the formula. Eg. (A2+B2)*F5
v) The references, constants, operators and functions can be used in formula.
d) What is the fill handle? What is its use?
Ans: Fill handle is a small black square that appears at the bottom right corner of the selected cell. It is used auto fill list items, to fill custom list etc.
e) What is meant by sorting data?
Ans: Sorting is the process of arranging worksheet data in alphanumeric order. There are two types of sorting data in the cell either in ascending order or in descending order.
f) What is chart? List the common chart types.
Ans: Charts are graphical presentation of numeric data in the worksheet. Charts are based on data contained in worksheets and it helps to observe and compare different data in the worksheet.
The most commonly used types of charts are Bar chart, Column chart and pie chart.

Write long answer of the following questions.
a) Why is Ms-Excel popular and user friendly spreadsheet software? discuss.
Ans:
b) Explain different types of cell references used in Ms-Excel with examples.
Ans:
c) Describe the common functions used in Ms-Excel.
Ans: