(Ch.5 10) Currently, the House Types field is in the ROWS area, the Real Estate Agent
field is in the COLUMNS area, and Sum of List Prices is in the VALUES area. How can
you modify the PivotTable to display the agent names as subcategories within the
house types in the first column?
Give this one a try later!
Drag the Real Estate Agent field from the COLUMNS area and drop it
below the House Types field in the ROWS area.
(Ch.7 3) Your workbook contains a list of artwork. Column B lists Sold Out if the piece
is sold out, Available if it is still readily available, or Limited if only a few pieces are
available. In the third column, you want to display TRUE if the art is not sold out. What
function would produce the same results as =OR(B1="Available", B1="Limited")?
Give this one a try later!
, =NOT(B1="Sold Out")
(Ch.5 9) You have created a PivotChart showing sales by quarter by sales rep. Before
presenting it to management, you notice the name of a rep who has since been fired.
How do you remove this rep from the chart without deleting the data?
Give this one a try later!
Filter the Sales Rep field in the PivotChart and deselect the employee's
check box.
(Ch.7 4) A workbook contains a list of members in the Computer Club. You want to
identify the number of students who are freshmen who are Information Systems
majors. Without filtering the dataset, what function should you use?
Give this one a try later!
DCOUNT
(Ch.6 4) This tool calculates the value required in a single cell to produce a desired
result within a related cell.
Give this one a try later!
Goal Seek
field is in the COLUMNS area, and Sum of List Prices is in the VALUES area. How can
you modify the PivotTable to display the agent names as subcategories within the
house types in the first column?
Give this one a try later!
Drag the Real Estate Agent field from the COLUMNS area and drop it
below the House Types field in the ROWS area.
(Ch.7 3) Your workbook contains a list of artwork. Column B lists Sold Out if the piece
is sold out, Available if it is still readily available, or Limited if only a few pieces are
available. In the third column, you want to display TRUE if the art is not sold out. What
function would produce the same results as =OR(B1="Available", B1="Limited")?
Give this one a try later!
, =NOT(B1="Sold Out")
(Ch.5 9) You have created a PivotChart showing sales by quarter by sales rep. Before
presenting it to management, you notice the name of a rep who has since been fired.
How do you remove this rep from the chart without deleting the data?
Give this one a try later!
Filter the Sales Rep field in the PivotChart and deselect the employee's
check box.
(Ch.7 4) A workbook contains a list of members in the Computer Club. You want to
identify the number of students who are freshmen who are Information Systems
majors. Without filtering the dataset, what function should you use?
Give this one a try later!
DCOUNT
(Ch.6 4) This tool calculates the value required in a single cell to produce a desired
result within a related cell.
Give this one a try later!
Goal Seek
