Spreadsheets Flashcards
1
Q
Spreadsheets
A
- Spreadsheets are practically a good choice of software when you want to work with numbers & display results in graphs.
- Spreadsheets are widely used in finance-related tasks such as preparing BUDGETS,PAYROLL, FINANCIAL STATEMENTS & INVOICES. They also have advanced features such as “FUNCTIONS” to complete special tasks.
- The most popular spreadsheet software used is Microsoft Excel
2
Q
Active Cell (Spreadsheet Terminology)
A
- A cell in a worksheet in which you type data (number or text)
3
Q
Columns (Spreadsheet Terminology)
A
- Run from top to bottom (vertically)
- Each column has an alphabetic heading at the top
4
Q
Rows (Spreadsheet Terminology)
A
- Run from left to right (horizontally) on the worksheet
- Row headings are numbers on the left
5
Q
Cell Reference/ Address (Spreadsheet Terminology)
A
- these tell you where the cells are located.
- They are a combination of column headings & row headings. Eg. C3, A7
6
Q
Record (Spreadsheet Terminology)
A
- A series of data in a row
7
Q
Label (Spreadsheet Terminology)
A
- A cell that contains text or a combination of numbers & text (or only numbers that canNOT be used in a calculation)
- Label canNOT be used for calculations
8
Q
Value (Spreadsheet Terminology)
A
- A number in a cell that can be used in spreadsheet calculations
9
Q
Range (Spreadsheet Terminology)
A
- A group of two or more cells in a worksheet.
- A range is identified by the cell references of the cell in the upper left & lower right corners of the range
10
Q
Formula (Spreadsheet Terminology)
A
- A mathematical equation that will calculate a result
- A formula in spreadsheet always begins with an equal sign
11
Q
Function (Spreadsheet Terminology)
A
- considered as a pre-programmed formula (already in spreadsheet)
Eg. The SUM function
12
Q
Worksheet (Spreadsheet Terminology)
A
- consists of cells in which you can enter & calculate data.
- It is essentially the work space
