Spreadsheet-Software that the paper
spreadsheet environment but makes it fast and easy. A spreadsheet appears on screen as a matrix of rows and columns. Spreadsheet
can have thousands of cells and can be scrolled horizontally or vertically to be viewed.
Excel-Microsoft’s version of spreadsheet
Worksheet-One page of a Workbook. It is the page that you use to input data to organize into information.
Workbook-A file that contains a series of Worksheets
File-a document-in this case a spreadsheet document
Filename-The name given to a spreadsheet document at the time
it is saved.
Active cell-The selected cell
Cell-A rectangle that is contained within a worksheet. Text and numbers and
formulas can be inputted in individual cells.
Column-Spreadsheet
organizes data in columns and rows. Columns are identified by letters of the alphabet and run vertically—that is up
and down
Row- Spreadsheet organizes data in columns and
rows. Rows are identified by numbers and run horizontally-that is left to right or right to left
Cell Address-The intersection of a row and a column
Formula-An equation that performs various operations within a work sheet
Ranges of cells-A rectangle of cells that is selected. For example
cell A1 to cell A5.
AutoSum-A spreadsheet function
that calculates the sum of the numeric value of all cells specified within a range.
Operation sign for addition +
Operation sign for subtraction
–
Operation sign for multiplication
*
Operation sign
for division /
Operation sign for exponentiation ^ (to the power of)
SOME ADVANCED EXCEL VOCABULARY WORDS:
Functions-Predefined
formulas
Fx or Paste Function-Command
to help you enter functions. It’s the function wizard.
Formula
Palette-Assists you in building the formula
Operands-Values
or references to cells containing a value
Operators-Indicates
type of calculation that will take place
Syntax
– Structure or order of the elements (operands and operators) in a formula
Arguments-Terms between the parentheses. Terms in bold are required;
terms not bold are optional