Class Notes (839,559)
Canada (511,394)
CP102 (99)
Lecture

excel spreadsheet.doc

2 Pages
129 Views

Department
Computer Science
Course Code
CP102
Professor
Mark Petrick

This preview shows 80% of the first page. Sign up to view the full 2 pages of the document.
Description
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
More Less
Unlock Document

Only 80% of the first page are available for preview. Some parts have been intentionally blurred.

Unlock Document
You're Reading a Preview

Unlock to view full version

Unlock Document

Log In


OR

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


OR

By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.


Submit