# CP102 Lecture Notes - Spreadsheet, Pie Chart

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

## Document Summary

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. Ranges: group of one or more adjacent cells occurring in rectangular shape. Password protection can prevent anyone from making changes to. 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.