Chapter Four Flashcards
(7 cards)
1
Q
What condition is used when multiple criterion are entered on different rows in the criteria range of an Advanced Filter?
A
OR condition
2
Q
When you first create an Excel table, what name does Excel give it initially?
A
TableN, where N is a number
3
Q
What would a text file be called that uses a character, such as a comma or a tab, to separate the fields?
A
delimited text file
4
Q
What symbol precedes all structured references in Formula AutoComplete lists?
A
@
5
Q
What is another name for rows that alternate shading on the rows?
A
Banded Rows
6
Q
When you sort a cell range using A to Z or Z to A, what is rearranged?
A
complete rows of data
7
Q
What is a cross tabulation report based on list-type data?
A
PivotTable
