Spreadsheets (Computer Literacy)
Terms in this set (19)
a matrix of rows and columns; can have thousands of cells viewed horizontally or vertically.
Microsoft's version of the spreadsheets.
one page of a workbook; it is a page you can input and compute data on.
The name given to a spreadsheet when it is saved.
rectangle contained in a spreadsheet; the intersection of a row and a column; text and numbers can be put in these cells.
the selected cell.
spreadsheets are organized into rows and columns, columns are identified by letters of the alphabet and run vertically.
identified by numbers and run horizontally.
the intersection of a row and column (example: B4).
an equation that performs various operations within a worksheet.
Ranges of Cells
a rectangle of cells that is selected. (example: A1-A2
Spreadsheet function that calculate the sum of the numeric value of all cells specified within a range.
is + and for subtraction - and multiplication * and division is / and exponent is ^
a major function of spreadsheets. It depicts the data in a graphical form. A visual depiction of the data through charts often makes it easier to read and understand the relationship between the numbers.
shows a trend during a period of time, as indicated by the rising or falling of the line.
Column/ Bar Chart
displays bars of various lengths to show the relationship between data; bars can be vertical, horizontal, or stocked.
has the shape of a pie (round) cut into slices, shows the relationship of parts to a whole.
The first spreadsheet was (blank)