Advanced and Complex Formulas and Computations Flashcards
a tool that is used to
store, manipulate, and analyze data. Data in a spreadsheet is organized in a series of rows and columns and can be searched, sorted, calculated, and used in a variety of charts and graphs.
Spreadsheet Software
Spreadsheet Software Examples
*LibreOffice Calc
*OpenOffice.org Calc
*Google Sheets
*Apple iWork Numbers
*Kingsoft Office Spreadsheets
*StarOffice Calc
*Microsoft Excel
horizontal line of entries in a table
Row
vertical line of entries in a table
Column
the place where info. is held in a spreadsheet
Cell
the selected cell
Active Cell
the box at the top of each column containing a letter
Column Heading
the row number
Row Heading
the cell address of the cell usually combine letter and number (ex. A1, B4, C2)
Cell Reference
combining or joining two or more cells
Merge
is an expression that calculates the value of a cell.
- Cells Formula
are predefined formulas and are already available in Excel
Functions
the bar that displays the contents of a cell
Formula Bar
returns the sum of x and y or (all the numbers within the range)
Basic Math Operations (Functions)
=SUM(x,y) or =SUM(range)
returns the product of x and y
Basic Math Operations (Functions)
=PRODUCT(x,y)
returns the quotient of x divided by y
Basic Math Operations
=QUOTIENT(x,y)
returns the difference of x subtracted by y
Basic Math Operations
=x-y
returns the sum of x and y
Basic Math Operations
=x+y
returns the product of x and y
Basic Math Operations
=x*y
returns the quotient of x divided by y
Basic Math Operations
=x/y