Spreadsheets - Microsoft Excel

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

  • Elements of Drama

    Elements of Drama

    Theater Arts What Is Drama? What Is Drama? Origins of Drama The word drama comes from the Greek verb dran, which means "to do." The earliest known plays . . . were written around the fifth century B.C. produced for...
  • Chapter 6 Race and Color Discrimination Copyright 2019

    Chapter 6 Race and Color Discrimination Copyright 2019

    Management Tips . Believe that race discrimination occurs and be willing to investigate it when it is alleged. Make sure that there is a top-down message that the workplace will not tolerate race discrimination in any form. Do not shy...
  • The Theory of Production - Baylor University

    The Theory of Production - Baylor University

    The Theory of Production The production process One variable input Two or more variable inputs Optimal combination of inputs Economic region of production Production Functions Transformation of inputs to output Basis for all cost analysis Short-run (at least one fixed...
  • This work was supported by grants HKUST 6081/01E

    This work was supported by grants HKUST 6081/01E

    Complex query evaluation 27 Nov, 2001 Indexing Spatio-Temporal Data Warehouses Dimitris Papadias, Yufei Tao, Panos Kalnis, Jun Zhang Department of Computer Science Hong Kong University of Science and Technology Clear Water Bay, Hong Kong 26, Feb, 2002 Outline Preliminary -...
  • PowerPoint プレゼンテーション

    PowerPoint プレゼンテーション

    HIC difference between dynamic and static condition at the start timing of overshoot was virtually confirmed. Time. Bonnnet Lift. Intended Height. TRT. Lift of actuator. Lift of Bonnet. Actual HIT for this condition. Car model and detailed simulation condition. Schematic...
  • Years, days, and months Monday Named for :

    Years, days, and months Monday Named for :

    Wednesday. Named for : Woden, Old English . for the planet Mercury. Woden's. Day.
  • HL7 Care Plan and Ordersets HL7 Patient Care

    HL7 Care Plan and Ordersets HL7 Patient Care

    Project Summaryalso definition of the Plan of Care. The Care Plan structure is used to define the management action plans for the various concerns identified for the target of care.. It is the structure in which the care planning for...
  • Sickle Cell Anemia Thalassemia

    Sickle Cell Anemia Thalassemia

    What is SSD? SSD is an autosomal recessive disorder of a point mutation in the beta globulin chain in hemoglobin. SSD is an autosomal recessive disorder of a point mutation in the beta globulin chain in hemoglobin.