1 / 12

EXCEL 2

EXCEL 2. Types of information can be typed in a cell text numbers formulas functions Text is also known as labels Aligns at the left Numbers are also known as values Aligns at the right. TYPES OF INFORMATION IN EXCEL. The purpose of excel is to compile data

maxine
Download Presentation

EXCEL 2

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. EXCEL 2

  2. Types of information can be typed in a cell • text • numbers • formulas • functions • Text is also known as labels • Aligns at the left • Numbers are also known as values • Aligns at the right TYPES OF INFORMATION IN EXCEL

  3. The purpose of excel is to • compile data • perform calculations • create graphs/charts • Calculations are performed using • formulas - mathematical expressions that you create or enter • functions - mathematical expressions already available in excel EXCEL

  4. To perform calculations an = must be entered first • Formulas containing numbers will produce results that will never change • =3*8 produces the result of 24 • Formulas containing cell references produces results that will change if the data in those cells change. • =A1+B1 will produce results based on the data entered in those cells FORMULAS

  5. It is usually more effective to use a cell reference than entering values in a formula or function • Point-and-click method of entering formulas • use the mouse to select the cells that you want to use to perform the calculations FORMULAS

  6. Operators • Addition + • Subtraction - • Multiplication * • Division / • The sequence used to calculate complex formulas containing more than one operation. • order of operations • parenthesis • multiplication and division • Addition and subtraction ARITHMETIC OPERATORS

  7. Calculate the following equation using order of operations 2nd 1st 1st 2nd = 10 - 5*6 = (10- 5) *6 10-30 = -20 10–5 = 5 * 6 = 30

  8. Functions are built-in formulas • Autosumis a built-in SUM function. • Clicking on the arrow next to the Auto sum • SUM calculates the total in a range of cells • AVERAGE calculates the average in a range of cell • MAX displays highest value in a range of cells • MIN displays smallest value in a range of cells FUNCTIONS

  9. When you use the function button excel will select the range for you • If Excel doesn’t select the right range- select the range you want • ##### sign indicated the numbers are too large for the column • Fix by resizing the column • Label each part of this function: • = Sum(D5:D10) • Equal Sign Function Argument FUNCTIONS

  10. Cell references used to create formulas • Relative – adjusts to its new location when copied • Absolute – Does not change when moved or copied to a new cell • To make a cell reference absolute press F4 and the $ will be entered for you. • $ indicated that a cell is absolute • $A$1 CELL REFERENCING

  11. Formula view • Ctrl + ` • Every worksheet containing formulas must have two pdf files: • Regular • Formula • Both pages in Print Preview must fit on one page. PRINTING

More Related