Please enable JavaScript.
Coggle requires JavaScript to display documents.
CH.7 - Coggle Diagram
CH.7
7.4
statistical function
mathematical functions
logical functions(important !)
text,date and time functions
7.1introduction to spreadsheets
a jargon used in accounting
Accounts presented business data such as item quantity ,cost and revenue in rows and columns on a large sheet of paper
example
Microsoft Execl
Corel Quattro Pro
OpenOffice.org Calc
7.2
Cell Format
General
Currency
Date
Time
Fraction
Scientific
autofill
copy and paste
extending the series
to enter data or formula unto a cell
select a cell
2.enter data into a cell
3.press"enter" to complete the input
7.3
formula
elements
constants
operator
cell reference
relative cell reference
absolute cell reference
mixed cell reference
function
begin with a equal sign(=)
7.5
chart
column chart bar chart
line
pie
scatter
stock