chapter 4 Flashcards
1
Q
Hiding
A
portion of a workbook lets you show only the parts of a workbook that the users need to see
2
Q
Print area
A
the range of cells within a worksheet that will print
3
Q
SUBTOTAL function
A
A predefined formula that calculates a total in a range, table or database
4
Q
Field
A
The smallest element contained in a table such as first name, last name and address e.t.c
5
Q
Table
A
A structure that organizes the data into rows and columns
6
Q
Hyperlink
A
a clickable string of text or object, when clicked it displays another worksheet.
7
Q
Duplicate remover
A
Removes duplicate data
8
Q
NPER
A
returns the total number of payments or deposits you make in a period
