Class Notes (1,100,000)
CA (630,000)
WLU (20,000)
CP (300)
CP102 (90)
Lecture

CP102 Lecture Notes - Spreadsheet, Pie Chart


Department
Computer Science
Course Code
CP102
Professor
Mark Petrick

This preview shows half of the first page. to view the full 2 pages of the document.
Excel Spreadsheet
Tuesday, January 22, 2013
3:53 PM
Spreadsheets
Organize data in rows and columns
Computerized version of paper spreadsheet benefits:
Eliminates much of tedium, calculations are error-free
Worksheet automatically recalculated when one value/calculation is
changed
What-if analysis: allows users to change one value and have results instantly
recalculated (useful in financial forecasting)
Cells and Cell Addresses
Spreadsheet divided into rows and columns
Cell is intersection of row and column
Address of cell= column letter + row number (ex. B7)
Active cell- cell available to be edited at given time
Contents of Cells
Label- provides descriptive text info about entries in spreadsheet
Value- actual number that is entered into cell
Displayed value- what is displayed in cell
Formula: instruction to program to calculate number
Function: preprogrammed formula
Ranges
Group of one or more adjacent cells occurring in rectangular shape
Spreadsheet Features
Width of columns/heights of rows can be modified
Headings can be created as wide column
Numbers can be formatted with appropriate symbols (%, $,…), number of
decimal places can be specified
Security
Cells protected so user doesn't accidently destroy complex formulas
Password protection can prevent anyone from making changes to
worksheet
Problem for Spreadsheet
Planning the spreadsheet
Create sketch of spreadsheet (show labels/data should appear)
Specify any formulas/functions needed
Making First Draft
Type column/row headings, enter data into cells, enter/test formulas
Changing Spreadsheet
Change value in one cell, affects other cells
Formatting and Printing
Format labels, sales numbers as currency, borders, cell shadings
Creating graph from spreadsheet data
Graph created based on data in spreadsheet
You're Reading a Preview

Unlock to view full version