1.

Explain different parts of an excel worksheet.

Answer»

The different uses of spreadsheets are as follows;

1. Performing basic mathematical operations such as adding columns and rows of figures.

2. Finding values such as profit or loss.

3. Calculating repayment plans for loans or mortgages.

4. Finding the average, maximum, or minimum values in a specified range of data.

5. Graphing or charting data, to assist users in identifying data trends.

6. Sorting and filtering data to find specific information.

7. Creation of simple lists and tables of alphabetic or numerical data.

8. Creation and manipulation of simple (flat-file) databases.

9. Establish relationships between sets of numerical data.

10. Applies arithmetical, mathematical or statistical functions to numerical data sets.

11. Represents data sets in graphical or chart form.



Discussion

No Comment Found