Scribd Logo
Upload

Welcome to Scribd!

  • 43 views

    What Is A Charts?: Practical Work 5 MS Excel. Spreadsheets&modelling

    Uploaded by

    Zhaniya Abdalieva
    A spreadsheet is a software program used for calculations and modeling data. It contains worksheets made up of cells organized into rows and columns. The active cell is the selected cell where data is entered. Formulas are mathematical equations preceded by an equal sign that calculate results. Charts visually represent data to improve understanding using common charts like pie charts and column charts. Rows and columns provide the structure of the worksheet and are labeled with numbers and letters respectively.

    Copyright:

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

    What Is A Charts?: Practical Work 5 MS Excel. Spreadsheets&modelling

    Uploaded by

    Zhaniya Abdalieva
    43 views3 pages
    A spreadsheet is a software program used for calculations and modeling data. It contains worksheets made up of cells organized into rows and columns. The active cell is the selected cell where data is entered. Formulas are mathematical equations preceded by an equal sign that calculate results. Charts visually represent data to improve understanding using common charts like pie charts and column charts. Rows and columns provide the structure of the worksheet and are labeled with numbers and letters respectively.

    Original Title

    977127.docx

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    A spreadsheet is a software program used for calculations and modeling data. It contains worksheets made up of cells organized into rows and columns. The active cell is the selected cell where data is entered. Formulas are mathematical equations preceded by an equal sign that calculate results. Charts visually represent data to improve understanding using common charts like pie charts and column charts. Rows and columns provide the structure of the worksheet and are labeled with numbers and letters respectively.

    Copyright:

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

    What Is A Charts?: Practical Work 5 MS Excel. Spreadsheets&modelling

    Uploaded by

    Zhaniya Abdalieva
    A spreadsheet is a software program used for calculations and modeling data. It contains worksheets made up of cells organized into rows and columns. The active cell is the selected cell where data is entered. Formulas are mathematical equations preceded by an equal sign that calculate results. Charts visually represent data to improve understanding using common charts like pie charts and column charts. Rows and columns provide the structure of the worksheet and are labeled with numbers and letters respectively.

    Copyright:

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

    Practical work №5 MS Excel.

    Spreadsheets&modelling
    Questions:
    1. What is a spreadsheet?
    2. What is an active cell?
    3. What is a Worksheet?
    4. What is a Formula?
    5. What is a Charts?
    6. What is a Row?
    7. What is a Value?
    8. What is a Column?

    1.A spreadsheet is a piece of software which is used to work out


    calculations.
    But if you learn a little bit about spreadsheets and have a play with them,
    you will soon find out that they can do a whole lot more than simply add up a
    column of numbers. Spreadsheets can handle all of the financial calculations for a
    large business, they can be used to work with statistics and to calculate probability
    or other statistical information, they can do complex trigonometry. Not only that,
    they can also make pretty snazzy graphs and charts that you can use to impress
    people.
    Spreadsheets can also be used as a simple flat-file database.

    2.The active cell is the selected cell in which data is entered when you begin
    typing. Only one cell is active at a time. The active cell is the cell surrounded by a
    black border. Data can only be entered into the active cell. Even if more than one
    cell is selected, there is still only one active cell at a time.
    A cell is the intersection of a row and a column. A row and a column adjoined
    make up a cell.
    You can define a cell by the combination of a row number and a column
    header.For example, below the selected cell is C3. It has a column header C and a
    row number 3.

    3.WORKBOOK & WORKSHEET


    A workbook is a spreadsheet program file that you create in Excel.
    A workbook contains one or more worksheets. A worksheet (also known as a
    spreadsheet) consists of cells in which you can enter and calculate data. The cells
    are organized into columns and rows.
    A worksheet is always stored in a workbook. A workbook can contain many
    worksheeks. Think of it as a book. The book (workbook) usually has a single topic,
    such as your budget. Each page (worksheet) within the book contains part of that
    topic, such as the budget broken down into months.

    4.FORMULA
    A spreadsheet formula is a mathematical equation that will calculate a result.
    Formulas are typed into the formula bar.
    A formula always begins with an equal sign (=). For example the formula =1+1 will
    result in 2 being displayed.
    In spreadsheet formulas, normally we use the cell reference of the data rather
    than the data itself.
    For example: =A1*B1
    =(A1+A2)/B1

    5.Charts are visual representations of data used to make it more understandable.

    Commonly used charts are:

     Pie chart
     Column chart
     Line chart

    6.Rows are labeled with numbers, in the gray area to the left of each row. Click
    the row heading to select an entire row. To increase or decrease the height of a
    row, drag the line below the row heading.

    7.The VALUE Function[1] is categorized under Excel Text functions. It will convert
    a text string that represents a number into a number. Thus, the function will
    convert text that appears in a recognized format (a number, date, or time format)
    into a numeric value.

    In financial analysis, the VALUE function is not used much, as Excel automatically
    converts text to numeric values. However, it is important for anyone who wants
    to master the full extent of Excel functions.

    Formula
    =VALUE(Text)
    Text (required argument) – This is the text enclosed in quotation marks or a
    reference to a cell containing the text you want to convert.

    8.Columns are labeled with letters. The column headings are lettered in the gray
    area at the top of each column. Click the column heading to select an entire
    column. To increase or decrease the width of a column, drag the line to the right
    of the column heading.

    You might also like