A spreadsheet can be used for storing information, analysing information and performing calculations. It's useful for displaying and analysing survey results.
What is a spreadsheet?
A spreadsheet is software used for storing lists of information, analysing information and performing calculations.
This spreadsheet has nine rows and six columns
A spreadsheet is made up of rows and columns.
Rows go across the page and are labeled with numbers.
Columns go down the page and are labeled at the top with letters.
This spreadsheet has nine rows and six columns
A spreadsheet is made up of rows and columns.
Rows go across the page and are labeled with numbers.
Columns go down the page and are labeled at the top with letters.
Autofill
Autofill is found in most spreadsheet packages. Autofill helps to quickly enter frequently used series of data. Examples include:
dates
days of the week
series of numbers
Autofill works by dragging the bottom right-hand corner of a cell. As you hover the mouse over the corner, a cross will appear. Click and drag either down, or across to fill other cells.
Advantages of using spreadsheets
The great thing about spreadsheets is information can easily be updated:
prices can be updated
new items added
complex calculations can be made
Difference between function and formula
A formula is statement written by the user to be calculated. Formulas can be as simple or as complex as the user wants. A formula can contain values, references to cells, defined names, and functions.
All formulas must start with the equals sign.
Example: =(A1+A2+A3)
A function is a piece of code designed to calculate specific values and is used inside formulas. Functions and to calculate the current time is built into excel. Additional functions can be defined using Visual Basic.
Example: =Sum(A1:A3)
What is a spreadsheet?
A spreadsheet is software used for storing lists of information, analysing information and performing calculations.
This spreadsheet has nine rows and six columns
A spreadsheet is made up of rows and columns.
Rows go across the page and are labeled with numbers.
Columns go down the page and are labeled at the top with letters.
This spreadsheet has nine rows and six columns
A spreadsheet is made up of rows and columns.
Rows go across the page and are labeled with numbers.
Columns go down the page and are labeled at the top with letters.
Autofill
Autofill is found in most spreadsheet packages. Autofill helps to quickly enter frequently used series of data. Examples include:
dates
days of the week
series of numbers
Autofill works by dragging the bottom right-hand corner of a cell. As you hover the mouse over the corner, a cross will appear. Click and drag either down, or across to fill other cells.
Advantages of using spreadsheets
The great thing about spreadsheets is information can easily be updated:
prices can be updated
new items added
complex calculations can be made
Difference between function and formula
A formula is statement written by the user to be calculated. Formulas can be as simple or as complex as the user wants. A formula can contain values, references to cells, defined names, and functions.
All formulas must start with the equals sign.
Example: =(A1+A2+A3)
A function is a piece of code designed to calculate specific values and is used inside formulas. Functions and to calculate the current time is built into excel. Additional functions can be defined using Visual Basic.
Example: =Sum(A1:A3)
No comments:
Post a Comment