Spreadsheets - Microsoft Excel

SPREADSHEETS MICROSOFT EXCEL By Humphrey Kumwembe OBJECTIVES Managing worksheet content Copying, cutting and pasting content Cell auto fill Data and Content formatting

Cells Columns and Rows Auto formatting Fundamentals of formulas Types of formulas Creating and editing formulas Auto sum Managing worksheet content Copy, Move and Paste content/Data Copy feature Used to copy data from

one area of worksheet to another area in the same or another worksheet. Select a cell or range of cells and then use the following ways to copy: 1. Ribbon Clipboard copy icon 2. Shortcut Ctrl + C 3. Mini toolbar MINI TOOLBAR Managing worksheet content (Cont..)

Move or Cut feature Removes data from a worksheet. Select a cell or range of cells and then use either one of the following to move data: 1. Ribbon Clipboard copy icon 2. Shortcut Ctrl + X 3. Mini toolbar Managing worksheet content (Cont..)

Paste feature Places data copied or cut on another worksheet area . Select a cell or range of cells and then use either one of the following to paste data: 1. Ribbon Clipboard copy icon 2. Shortcut Ctrl + V 3. Mini toolbar Managing worksheet content (Cont..)

Auto fill feature: Automatic filling of data that follows a certain pattern in selected cells Uses the fill handle . Once data has been automatically filled an auto fill option button is displayed on the right corner of the last selected cells. There some preset series that are used with a fill handle i.e. Months

Data and Content formatting Cells Fonts and Text formatting Found on Home tab, under font Category Use font styles i.e. Bold, Italic, Underline. Font Size Font Color Borders and shading Found on Home Tab, under font Category Borders use borders icon

Shading use fill color Text alignment Found on Home Tab, under Alignment Category Categorized into: Top, middle, bottom, left, right and center. Wrap text: This will Merge cells Format painter Data and Content formatting

(Cont.) Rows and Columns Adjusting width and height Auto-fitting columns and rows Inserting and deleting columns and rows Freezing and unfreezing columns and rows FORMULAS An equation that calculates a new value from values currently in a

worksheet. Three types: Text based: uses operators like & Numeric based uses operators like +, Follows the BODMAS rule. Logical based uses comparison operators like > < >= signs FORMULAS (Cont...) Creating and Editing formulas

A formula starts with an = sign Use a formula bar or cell to create or edit a formula Made up of elements: 1. Reference: Cell or range used in the formula 2. Operators: Symbols that specify the calculation to be performed i.e. +, -, /, * 3. Constants: Number or text that do not change 4. Functions: Predefined formula An example = A1+A3, =A1&A2

FORMULAS (Cont...) Auto sum feature Is a shortcut provided for using the SUM function. AutoSUM's rules for selecting a range The order that AutoSUM follows in suggesting a range of data for the function is: The uninterrupted group of cells containing data above the active cell. The uninterrupted group of cells containing data to the left of the active cell. If there is no data in the cells above or to the left,

AutoSUM doesn't select a range, but waits for you to do so. FUNCTIONS FUNDAMENTALS A Function is a predefined formula. Like a formula a function starts with an equal sign (=). Syntax: = function name followed by arguments.

Recently Viewed Presentations

  • Evolution in Action

    Evolution in Action

    This leads to a close relationship RATE OF EVOLUTION Phyletic gradualism: populations of species diverge slowly by accumulating differences in response to the environment Punctuated Evolution: most populations of species go through long periods of stasis (not changing) then a...
  • Overtime Regulations and System-Wide Pay Plan What is

    Overtime Regulations and System-Wide Pay Plan What is

    Time spent answering e-mail that amounts to more than de minimus (insubstantial or insignificant) amounts of time each week is considered work time and must be reported in TimeTraq. Regardless of whether overtime was approved, the employee must be paid...
  • Glass FiberReinforced Polymer (GFRP) Composite Wicket Gates for

    Glass FiberReinforced Polymer (GFRP) Composite Wicket Gates for

    Timber wicket gates provide an opportunity for the use of FRP composites. About 2/3 the cost of timber gates on a first cost basis. Expected life > 50 years (timber gate is ~15 years). Future Opportunities -- Even with limited...
  • Introduction to Financial Management

    Introduction to Financial Management

    Bidders A, B, C, and D will get shares. 15-* Green Shoe Provision "Overallotment Option" Allows syndicate to purchase an additional 15% of the issue from the issuer Allows the issue to be oversubscribed Provides some protection for the lead...
  • Sales Training - San Jose State University

    Sales Training - San Jose State University

    Sample Time. Need to call at a regular interval. Use millis() or an interrupt (cont.) On lines 10&11, the algorithm now decides for itself if it's time to calculate. Also, because we now KNOW that it's going to be the...
  • Angle Relationships - California State University, Northridge

    Angle Relationships - California State University, Northridge

    They are vertical to one and other. Which are alternate interior angles? Alternate Exterior Angles Very similar to alternate interior angles, except on the outside of the parallel lines. Congruent angles. Angle Relationships Mr. Barrios 4/21/08 Point A point is...
  • Math for America San Diego A Consortium of

    Math for America San Diego A Consortium of

    Research Findings Program Elements Inadequate compensation New teachers feel isolated "Bureaucratic impediments" Provide $15,000 stipend Create professional community, mentor Mentor, work with principal, and math department lead Modeled on Pilot Program in NYC Founded in 2004, ~200 Fellows in NYC...
  • OER in Australia

    OER in Australia

    2007 - 2010: GILF project continues as a Queensland Government-QUT collaboration, developing knowledge about and models for use of CC on PSI . 2007 on: Australian Bureau of Statistics (ABS), Geoscience. Australia (GA), Bureau of Meteorology (BoM