IT-Computing Science Flashcards
Spreadsheet
A spreadsheet is a document that stores data in a table of rows and columns. A spreadsheet assigns each column a letter (A-Z at first, then AA, AB, AC, etc.) and each row a number (1, 2, 3, etc.). It identifies each cell by its column and row (A1, B4, D8, etc.).
Data
Data is collected and analyzed; data only becomes information suitable for making decisions once it has been analyzed in some fashion.
Information
Information is an abstract concept that refers to something which has the power to inform.
Cell
A cell is a specific location within a spreadsheet and is defined by the intersection of a row and column.
Cell reference
A cell reference, or cell address, is an alphanumeric value used to identify a specific cell in a spreadsheet. Each cell reference contains one or more letters followed by a number. The letter or letters identify the column and the number represents the row.
Primary source
A first-hand piece of information.
Secondary source
A piece of information which is from a second-hand source. E.G. He went to the shops and bought a screwdriver, he tells me. this is secondary because it has been told by more than 2 people.
Auto-fill
Auto-fill is a function where the computer makes an educated guess as to the answer to the questions based on the first input. It guesses correctly if the input is multiplied / divided / added / subtracted by the SAME number or cell contents as the first calculation summed.
SUM
Is the way to add two or more cells or a column/row together.
COUNTA
The COUNTA function counts the number of cells that are not empty in a range.
MIN and MAX
The MIN function allows you to find the minimum (lowest) value while the MAX function allows you to find the maximum (highest) value in any given range of values.
AVERAGE
Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.
IF
IF is used to check whether a condition is met, and returns one value if TRUE and another value if FALSE.
COUNTIF
COUNTIF is used to count the number of cells in a range that meet a certain criteria.
Graph
In spreadsheets, a graph is a visual representation of data from a worksheet. Graphs help you understand the data in a worksheet by displaying patterns and trends that are difficult to see in the data. They are used to illustrate trends over time, and charts illustrate patterns or contain information about frequency.
