1 / 38

Excel Part 2

2. Excel Part 2. Entering Formulae Using Point Mode. A way of generating formulae using the cell pointer Start formula with = sign Using mouse, click on first cell in formula, note that the cell address Enter numeric operator Click on second cell, that cell address shows in formula

jiro
Download Presentation

Excel Part 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. 2 Excel Part 2

  2. Entering Formulae Using Point Mode • A way of generating formulae using the cell pointer • Start formula with = sign • Using mouse, click on first cell in formula, note that the cell address • Enter numeric operator • Click on second cell, that cell address shows in formula • Press Enter

  3. formula begins with = sign

  4. point to B5 with cell selector

  5. key in numeric operator

  6. point to B6 with cell selector

  7. formula now displays results

  8. Copying Formulae Formulae, like other cell contents, may be copied from one location to another The cell addresses in the source formula, unless specially set up, change as they are copied to the destination cell(s) The cells change because they are relative cell references

  9. SS of copying formulas formula copied

  10. formula pasted

  11. Functions Built-in formulae that perform certain types of calculations automatically Rules of structure, or syntax: Function name (argument1, argument2 …)

  12. Functions Arguments - data the function uses to perform the calculation Most often, arguments are numbers or cell references to numbers Argument enclosed in parentheses, multiple arguments separated by commas

  13. Functions In cells containing both function and formula, begin the function with an = sign Excel has 233 functions, divided into 9 categories

  14. AVERAGE UPPER IF Returns the average of its arguments Converts text to uppercase Returns one value if a condition you specify evaluates to True and another value if it evaluates to False Sample of Functions

  15. PMT TODAY SUM Calculates payment for a loan based on constant payments and interest rate Returns serial number that represents today’s date Adds all the numbers in a range of cells Sample of Functions • Click on Insert then Function

  16. Paste Function Feature Click fx Paste Function Office Assistant will offer help Excel will prompt you with a selection of functions

  17. Paste Function feature

  18. Adding Cell Comments • Can annotate cells with comments • Appear whenever mouse pointer passes over that cell • Click on Insert then Comment

  19. Cell comments

  20. Column Widths • Cell’s column controls how much information can be displayed in a cell • Text entries will “spill over” to the next cell, if empty, otherwise the label is truncated • Numbers too wide for the column will be displayed as ####### • Column widths may be from 1 to 255

  21. Adjusting Column Widths • Click on Format, Column, Width • Click and drag on the column heading border • Format, Column, Autofit or double clicking on heading border will make automatic column width adjustments

  22. Using Undo • For undoing errors • Important safeguard against time consuming errors

  23. Zooming the Worksheet • Screen is defaulted at 100%, the amount that will print on one page, in Portrait orientation • Can adjust screen viewing to • See more, by zooming out, or • See less, by zooming in • Click on View then Zoom

  24. Formatting Numbers • Number formats affect how numbers look onscreen and when printed • No effect on Excel’s storage or values in calculations • Select with Format, Cells, Number

  25. Number formatting

  26. Number formatting

  27. Inserting Rows • Move to appropriate row • Click on Insert, Rows • For multi row insertion, highlight a range of rows before invoking menu command

  28. Moving Cell Contents • Can use the Cut and Paste method or • Move cursor arrow to border of cell pointer, click and drag to the destination location

  29. Centering Across a Selection • Cell alignment, center only applies to entries within an individual cell • Centering across a selection allows users to center selection as they would with a word processor • Click on Format, Cells, Alignment, Horizontal, Center Across Selection

  30. Centering across a selection

  31. Centering across a selection

  32. Changing Fonts and Font Styles • Fonts - typefaces, size and style • Typeface - appearance and character shape • Size - generally measured in points (pts.), pts. are 1/72 of an inch • Arial 10 pt. is the Excel worksheet default • Change by Format, Cells, Font

  33. Format Cells

  34. Typeface Arial Arial Times New Roman Times New Roman Size and style 24 pt. Bold 32 pt. Italic 24 pt. Bold 32 pt. Bold Table of Different Font Styles

  35. Changing Page Orientation • Default printing orientation is Portrait (vertical) • If data to large for this format • Can change to Landscape orientation (horizontal)

  36. Specifying Landscape Orientation Office Assistant

  37. Landscape Orientation

More Related