Skip to main content
Workforce LibreTexts

4.1: What is a Spreadsheet?

  • Page ID
    14240
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)

    A spreadsheet is a collection of data that is organized into rows and columns. Microsoft® Excel is a spreadsheet application used to store and analyze quantitative data. An Excel file is called a workbook, and it is saved with an .xlsx extension. A workbook file consists of one or more worksheets which consists of many columns and rows. Columns are the vertical part of a worksheet grid identified by letters. Rows are the horizontal part of a worksheet grid identified by numbers. The intersection of a row and column is called a cell. Each cell can store a single item of data. The data can contain text, numbers, formulas, and/or functions. Clicking a cell with the mouse pointer will make the selected cell the active cell. The active cell’s contents are displayed in the formula bar.

    Typical uses for Excel include:

    • Accounting reports (Balance Sheets, Income Statements, etc)
    • Budgets
    • Calendars
    • Checklists and task lists
    • Contact/Address lists
    • Expense tracking
    • Inventory control
    • Invoices
    • Mortgage and other financial calculations
    • Operational statistics
    • Sales price lists, forecasts and analysis

    4.1: What is a Spreadsheet? is shared under a CC BY-NC-SA 4.0 license and was authored, remixed, and/or curated by Marcus Lacher via source content that was edited to conform to the style and standards of the LibreTexts platform; a detailed edit history is available upon request.