Class Notes (839,150)
Canada (511,218)
COMP 1010 (53)
Lecture 35

COMP 1010 Lecture 35: Lecture 35
Premium

2 Pages
46 Views

Department
Computer Science
Course Code
COMP 1010
Professor
James E.Young

This preview shows 80% of the first page. Sign up to view the full 2 pages of the document.
Description
lc82 o If you simply COPY the number from D8 to another cell, no relationship would exist and the duplicate would not change if D8 does Copying and pasting is one of the most common causes of errors on a spreadsheet Formulas keep numbers live, preventing them from getting out of sync when parts change Excel also allows you to refer to numbers on a different worksheet o E.g. =Financials!D8, to duplicate the value from the financials sheet in cell D8 to your current cell Another way to do this is to copy D8 from that sheet and paste it to your sheet using EditPaste Special and clicking the Paste Link button o This is NOT the same as the regular paste or paste hyperlink option You can also use a more complex formula, e.g. =Financials!D8*C7, to multiply D8 on financials with C7 from your current worksheet The one place you could not use =D8, is in the cell D8 itself o There is no way to calculate the answer o It is a circular reference error Circular reference can be indirect too Would occur if you used =D8 for cell C7, and the formula in D8 was =C7 Mathematical Operator Formulas Name Symbol Example Priority 2 Exponential ^ 10^2 is 10 or First (power) 100 Multiplication * 10*2 is 10x2 or Second 20 Division 102 is 5 Addition + 10+2 is 12 Last Subtraction 102 is 8 Follow the order of operations, when to priorities are tied, begin with calculation on left o BEDMAS = brackets, exponents, division, multiplication, addition, subtraction Complicated Formulas Functions are used inside a formula Function = a calculation applying to one of more arguments Can use a function alone, e.g. =AVERAGE(A1, B3, C8) Or can use it as part of another calculation, e.g. =AVERAGE(A1, B3, C8)*12 Functions can be combine with other functions, e.g. =ROUND(AVERAGE(A1, B3, C8),1) o Rounds the average of the three cells to one decimal place Nested function = using one function as an argument for another
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