CP102 Lecture Notes - Spreadsheet, Pie Chart

94 views2 pages
19 Mar 2013
School
Course
Professor
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
Unlock document

This preview shows half of the first page of the document.
Unlock all 2 pages and 3 million more documents.

Already have an account? Log in

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.

Get access

Grade+
$10 USD/m
Billed $120 USD annually
Homework Help
Class Notes
Textbook Notes
40 Verified Answers
Study Guides
Booster Classes
Class+
$8 USD/m
Billed $96 USD annually
Homework Help
Class Notes
Textbook Notes
30 Verified Answers
Study Guides
Booster Classes