Computer Science 1032 Excel Notes.docx

1 Page
122 Views

Department
Computer Science
Course Code
Computer Science 1032A/B
Professor
Diane Goldstein

This preview shows half of the first page. Sign up to view the full page of the document.
Description
Excel Spread Sheet  Workbook: A collection of one or more spreadsheets (every excel workbook has three spread sheet tabs)  An application designed to handle the organization, summarization, and presentation xof primarily numeric data  Turned out to provide incredible labour savings, and were greatly used in the early adoption of personal computers Entering Data  Cell: the intersection of a column and a row with a specific name that can store text, numbers, and formulas o A cell can be edited by clicking the cell and typing (overwriting what is currently in the cell) or by clicking on the cell and typing on the cell contents area (editing what is currently in the cell)  Cell Referencing: o Spreadsheets allow you to reference other cells when you build a formula o This can be done by clicking the cell, typing ‘=’, and typing or clicking the location of the cell o Never use actual numbers in a spreadsheet formula unless the number will never change  Filling Formulas: o Relative Reference: A type of referencing that adjusts during a copy operation  Default mode; when an equation is copied from one cell to another, the value of the formula are
More Less
Unlock Document

Only half 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