ADVANCED SPREADSHEET SKILLS Flashcards
1
Q
Spreadsheet Software
A
allows users to organize data in rows an columns
2
Q
WORKSHEET
A
these rows and columns collectively
3
Q
7 Examples of Spreadsheet Software
A
- LibreOffice Calc
- OpenOffice.org Calc
- Google Sheets
- Apple iWork Numbers
- Kingsoft Office Spreadsheets
- StarOffice Calc
- Microsoft Excel
4
Q
MICROSOFT EXCEL SHORTCUT
A
Press “Windows Logo” + R then type “excel” then enter.
5
Q
ROW
A
horizontal line of entries
6
Q
COLUMN
A
vertical line of entries
7
Q
CELL
A
place where info. is held
8
Q
ACTIVE CELL
A
the selected cell
9
Q
COLUMN HEADING
A
the box at the top of each column containing a letter
10
Q
ROW HEADING
A
the row number
11
Q
CELL REFERENCE
A
the cell address of the cell
12
Q
MERGE
A
combining or joining two or more cells
13
Q
FORMULA
A
is an expression which calculates the value of a cell
14
Q
FUNCTIONS
A
are predefined formulas
15
Q
FORMULA BAR
A
the bar that displays the contents of a cell
