Critical Thinking Case-Based Questions
?
Case 5-3
As he prepares his assignment for his Marketing class, Ted goes to his friend Carter for help with PivotTables because Carter has had a lot of experience with them in his job.
?
?
Ted wants to use his PivotTable to show the total value of the motorcycles for a series of motorcycle dealerships but he wants to filter the display to show only those dealers whose total stock of motorcycle is greater than $1 million. How would he accomplish this?
A. He would develop a PivotTable using the aggregate filter.
B. He would develop a PivotTable using the report filter.
C. He would develop a PivotTable using the category filter.
D. He would develop a PivotTable using the value filter.
Answer: D
You might also like to view...
Critical Thinking QuestionsCase B-2Barris has been working on a poster for his band, We Hate Crust, and he's unhappy with the way it looks. For some reason, many of the images he has placed appear to be either pixilated or have rough edges, and he really wants everything to look crisp and clean. Because many of the edges in the poster have a rough and "stair-stepped" appearance, Barris guesses that they're probably not ____.
A. anti-aliased B. aliased C. smoothed D. edited
You can view the Navigation Pane by pressing ________
A) Ctrl + F B) Ctrl + N C) Ctrl + P D) Ctrl + H
In a fixed-width layout, smaller screen resolutions may display ____ depending on the width of the Web page content.
A. menu bars B. object bars C. vertical scroll bars D. horizontal scroll bars
Pre-built collections of formatting choices are called ________
Fill in the blank(s) with correct word