Class Notes (806,882)
Canada (492,497)
Dr.Hurst (27)

Notesolutions COMP SCI 1B03 Lecture 2B.docx

2 Pages
Unlock Document

McMaster University
Computer Science

September 13, 2012 Working with Formulas - The main reason for using Excel is to display values calculated from data - A formula is an expression that returns a value - Begins with "= " - Operators combine different values - Generally arithmetic operations - Usually use numbers stored within cells - Order of precedence applies - To enter a formula: - Type in a cell - Select cells - Verify via F2 *** Press F4 for absolute referencing *** - Formulas can be copied and pasted - Beware of absolute vs. relative references - Can "paste special" in a number of ways - You can view all of the formulas in your worksheet by pressing Ctrl+' - A function is a named operation that returns a value, generally used to simplify formulas - For example the formula: =A1+A2+A3+A4+A5 - Produces the same result as the function: =SUM(A1:A5) - Over 300 functions available for numbers, dates and times. - To enter a functions: - Type - Select cell - Function wizard - AutoSum can be used for Sum, Average, Count, Minimum and Maximum - What makes a good formula? - Use functions when possible -> cleaner - Don't hide data values in formulas - Show intermediate results to make it easier to follow the logic - A variety of actions can be performed on worksheets: - Insert - Delete - Rename - Move - Copy - Tab colour Editing your work - To edit cell contents you enter editing mode: - F2 - Double-Click - Click in the formula bar - Press Enter when done - Press Esc to exit without applying changes
More Less

Related notes for COMPSCI 1BA3

Log In


Don't have an account?

Join OneClass

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

Sign up

Join to view


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.