Preview

The Definition of a Spreadsheet

Powerful Essays
Open Document
Open Document
962 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
The Definition of a Spreadsheet
Robert Roberson
December 1, 2014
Etec 100
Dr. Wilson Chapter 10 ­ Chapter ten introduces the topic of spread other cells.
A spreadsheet consists of a table of cells arranged into rows and columns and referred to by the
X and Y locations. X locations, the columns, are nord sheets, A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form.
Spreadsheets devel computerized oped as 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 model–view–controller element that can contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of mally represented by letters, "A", "B", "C", etc., while rows are normally represented by numbers, 1, 2, 3, etc. A single cell can be referred to by addressing its row and column, "C10" for instance. Additionally, spreadsheets have the concept of a range, a group of cells, normally contiguous. For instance, one can refer to the first ten cells in the first column with the range
"A1:A10". This system of cell references was introduced in VisiCalc, and known as "A1 notation".The ability to chain formulas together is what gives a spreadsheet its power. Many problems can be broken down into a series of individual mathematical step, and these can be assigned to individual formulas in cells. Some of these formulas can apply to ranges as well, like the SUM function that adds up all the numbers within a range.Spreadsheets share many

principles and traits of databases, but spreadsheets and databases are not the same thing. A spreadsheet is essentially just one table, whereas a database is a collection of many tables with machine­readable semantic relationships between them.A spreadsheet program is one of the main components of an office productivity suite, which usually

You May Also Find These Documents Helpful

  • Good Essays

    Listed below is an example of one with the name within it. Left click the box with code inside. Once clicked a bold black box will outline the rectangle of G2 and at the bottom right of the G2 box there will be a small square. Left click and drag down this square until it reaches the last row with data in it. Once the code is dragged down it will be placed into each row in column G of the bolded dragged down area.…

    • 414 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Bsbwor501 Final Exam

    • 397 Words
    • 2 Pages

    (TCO 1) Which of the following describes the function of the Formula Bar (as it applies to Excel…

    • 397 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    BIS115_Quizzes

    • 2722 Words
    • 11 Pages

    Question 2. 2. (TCO 1) In Excel 2010, a sheet tab ________. (Points : 2)…

    • 2722 Words
    • 11 Pages
    Satisfactory Essays
  • Good Essays

    matches the structure/function in the left hand column. A cell part may be used more than once.…

    • 371 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    A database is essentially an electronic filing system. It allows you to quickly select desired pieces of information.…

    • 492 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Accounting 315

    • 1877 Words
    • 8 Pages

    And information or data which may be required by the solution will be entered in cells with borders to help identify them.…

    • 1877 Words
    • 8 Pages
    Good Essays
  • Powerful Essays

    Ap Calculus

    • 2722 Words
    • 11 Pages

    | The identification of a specific cell by its intersecting column letter and row number.…

    • 2722 Words
    • 11 Pages
    Powerful Essays
  • Satisfactory Essays

    Excel Chapter 8 Test

    • 599 Words
    • 10 Pages

    In Solver, a cell that contains a formula for the results you are trying to determine, usually defined as a minimum, a maximum, or a specified value.…

    • 599 Words
    • 10 Pages
    Satisfactory Essays
  • Powerful Essays

    EAS230Syllabus

    • 1748 Words
    • 8 Pages

    Philosophy: Lectures, 2 exams, and 9 project (lab) assignments form the basis for this course. The projects will be extensive, and will require that you attend lab sections so that you can get help from the TAs. Class attendance is mandatory. Speak up in class. Emails, while convenient, do not shift responsibility for handling a problem to the recipient. There's no substitute for face time. Emails which ask questions that are better asked in class, will be actively ignored. This is the University at Buffalo, not the University of Phoenix.…

    • 1748 Words
    • 8 Pages
    Powerful Essays
  • Satisfactory Essays

    Excel Chapter 1

    • 4708 Words
    • 19 Pages

    B) the current cell location of the insertion point as indicated by a dark border.…

    • 4708 Words
    • 19 Pages
    Satisfactory Essays
  • Good Essays

    Intro to Computers

    • 609 Words
    • 3 Pages

    | Allows users to organize data in rows and columns and perform calculations and recalculate when data changes.…

    • 609 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Ss2 Assesment

    • 1737 Words
    • 7 Pages

    1.1 Identify what numerical and other information is needed in the spreadsheet and how it should be structured…

    • 1737 Words
    • 7 Pages
    Powerful Essays
  • Powerful Essays

    SS2 Assessment

    • 2272 Words
    • 11 Pages

    1.1 Identify what numerical and other information is needed in the spreadsheet and how it should be structured…

    • 2272 Words
    • 11 Pages
    Powerful Essays
  • Good Essays

    Macro Examples

    • 1120 Words
    • 5 Pages

    • Select Cell D11 using absolute referencing (do not select the Use Relative Reference button).…

    • 1120 Words
    • 5 Pages
    Good Essays
  • Good Essays

    Scor eStore.com

    • 677 Words
    • 2 Pages

    cells for Page Views, Conversion Rate, Margin, and Monthly Operating Cost. This does not require any…

    • 677 Words
    • 2 Pages
    Good Essays