Please enable JavaScript.
Coggle requires JavaScript to display documents.
Ch7 Speardsheet - Coggle Diagram
Ch7 Speardsheet
7.2 Basic Operations of Microsoft Excel 2007
7.2.1 Working environment of Microsoft Excel 2007
Basic storage unit is called
cell
, which is arranged into rows and columns.
Each cell has a unique cell address formed by a column letter followed by a row number
7.2.2 Data entry and data format
To enter data or formula into a cell:
select a cell
enter data into the cell
Press 'Ener' to complete the input
Three ways to modify the data in an active cell:
Press the function key ‘F2’ and then change the cell content in the cell.
Double-click the cell and then change the cell content in the cell.
Click the Formula Bar and then change the cell content in the Formula Bar.
Users can change the cell format through the command buttons in the ‘Number’ group.
cell format
general
currency
data
time
fraction
scientific
7.2.3 Auto Fill
Allow user to create a series of values based on the value of one or more selected cells
adjacent to each other.
two ways to fill up cells adjacent
copy and pase
Extending the series
Data Entry and Data Format
Microsoft Excel tries to determine the pattern of data in the source.
If Microsoft Excel fails to identify the pattern, it simply fills up the adjacent cells
repeatedly with the value in the source.
Auto Fill
If Microsoft Excel successfully determines the pattern of data in the source, the
adjacent cells are filled with values by extending the series.
AutoFill can be used to create number sequences, time lists, day lists, week lists,
month lists and regular text patterns.
7.1 Introduction to Speardsheet
7.1.1The origin of electronic spreadsheet
Spreadsheet is a 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.1.2 The functions of an electronic spreadsheet
allows user to input and organise data
allows user to creat charts and perform data analysis
example of spreadsheet software
Microsoft Excel
Corel Quattro Pro
OpenOffice.org
7.3 Formula and Cell Reference
7.3.1Formula
store in a cell
begin with equal sign (=)
7.3.2 Elements of a formula
element:
constant
operator
cell reference
function
cell reference
A basic element in an Microsoft Excel formula.
Types of cell references
Relative cell reference
Absolute cell reference
Mixed cell reference
7.4 Functions
7.4.1 Statistical function
useful for finding out the tendency, distribution and characteristics of the data to make the anaylisys much easier
commonly used statistical functions
MAX
MIN
AVERAGE
COUNT
COUNTIF
LARGE
SMALL
MODE
7.4.2 Mathematical functions
can be used to sum up
of commonly used mathematical functions
SUM
SUMIF
ROUND
INT
MOD
PROWER
RAND