Please enable JavaScript.
Coggle requires JavaScript to display documents.
spreadsheet applications (formulas and functions (Average= (=AVERAGE(C3…
spreadsheet applications
-
Importing Data
Data can be imported into a spreadhseet from other software sources, for example database table.
In some cases, the file being imported may have to be in a certain format, for example CSV(comma-separated value), before the import process can begin.
-
-
relative cell reference
changes a formulas cell reference to refer to the next cell when the formula is copied down a column or across a row
absolute cell reference
when a formula is copied to other cells , part of the cell reference does not change as the formula is modified
-
Macros
-
-
Running a macro will result in instructions stored within the macro being executed with as single click of a button
Using macros in spreadsheet: When using a spreadsheet, a macro can eliminate the need for the need for the user to repeat the steps of commonly performed tasks over and over again
Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant, no matter where they are copied