assignment #2

INTRODUCTION

Excel Spreadsheet is an application made and distributed by Mac OS X by Microsoft for Microsoft Windows. Allows the user to use calculation tools, graphing tools and pivot tables. The programme uses a language called VBA (visual basic application). Five of Excel Spreadsheet features about to be discussed are Sum, Average, Minimum, Maximum and Count.

SUM

The sum function adds the cells together.

Example: =SUM(A1,B1)

In this function: equal sign starts the function.SUM is the name of the function. A1, and B27 are the cells. Parentheses enclose the cells. A comma separates the cells.

AVERAGE

In excel spreadsheet the average function returns the average or arithmetic mean of the numbers provided.

Example: =AVERAGE(A1:A8)

In this function: The equal sign begins the function, AVERAGE is the name of the function. A1 to A8 are the cells. Parentheses enclose the cells. A colon separates the range.

MINIMUM

In Excel Spreadsheet the MINIMUM function returns the minimum value within a range of cells.

Example: =MIN(A1:A100)

In this function: The equal sign begins the function, MIN is the name of the function. A1 to A100 are the range of cells. Parentheses enclose the cells. A colon separates the range.

MAXIMUM

In Excel Spreadsheet the MAXIMUM function returns the maximum value within a range of cells.

Example: =MAX(A1:A100)

In this function: The equal sign begins the function, MAX is the name of the function. A1 to A100 are the range of cells. Parentheses enclose the cells. A colon separates the range.

COUNT

Excel Spreadsheet the COUNT function totals the number of cells in a selected range.

Example: =COUNT(A1:A6)

In this function: The equal sign begins the function, COUNT the name of the function. A1 to A6 are the range of cells. Parentheses enclose the cells. colon separates the range.

CONCLUSION

Microsoft excel is a good program it make tables easy to use with its simple task functions and it commands and i look forward to using it