Home QBASIC C Java HTML
  • More Courses
  • MCQs
  • Blog Download
  • Tools
  • Contact

    MS-Excel Quick Tip 2


    • AND, OR, and NOT are logical operators.
    • AND returns TRUE if all input values or arguments are true.
    • OR returns TRUE if any input value or argument is true.
    • NOT returns TRUE if input value is false, and it returns FALSE if input value ir TRUE.
    • Formula is a sequence of value, cell reference, names, function or operations in a cell that together produce a new value.
    • A formula always begins with an equal sign (=)
    • =SUM(A1:A10) is an example of a formula in Excel.
    • Transpose changes orientation of data row into columns of copied data and vice versa.
    • Pase special is used to copy complex items from an excel worksheet and paste them into the same or another excel worksheet.
    • GOTO is used to go to a specific location within a sheet.
    • Cell reference contains one or more letters or alphabet followed by a number where the letter or alphabet indicates the column and the number represents the row
    • There are 3 types of cell reference in excel. Relative cell references, Absolute cell references and Mixed cell references.
    • Relative cell references: It does not contain dollar signs in a row or column, e.g., A2. Value changes when a formula is copied or dragged to another cell; in Excel, cell referencing is relative by default.
    • Absolute cell references: It contains dollar signs attached to each letter or number in a reference, e.g., $B$4, Here if we mention a dollar sign before the column and row identifiers, it makes absolute or locks both the column and the row, i.e., where Cell reference remains constant even if it copied or dragged to another cell.
    • Mixed cell references in Excel: It contains dollar signs attached to either the letter or the number in a reference. E.g., $B2 or B$4. It is a combination of relative and absolute references.
    • Autofill is automatically filling next value.
    • Auto calculates displays result in status bar of selected range.
    • Autocomplete completes partial word into complete work.
    • Clear format only clear format of cell.
    • Clear content clear only contents but not format of cell.
    • Clear comments clear only comments but not formats and contents.
    • Clear all clear format, formula and contents of cell.
    • Normal view is default view of working view.
    • Page Break preview indicates page separate, printable/nonprintable area, reduces or enlarge printable area and page area.
    • Printable portion displays as white color.
    • Page break line displays on blue color dotted line.
    • Chart (Alt + F11) provides a visual representation of the values contained on a worksheet.
    • Cell with comment has indicator triangles in upper-right corners.
    • Ctrl + 1 is the shortcut key to display the format cell box.
    • Hyperlink itself can be text or picture.
    • By default, in excel text is left align, numbers are right aligned and logical and error values are centered.
    • By default, excel aligns text vertically on the bottom of a cell.
    • Wrap text (Alt + Enter) wraps text into multiple lines in a cell.

    266