Please enable JavaScript.
Coggle requires JavaScript to display documents.
Ch.7 Spreadsheet - Coggle Diagram
Ch.7 Spreadsheet
Spreadsheets
Environment
presented in rows and columns, and cells
each cell has unique cell address
with hundreds of predefined functions
Usage
Inventory Report
Quotation
Accounting Reports
Personal Mail Lists
Financial Models
Example of software
Corel Quattro Pro
OpenOffice.org Calc
Microsoft Excel
Operations
AutoFill
Copy and Paste
ctrl(⌘) c/v
Extending the Series
by auto detecting the pattern of data
sometime problematic
Cell format
Date
Time
Currency
Fraction
Number
Scientific
Table
Functions
Sorting
Single Criteria
Multiple Criteria
Filtering
Text
Date
Number
Just tables
Charts
Usages
Data Analysis and Presentation
Visualize the relationship between data
Chart Type
Pie Chart
Scatter Chart
Line Chart
Stock Chart
Column / Bar Chart
Formula and Cell references
Formula
Starts with "="
Elements
Operater
Cell Reference
Constant
Function
Mathematical Functions
Logical Functions
Statistical Function
Text, Date and Time Functions
Cell Reference
Mixed Cell Reference
Absolute Cell Reference
Relative Cell Reference
Data Analysis
Pivot Tables
Generate Summary Table based on Data Sets
Structures
Column Field
Value Field
Row Field
Report Filter
Provided with lists of predefined functions
Pivot Charts
What-if Scenario
How the Outcome is affected by variables
Goal Seek
How Changes of variables affect Outcomes
find out Desired Value
can only work with "Number" Cell Format
Scenario Manager
can switched between Scenarios
generate Summary Report
4C17 Sam Ching