Spreadsheet-Theory Flashcards
1
Q
Column
A
- Vertical Strips of SS
- Identified by letters, top
- Called Column Header
2
Q
Cell
A
- Intersection of row and column
* Activated by clicking on it
3
Q
Formula Bar
A
Data or formulae can be entered directly into the active cell or entered into the formula bar. If you click on a cell that already has a formula, then it will be displayed in the formula bar.
4
Q
Name Box
A
Located before the formula bar and lists the location of the active cell.
5
Q
Worksheet
A
Grid of rows and columns.
6
Q
Workbook
A
Contains one or more worksheets.
7
Q
Scroll Bars
A
These components help to scroll the content and body of the spreadsheet. There are horizontal and vertical scroll bars.
8
Q
Address
A
- Each cell is identified by reference/address
- Format: Columnno.Rowno.
- Eg: B1, C15
9
Q
Active Cell
A
Cell with a dark boundary which is ready for entering or editing data.
10
Q
A range of cells
A
A group of adjacent cells which looks like a square or a rectangle.
11
Q
+
A
Addition
12
Q
-
A
Subtraction
13
Q
*
A
Multiply
14
Q
/
A
Divide
15
Q
%
A
Percentage
