SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

Understanding Types of Information and Formulas in Excel

maxine avatar
maxine
12 diapositives · 264 Views · Aug 05, 2014

Excel is a powerful tool for compiling data, performing calculations, and creating graphs or charts. In a cell, you can input three types of information: text (or labels), numbers (values), and formulas. Text aligns left while numbers align right. Formulas use mathematical expressions to calculate results, often incorporating cell references for dynamic updates. You can perform calculations using operators and built-in functions like SUM, AVERAGE, MAX, and MIN. Learning to effectively use Excel's functions and formulas enhances data management and analysis.

#understanding types of information and formulas in excel #understanding types of information and formulas in excel ppt #powerpoint #presentation
Understanding Types of Information and Formulas in Excel - slide 1
01 / 12Understanding Types of Information and Formulas in Excel
1 / 17

Télécharger la présentation

Understanding Types of Information and Formulas in Excel
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  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