BUS 1350 FINAL EXAM MODULES 6-7, 9 & 11
QUESTIONS & DETAILED COMPLETE SOLUTIONS
1. What is a field? What is a record? A field is a single value that describes a
person, place,
or thing. A record is a group of related fields.
2. If you split the worksheet Four panes are created.
into panes at cell E3, how
many panes are created?
3. What are the three freeze pane op- Freeze panes for panes placed at the top and
left of
the worksheet's top, and Freeze First Column to freeze the
worksheet's first column.
the se- lected range will be highlighted by the conditional
4. When highlighting for-
duplicate val- ues with a
conditional format, do
the duplicate values have to be ad- mat rule.
jacent to each other?
5. Why is it not a good idea for a com- In a large enough company, there is a risk
that two
ords with duplicate first and last field? Which is the
names as duplicate records? secondary sort field?
6. When an ascending sort
order is used, how is a date-
time field sort- ed?
7. If you want to sort
employees by the value of
the Hire Date field within
each value of the Dept field,
which field is the primary sort
1/
49
,BUS 1350 FINAL EXAM MODULES 6-7, 9 & 11
QUESTIONS & DETAILED COMPLETE SOLUTIONS
Dept is the primary sort field; Hire Date is the secondary sort field.
8.
2/
49
,BUS 1350 FINAL EXAM MODULES 6-7, 9 & 11
QUESTIONS & DETAILED COMPLETE SOLUTIONS
Sort the data range by order the field for which you
do want the subtotals calculated.
9. What happens to worksheet They are hidden in the worksheet, but the data is not
rows that do not match the removed.
filter crite- ria? What happens
to the data they contain?
10. When multiple filter buttons
With an AND logical operator
are used with a data range,
how are cri- teria in different
fields combined?
11. When would you use an To join several fields with an OR logical operator
advanced filter in place of the
filter buttons?
The formatting adjusts to retain the banded row
12. To join several fields with an ettect.
OR logical operator
13. What is the reference to Employees[Income]
the In- come field from the
Employees table?
14. What is the formula to calculate the =AVERAGE(Employees[Income])
average of the Income field
from the Employees table?
15. What is the structural reference filter buttons to filter data?
to the table header row?
16. What are two reasons for
using slicers rather than
3/
49
,BUS 1350 FINAL EXAM MODULES 6-7, 9 & 11
QUESTIONS & DETAILED COMPLETE SOLUTIONS
[#Headers]
Use slicers when you want to filter the data into a
few distinct categories that can be easily listed
within the slicer and when you want to perform
the filter on a separate worksheet from the data.
4/
49
QUESTIONS & DETAILED COMPLETE SOLUTIONS
1. What is a field? What is a record? A field is a single value that describes a
person, place,
or thing. A record is a group of related fields.
2. If you split the worksheet Four panes are created.
into panes at cell E3, how
many panes are created?
3. What are the three freeze pane op- Freeze panes for panes placed at the top and
left of
the worksheet's top, and Freeze First Column to freeze the
worksheet's first column.
the se- lected range will be highlighted by the conditional
4. When highlighting for-
duplicate val- ues with a
conditional format, do
the duplicate values have to be ad- mat rule.
jacent to each other?
5. Why is it not a good idea for a com- In a large enough company, there is a risk
that two
ords with duplicate first and last field? Which is the
names as duplicate records? secondary sort field?
6. When an ascending sort
order is used, how is a date-
time field sort- ed?
7. If you want to sort
employees by the value of
the Hire Date field within
each value of the Dept field,
which field is the primary sort
1/
49
,BUS 1350 FINAL EXAM MODULES 6-7, 9 & 11
QUESTIONS & DETAILED COMPLETE SOLUTIONS
Dept is the primary sort field; Hire Date is the secondary sort field.
8.
2/
49
,BUS 1350 FINAL EXAM MODULES 6-7, 9 & 11
QUESTIONS & DETAILED COMPLETE SOLUTIONS
Sort the data range by order the field for which you
do want the subtotals calculated.
9. What happens to worksheet They are hidden in the worksheet, but the data is not
rows that do not match the removed.
filter crite- ria? What happens
to the data they contain?
10. When multiple filter buttons
With an AND logical operator
are used with a data range,
how are cri- teria in different
fields combined?
11. When would you use an To join several fields with an OR logical operator
advanced filter in place of the
filter buttons?
The formatting adjusts to retain the banded row
12. To join several fields with an ettect.
OR logical operator
13. What is the reference to Employees[Income]
the In- come field from the
Employees table?
14. What is the formula to calculate the =AVERAGE(Employees[Income])
average of the Income field
from the Employees table?
15. What is the structural reference filter buttons to filter data?
to the table header row?
16. What are two reasons for
using slicers rather than
3/
49
,BUS 1350 FINAL EXAM MODULES 6-7, 9 & 11
QUESTIONS & DETAILED COMPLETE SOLUTIONS
[#Headers]
Use slicers when you want to filter the data into a
few distinct categories that can be easily listed
within the slicer and when you want to perform
the filter on a separate worksheet from the data.
4/
49
