{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

This preview shows pages 1–11. Sign up to view the full content.

1 Desktop Publishing IV – Spreadsheet Software With thanks to Dr. A. Zhang, Dr. Haipeng Guo, and Dr. David Chen Lecture 8

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
2 Outline rhombus6 What is Spreadsheet Software? rhombus6 OpenOffice Calc Basics rhombus6 Performing Calculations rhombus6 Creating Chart
3 Spreadsheet Software rhombus6 Another widely used application software square6 Allows users to organize data in rows and columns and perform calculations on the data square6 Rows and columns collectively are called worksheets square6 Features from word processing rhombus6 Spreadsheet organization square6 Up to 255 worksheets square6 256 columns, and 65,536 rows square6 Letters identify columns (A … IV) square6 Numbers identify rows (1 …65536)

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
4 Spreadsheet Software rhombus6 Cells square6 A cell is the intersection of a column and a row square6 256 * 65,536 cells square6 Identifies cells by the column and row, e.g. B6 square6 Contains three types of data: labels, values, and formulas rhombus6 Calculations square6 Value – a number used in a calculation square6 Formula – performs calculation to generate values square6 Function – predefined formula
5 Spreadsheet Software rhombus6 Recalculation square6 One of the powerful features square6 Making manual changes can be time-consuming and may result in new errors square6 Making changes in an electronic worksheet is much easier and faster, and more accurate rhombus6 Charting square6 Depicts data in graphical form square6 Line chart , shows a trend during a period of time square6 Column chart , displays bars of various lengths to show the relationship of data square6 Pie chart, shows the relationship of parts to a whole

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
6 OpenOffice Calc rhombus6 Tool to create professional spreadsheets and charts http://www.openoffice.org/product/calc.html rhombus6 Calc window square6 Many elements - Title bar, Menu bar, Tool bars, Formula bar, Worksheets, and Status bar square6 Similar to OpenOffice Writer
7

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
8 Calc Window rhombus6 Formula bar square6 Name box square6 Function Wizard, Sum, Function square6 Cell entries (data) square6 View > Formula bar rhombus6 Worksheets square6 Workbook square6 3 worksheets by default square6 Cell address: A1, B6, E10, ...
9 rhombus6 Status bar square6 View > Status bar square6 Statistics Calc Window

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
10 rhombus6 Start a workbook square6 Click New icon or choose File > New rhombus6 Enter text square6 Simply click a cell and type
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}