BUS 1350 EXAM (RISINGER) QUESTIONS &
DETAILED CORRECT SOLUTIONS
1. When would you paste a copied cell using the
When you want to
Paste Link option?
paste the reference to
the cell and not the
cell's value or format
2. How do you check the status of a link within the current On the
Data tab, in the
workbook to determine whether the link's source file is Queries &
Connections
accessible and up-to- group, click the Edit
date? Link button to open
the Edit Links dialog
box, and then view the
link's status in the
Status column
3. What is a field? A single value that de-
scribes a person, place,
or thing
4. What is a record? A group of related fields
5. Before you can add subtotals to a data Sort the data range by
range, what must you first do with the
or- der the field for which
data?
you want the subtotals
calcu- lated.
With an AND logical
6. When multiple filter buttons are used with
oper- ator
a data range, how are criteria in different
fields combined?
,BUS 1350 EXAM (RISINGER) QUESTIONS &
DETAILED CORRECT SOLUTIONS
7. When would you use an advanced filter in place of the To join
several fields with
filter buttons? an OR logical operator
8. What is the structural reference to the table [#Headers]
header row?
, BUS 1350 EXAM (RISINGER) QUESTIONS &
DETAILED CORRECT SOLUTIONS
9. What are two reasons for using slicers rather than filter Use slicers
when you want
buttons to filter data? 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
10. What are two reasons for using filter buttons
rather than slicers to filter data?
Use filter buttons when
you want to apply text
filter, date filters, and
numeric filters, and
when you want to view
11. Write a formula to calculate the sum of the all of the record in place
filtered values from the Sales Price field in as you filter the data
the Sales_Result table
=SUBTOTAL(9, Sales_Re-
sult[Sales Price])
12. Write a formula to calculate the average of the filtered
=SUBTOTAL(1, Sales_Re-
values from the Sales Price field in the sult[Sales Price])
Sales_Result- table
13. Write a formula to retrieve the value from the=VLOOKUP(B10,
third
field in the Sales_Result table that exactly matches the Sales_Result,
3, FALSE)
lookup value in cell B10
DETAILED CORRECT SOLUTIONS
1. When would you paste a copied cell using the
When you want to
Paste Link option?
paste the reference to
the cell and not the
cell's value or format
2. How do you check the status of a link within the current On the
Data tab, in the
workbook to determine whether the link's source file is Queries &
Connections
accessible and up-to- group, click the Edit
date? Link button to open
the Edit Links dialog
box, and then view the
link's status in the
Status column
3. What is a field? A single value that de-
scribes a person, place,
or thing
4. What is a record? A group of related fields
5. Before you can add subtotals to a data Sort the data range by
range, what must you first do with the
or- der the field for which
data?
you want the subtotals
calcu- lated.
With an AND logical
6. When multiple filter buttons are used with
oper- ator
a data range, how are criteria in different
fields combined?
,BUS 1350 EXAM (RISINGER) QUESTIONS &
DETAILED CORRECT SOLUTIONS
7. When would you use an advanced filter in place of the To join
several fields with
filter buttons? an OR logical operator
8. What is the structural reference to the table [#Headers]
header row?
, BUS 1350 EXAM (RISINGER) QUESTIONS &
DETAILED CORRECT SOLUTIONS
9. What are two reasons for using slicers rather than filter Use slicers
when you want
buttons to filter data? 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
10. What are two reasons for using filter buttons
rather than slicers to filter data?
Use filter buttons when
you want to apply text
filter, date filters, and
numeric filters, and
when you want to view
11. Write a formula to calculate the sum of the all of the record in place
filtered values from the Sales Price field in as you filter the data
the Sales_Result table
=SUBTOTAL(9, Sales_Re-
sult[Sales Price])
12. Write a formula to calculate the average of the filtered
=SUBTOTAL(1, Sales_Re-
values from the Sales Price field in the sult[Sales Price])
Sales_Result- table
13. Write a formula to retrieve the value from the=VLOOKUP(B10,
third
field in the Sales_Result table that exactly matches the Sales_Result,
3, FALSE)
lookup value in cell B10
