8.Desktop.Publishing.IV.Spreadsheets

8.Desktop.Publishing.IV.Spreadsheets - Desktop Publishing...

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

View Full Document Right Arrow Icon
1 Desktop Publishing IV – Spreadsheet Software With thanks to Dr. A. Zhang, Dr. Haipeng Guo, and Dr. David Chen Lecture 8
Background image of page 1

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

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

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

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

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

View Full DocumentRight Arrow Icon
6 OpenOffice Calc r Tool to create professional spreadsheets and charts http://www.openoffice.org/product/calc.html r Calc window s Many elements - Title bar, Menu bar, Tool bars, Formula bar, Worksheets, and Status bar s Similar to OpenOffice Writer
Background image of page 6
7
Background image of page 7

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

View Full DocumentRight Arrow Icon
8 Calc Window r Formula bar s Name box s Function Wizard, Sum, Function s Cell entries (data) s View > Formula bar r Worksheets s Workbook s 3 worksheets by default s Cell address: A1, B6, E10, . ..
Background image of page 8
9 r Status bar s View > Status bar s Statistics Calc Window
Background image of page 9

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

View Full DocumentRight Arrow Icon
10 r Start a workbook s Click New icon or choose File > New r Enter text s Simply click a cell and type r Enter numbers
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/28/2010 for the course COMPUTER H 2012 taught by Professor Dave during the Spring '10 term at Quebec Abitibi-Temiscamingue.

Page1 / 29

8.Desktop.Publishing.IV.Spreadsheets - Desktop Publishing...

This preview shows document pages 1 - 11. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online