Scribd Logo
Upload

Welcome to Scribd!

  • 22 views

    Information Technology and Its Application SSK1000 Nur Shazana Binti Sobri ASO5668 Asasi Sains

    Uploaded by

    Princess Darishana
    Spreadsheet software allows users to organize and analyze tabular data in a worksheet. It represents data in a grid of rows and columns where each cell can contain numeric values or text that can be used in formulas to calculate derived values. This allows users to rapidly model "what-if" scenarios. Modern spreadsheets support functions for financial and statistical analysis and conditional expressions. They have largely replaced paper-based accounting systems and are now used wherever data is organized in tables, sorted, and shared. Functions define rules that describe how a change can occur, and common spreadsheet formulas include calculations for sample mean, standard deviation, and variance. Common chart types in worksheets are pie charts, line charts, and bar charts.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Information Technology and Its Application SSK1000 Nur Shazana Binti Sobri ASO5668 Asasi Sains

    Uploaded by

    Princess Darishana
    22 views3 pages
    Spreadsheet software allows users to organize and analyze tabular data in a worksheet. It represents data in a grid of rows and columns where each cell can contain numeric values or text that can be used in formulas to calculate derived values. This allows users to rapidly model "what-if" scenarios. Modern spreadsheets support functions for financial and statistical analysis and conditional expressions. They have largely replaced paper-based accounting systems and are now used wherever data is organized in tables, sorted, and shared. Functions define rules that describe how a change can occur, and common spreadsheet formulas include calculations for sample mean, standard deviation, and variance. Common chart types in worksheets are pie charts, line charts, and bar charts.

    Original Description:

    ssk

    Original Title

    LAB 4 NANA

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Spreadsheet software allows users to organize and analyze tabular data in a worksheet. It represents data in a grid of rows and columns where each cell can contain numeric values or text that can be used in formulas to calculate derived values. This allows users to rapidly model "what-if" scenarios. Modern spreadsheets support functions for financial and statistical analysis and conditional expressions. They have largely replaced paper-based accounting systems and are now used wherever data is organized in tables, sorted, and shared. Functions define rules that describe how a change can occur, and common spreadsheet formulas include calculations for sample mean, standard deviation, and variance. Common chart types in worksheets are pie charts, line charts, and bar charts.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    22 views3 pages

    Information Technology and Its Application SSK1000 Nur Shazana Binti Sobri ASO5668 Asasi Sains

    Uploaded by

    Princess Darishana
    Spreadsheet software allows users to organize and analyze tabular data in a worksheet. It represents data in a grid of rows and columns where each cell can contain numeric values or text that can be used in formulas to calculate derived values. This allows users to rapidly model "what-if" scenarios. Modern spreadsheets support functions for financial and statistical analysis and conditional expressions. They have largely replaced paper-based accounting systems and are now used wherever data is organized in tables, sorted, and shared. Functions define rules that describe how a change can occur, and common spreadsheet formulas include calculations for sample mean, standard deviation, and variance. Common chart types in worksheets are pie charts, line charts, and bar charts.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 3

    INFORMATION TECHNOLOGY AND ITS APPLICATION

    SSK1000
    NUR SHAZANA BINTI SOBRI
    ASO5668
    ASASI SAINS

    LAB 4
    MDM.YONG FAEZAH
    MR. MUHAMMAD ASYRAFF BIN AZWARRUDIN

    GROUP 10

    16TH NOVEMBER 2015

    Part 1 : Understanding

    1. What is Spreadsheet Software?


    A spreadsheet is an interactive computer application program for organization, analysis and
    storage of data in tabular form. Spreadsheets developed as computerized simulations of
    paper accounting worksheets. The program operates on data represented as cells of an
    array, organized in rows and columns. Each cell of the array is a modelview
    controller element[dubious discuss] that may contain either numeric or text data, or the results
    of formulas that automatically calculate and display a value based on the contents of other
    cells.
    Spreadsheet users may adjust any stored value and observe the effects on calculated
    values. This makes the spreadsheet useful for "what-if" analysis since many cases can be
    rapidly investigated without manual recalculation. Modern spreadsheet software can have
    multiple interacting sheets, and can display data either as text and numerals, or in graphical
    form.
    Besides performing basic arithmetic and mathematical functions, modern spreadsheets
    provide built-in functions for common financial and statistical operations. Such calculations
    as net present value or standard deviation can be applied to tabular data with a preprogrammed function in a formula. Spreadsheet programs also provide conditional
    expressions, functions to convert between text and numbers, and functions that operate
    on strings of text.
    Spreadsheets have replaced paper-based systems throughout the business world. Although
    they were first developed for accounting or bookkeeping tasks, they now are used
    extensively in any context where tabular lists are built, sorted, and shared.

    2. What is a Function?
    A function is a rule which operates on an input and produces an output.
    Functions are used to describe the rules which define the ways in which such
    a change can occur.
    3. List three (3) formulas in Mathematical Function.
    a) Sample mean = x = ( xi ) / n
    b) Sample standard deviation = s =[ ( xi - x )2 / ( n - 1 ) ]

    c) Sample variance = s2 = ( xi - x )2 / ( n - 1 )
    4. List three (3) types of chart in worksheet document?
    a) Pie Chart
    b) Line Chart

    c) Bar Chart

    You might also like