Transcript Formulas
Excel Lesson 2 MOAC Lesson 2 - Working with Excel and Formulas Excel Lesson 2 √ Formatting √ Other Terms AutoFormat autofit commas cell style currency labels general format values Merge and Center indent percent rotated text or text orientation border wrapping text row height ###### column width Format Painter cell alignment • • • • • • top Bottom left right, Center middle Font, font size, font style Formulas Cell Size Autofit is an Excel feature that will automatically size a cell to accommodate the longest entry without wasting space. Cell size can also be adjusted using row height and column width. Terms Aligning Text causes the text to be placed in a specific position within the cell. ◦ Text can be aligned vertically using: Top Middle Bottom ◦ It can be aligned horizontally using; Left Right Center Text Indenting Text is text that is has been moved over from the left. Rotating Text or Changing Text Orientation is a feature that is useful to make the headings go up and down or diagonally. Wrapping Text causes a new line to begin within the cell of a worksheet when the data exceeds the width of the column. Fonts A font is the design of text. ◦ Calibri is the default font. ◦ This PowerPoint’s font is Gills San MT. ◦ Algerian, Comic Sans MS, Harrington and many other fonts are available for you to chose from. ◦ Use standard fonts like Calibri, Arial, Times New Roman for regular work. ◦ Use the decorative fonts for special purposes only. Font size determines the size of the text. ◦ Fonts size is measured in points. ◦ The default size is 11 points. You can change font styles, which include Bold Shadow Italic Strikethrough Underline Other Formatting Border places a line around a cell or range of cells. Merge and Center combines several cells into one cell and places the text in the middle of the merged cell. Themes and Styles AutoFormat is a collection of font, patterns, and alignments that can be applied to a range of data that is used in Office. ◦ These include a predefined look both for the data and headings. ◦ In Excel , you can also use themes and styles. Format Painter and Cell Style As in Word, Format Painter is an easy way to copy formatting from one cell to another. This is especially helpful when the cell contains several formats. A cell style is a collection of formatting characteristics you apply to a cell or range of cells. You can also clear cell formats not wanted. Types of Number Formats Number Formats change the way the data looks in the cell. ◦ General is the default format for data in a cell. ◦ Currency is the format that displays numerical data so that it is preceded by a dollar sign, such as $4.85. ◦ Percent will display the number .60 as 60.0%. ◦ Commas is the format that displays numbers over 999 with commas in appropriate locations, such as 1,950. What is #######? ###### means the cell is too narrow to display the answer. This happens usually when you add formatting to a cell and all of a sudden the ##### appears because the $, commas, % make the data wider than the cell. Formula Features Formulas are equations that perform calculations on values in your worksheet. • • In Excel, formulas begin with =. Autosum adds the values that are contained in a range of cells. • • ∑ is the symbol that indicates the AutoSum feature. Sum is a function used to add the values that are contained in a range of cells. • • =SUM(B4:B8) Operators and Operands Operator - Symbols such as *, +, -, and / are examples of operators. = B4 * 8 * is an operator. Operand – The numbers or cell references used in formulas. ◦ = B4 * 8 B4 and 8 are operands. Order of Operations • Also called Order of Evaluation The order of evaluation (order of operation) in order is 1. Parenthesis 2. Exponents 3. Multiplication/division 4. Addition/subtraction P E MD AS Please Excuse My Dear Aunt Sally! Be able to solve formulas: =5 * 4 +2 = 22 =5 * (4 + 2) = 30 =2 + 10 / 2 =7 =(2 + 10) / 2 =6 =2^2 + 4 =8