Class Notes (806,882)
Dr.Hurst (27)
Lecture

# Notesolutions COMP SCI 1B03 Lecture 2B.docx

2 Pages
128 Views

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

Description
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

OR

Don't have an account?

Join OneClass

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

Join to view

OR

By registering, I agree to the Terms and Privacy Policies
Just a few more details

So we can recommend you notes for your school.