Class Notes (837,286)
Canada (510,219)
Dr.Hurst (27)
Lecture

Notesolutions COMP SCI 1B03 Lecture 2.docx

2 Pages
142 Views
Unlock Document

Department
Computer Science
Course
COMPSCI 1BA3
Professor
Dr.Hurst
Semester
Fall

Description
September 10-12, 2012 Dr. Nicole Wagner Excel terminology - Excel files are called workbooks (.xlsx for 2010) - A workbook s made up of sheets - worksheets - chart sheets - Can have multiple workbooks and sheets open at once, the one you're working n is active. - Rows and columns intersect at cells, which may be identified by their cell reference. Creative effective Workbooks - In practice, workbooks can be: - Used and updated by many people - Very complicated - Multiple worksheets and chart sheets, extensive data - Formulas may be used to populate cells - One worksheet can be the source data for other worksheets or even workbooks. - Contain Macros (some programming code) to automate activities. - These factors should be considered when planning a new book. - Good practice: - Plan out your workbook: - What problem do you want to solve? - What data is needed? - What calculations are required? - What form should the solution take? - From these answers determine the worksheets required. - Include a documentation sheet to describe your workbook. Navigating in Excel - There are generally multiple ways to do things in excel (mouse, keyboard shortcuts, dialogue boxes, etc.)
More Less

Related notes for COMPSCI 1BA3

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