kubicle pivot tables
In this exam's Excel file, sort your Pivot Table by the amount of revenue generated by each fee earner. Where does Gary Krug rank in the firm, based on total revenue generated
6th highest***** 7th highest***** 8th highest***** 9th highest
Which of these formatting options is useful for a Pivot Table that you generally read from left to right
Banded columns***** Comma separators Pivot Table styles Banded rows
Which of these is required when creating a Pivot Table
The data set should have no blank cells***** Each row should have a heading in the left column Each column should have a heading in the top row The data should be arranged in a single column
You create an external formula that adds quarter 1 revenue figures from a Pivot Table for several sales people. What will happen to this formula if you adjust the Pivot Table to show monthly revenue
The formula will return a #REF! error***** The formula will calculate monthly revenue for the salespeople The formula will be replaced with a GETPIVOTDATA function The formula will still add quarterly revenue figures for the salespeople
Which of these steps would you not want to take when creating a Pivot Table
Format the data set as an Excel table***** Create a column heading for each column in the data set***** Arrange the individual data records in rows***** Delete all rows containing any blank cells from the data set
In this exam's Excel file, create a Pivot Chart showing total revenue by fee earner for each client, then filter the client field to show only Shinra Electric Power Company. Which fee earner had the second highest total revenue from Allied Biscuit
Gary Krug***** Devon Lachance***** Naiara Lay Karlie Grady
In this exam's Excel file, add a new column to the dataset calculating the profit from each transaction. The profit of a transaction is its revenue minus its costs, and the costs of a transaction are the breakeven rate multiplied by its time. (Hint: Divide the breakeven rate per hour by 60 to get the breakeven rate per minute) Then add the new Profit column to your Pivot Table, and adjust the table to show total profits by client and month. Which client provided the most profits in October
Nulla Corp***** The Lanford Lunch Box BiffCo Springfield Nuclear Power Plant
In this exam's Excel file, adjust your Pivot Table to show the revenue for each client of each fee earner (Hint: Add the fee earner and client fields to the Rows area, and sort the clients by revenue). Which client did Karlie Grady generate most revenue from
Osato Chemicals***** Rouster and Sideways Atlantic International Airlines Suspendisse Institute
