Simple formula click the cell in which you want the

Info icon This preview shows pages 4–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Simple Formula:
Image of page 4

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Click the cell in which you want the answer (result of the formula) to appear. Press enter once you have typed the formula. All formulas start with an = sign. Refer to the cell address instead of the value in the cell e.g. =A2+C2 instead of 45+57. That way, if a value changes in a cell, the answer to the formula changes with it. + means add e.g. A2+C2 Add the value (number) in A2 to the value (number) in C2. - means subtract e.g. A2-C2 Subtract the value (number) in C2 from the value (number) in A2. * means multiply e.g. A2*4 Multiply the value (number) in A2 by 4. / means divide e.g. A2/3 Divide the value (number) in A2 by 3. Functions These formulas are used for working with long lists of numbers. A typical function looks like this: = SUM(A3:A30) SUM is a function, meaning that it sums (adds up) the list of numbers. The list of numbers is indicated in brackets. The address of the first cell in the list is A3. A colon : separates this cell address from the last cell in the list, which is A30. =SUM(B3:B9) Adds list of values from cell B3 to cell B9 =AVERAGE(B3:B9) Averages the values from cell B3 to cell B9
Image of page 5
Other functions: There are many functions that you could explore with time. SUM and AVERAGE are two of the most common, below are a few more: SUM adds the numbers in the list AVERA GE averages the numbers in the list PRODU CT multiplies the numbers in the list MAX identifies the highest number in the list MIN identifies the lowest number in the list COUNT counts the number of numerical items in the list COUNT A counts the number of alphabetical items in the list COUNT IF counts the number of items that satisfy certain criteria e.g. =COUNTIF(A4:A20,">50") counts the number of values that are higher than 50 in the list from A4 to A20 - notice the use of the comma and quotation marks to separate the list (A4:A20) from the criteria (>50). ii. Selecting cells – single and a range of cells iii. Formatting text (General, Number, Currency, date) iv. Centre and merging cells v. Borders
Image of page 6

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
To be continued!
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern