Please enable JavaScript.
Coggle requires JavaScript to display documents.
Ch 7 Spreadsheet - Coggle Diagram
Ch 7 Spreadsheet
7.6 Data Manipulation Techniques
7.6 Data Manipulation Techniques
Table header
Record
Field
Table
7.6.2 Sorting records
Rearrangement of records according to a specific criterion
Simple sort using a single criterion
Users can choose any header to be the sort key.
For a new sorting, the original sorting order is overridden.
All records will be reordered according to the new sorting criterion.
7.6.3 Filtering records
Filtering is a function to select and display only the records meeting
the criteria we specified.
It is very difficult to look for records we want if the number of records is large.
data types
text
number
date
7.7 Data Analysis
7.7.1 Data analysis
Generation of summary reports
profit forecast
7.7.2 what if
to see how the outcome is affected by changing the value of variable
Tools to conduct what-if analysis in Microsoft Excel
Scenario Manager
Goal Seek
7.7.3 Pivot table
can presented in the multi-layered format
The basic structure of a pivot table
row field
column field
value field
report field
7.5 Creating Charts
7.5.1 creating chart
use to visualise the relationship between data.
Important tool for data analysis and presentation
7.5.2 Selection of chart type
Should choose the chart type carefully.
chart type:
bar chart
line chart
pie chart
scatter chart
stock chart
7.5.3 Should choose the chart type carefully.