BUS 1350 EXAM 2(MODULES 5-8) PROFESSOR SCHAFFER EXAM QUESTIONS & CORRECT ANSWERS

BUS 1350 EXAM 2(MODULES 5-8) PROFESSOR
SCHAFFER EXAM QUESTIONS & CORRECT
ANSWERS
1. Table Styles What is applied to a table in a slide to
format the borders around the table
and cells and to select a color
scheme, preset formatting

2. Filter list arrows Lets you display portions of your data

3. Using check boxes Allows the change in a table's
appearance

4. Type directly below last row to table After pressing [Enter] new row becomes
part of table and formatting extends to
new data

5. [Tab] Add a new row, when active cell is the last
cell
of a table

6. Sort changes how order records are viewed

7. Ascending order lowest value/first in alphabet

8. Descending order highest value/last in alphabet

9. Multilevel sort fields sorted within other fields

10. Calculated columns fills remaining cells with column's
formula

11. Structured reference formulas that refer to table columns by
au- tomatically generated names

14 AutoFilt uses filter list arrows to set
. er 1/
criteria
8

, BUS 1350 EXAM 2(MODULES 5-8) PROFESSOR
SCHAFFER EXAM QUESTIONS & CORRECT
ANSWERS
12. Table total row for calculations using the data in the
table columns

13. Filter displays records meeting user-
specified cri- teria




14 AutoFilt uses filter list arrows to set
. er 1/
criteria
8