Search
Create
Log in
Sign up
Log in
Sign up
Spreadsheets (Computer Literacy)
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
Terms in this set (19)
Spreadsheets
a matrix of rows and columns; can have thousands of cells viewed horizontally or vertically.
Excel
Microsoft's version of the spreadsheets.
Worksheet
one page of a workbook; it is a page you can input and compute data on.
File
a document.
File name
The name given to a spreadsheet when it is saved.
Cell
rectangle contained in a spreadsheet; the intersection of a row and a column; text and numbers can be put in these cells.
Active Cell
the selected cell.
Column
spreadsheets are organized into rows and columns, columns are identified by letters of the alphabet and run vertically.
Rows
identified by numbers and run horizontally.
Cell Address
the intersection of a row and column (example: B4).
Formula
an equation that performs various operations within a worksheet.
Ranges of Cells
a rectangle of cells that is selected. (example: A1-A2
Autosum
Spreadsheet function that calculate the sum of the numeric value of all cells specified within a range.
operation signs
is + and for subtraction - and multiplication * and division is / and exponent is ^
Charting
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.
Line Chart
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.
Pie Chart
has the shape of a pie (round) cut into slices, shows the relationship of parts to a whole.
Visicale
The first spreadsheet was (blank)
;