Please enable JavaScript.
Coggle requires JavaScript to display documents.
Ch.7 Spreadsheets - Coggle Diagram
Ch.7 Spreadsheets
7.2 Basic Operations of Microsoft Excel 2007
A spreadsheet file can contain many worksheets and the data on each of them can be interdependent
Basic storage unit is called cell
Data presented in different formats
Autofill
Extending the series
Copy and paste
7.4 Functions
Statistical function
COUNT
COUNTIF
AVERAGE
LARGE
MIN
SMALL
MAX
MODE
Mathematical functions
INT
MOD
ROUND
POWER
SUMIF
RAND
SUM
Logical functions
IF
AND
OR
NOT
Text, date and time functions
MONTH
YEAR
DAY
WEEKDAY
VALUE
TODAY
TEXT
DATEVALUE
RIGHT
TIME
MID
TIMEVALUE
LEFT
HOUR
LEN
MINUTE
CHAR
SECOND
CODE
7.6 Data Manipulation Techniques
Working with a table
Recorder
Table
Table header
Field
Sorting records
Filtering records
Number
Text
Date
7.1 Introduction to Spreadsheets
The functions of an electronic spreadsheet
Spreadsheets allows users to input and organise, create charts and perform data analysis
Examples
Microsoft excel
Corel Quattro Pro
OpenOffice.orgCalc
Usage
Accounting reports
Financial models
Inventory reports
Quotation
Personal mail lists
The origin of electronic spreadsheet
Spreadsheet is an jargon used in accounting
Accountants presented business data such as item quantity, cost and revenue in rows and columns on a large sheet of paper
7.3 Formula and Cell Reference
Elements of a formula
Function
Cell reference
Operator
Constant
Cell reference
Mixed cell reference
Absolute cell reference
Relative cell reference
7.5 Creating Charts
chart type
Bar chart
Column chart
Pie chart
Stock chart
Scatter chart
Line chart
7.7 Data Analysis
What-if analysis
Data table
Scenario manager
Goal seek