SpreadSheets
Spread sheets allow you to interactive computer applications program for organization and analysis of information. It's a computer program used for accounting, meaning figures are arranged in the rows and columns of a grid. A modern spreadsheet file consists of multiple worksheets that make up one workbook, with each file being one workbook. A cell on one sheet is capable of referencing cells on other, different sheets, whether within the same workbook.
I used spreadsheets because I found it was easy to use, great for
organizing, and it calculating data values using different formula's.
I used spreadsheets because I found it was easy to use, great for
organizing, and it calculating data values using different formula's.
Click the button "click" to view "You've Never Seen a Spreadsheet Do This"
Example of two functions in spreadsheets
A function is a preset formula in Excel. Like formulas, functions begin with the equal sign ( = ) followed by the function's name and its equation. The function name is what calculation to Excel will perform. The equations are contained inside round brackets.
AVERAGE function
The AVERAGE function is used to find the
average value in a range of data while the IF
function will give you different results depending
on whether or not a specific condition is met.
average value in a range of data while the IF
function will give you different results depending
on whether or not a specific condition is met.
average if function
AVERAGE IF makes it easier to find the average
value if specific criteria are met. This makes it
possible to set up cells in a spreadsheet
so that the data is averaged only when a certain
level is reached.
value if specific criteria are met. This makes it
possible to set up cells in a spreadsheet
so that the data is averaged only when a certain
level is reached.
Click here to see more functions and their use
Here is an example of my work using spreadsheets:
Your browser does not support viewing this document. Click here to download the document.