Pivot Table Samples
#1 Find the total number of hours spent on each project (= SUM OF HOURS). Fields needed: Project Hours Convert the data to = AVERAGE OF HOURS In the PivotTable Field List, locate the Values section and click the Hours and select Value
In-Class Example Questions
1. Find the total number of hours spent by each staff member for Quarter 3, by month (you must use grouping). a. Create a PivotTable (Insert PivotTable) i. Highlight data to use in PivotTable ii.New Worksheet b. Layout i.Value =
This Quiz has 2 parts. The first is to complete a data table using the information provided on the next worksheet. The second part is to work up 3 pivot tables based on the instructions on the Pivot table problem worksheet, using the data from the Pivot t
Quiz 1 Tasks A. For the Quiz 1 sheet tab, complete the following
1. Project revenue growth for each division through 2013 using the revenue growth assumption and the 2 Make sure you set up the calculations so that it is easy to experiment with different g
DATA TABLES AND CHARTS
Purchase Options for Jeans and Shirts
Assumptions: Jeans Cost per item $20 Number of items 1 Shirts $10 2 Formula: Total Cost $40
Give the total costs under the various combinations of jeans and shirts.
Jeans Data Table: Shirts $40.
Hong Nguyen Finance 304, Assignment 2
Two parts to Assignment #2: 1) Do the Software Demonstration below for the 3 companies given (7 pts out of 10). 2) Select a company in the S&P 100 Index. Generate a Company Highlights report. (3 pts out of 10) Softwar
Assignment #4: Data Tables and Charts
Part 1 Instructions: Investment Data Table 1. Construct a data table for the following problem: Ms. Mable has $100,000 to invest for retirement. She needs to know what the future value of her investment will be over t
Part 1
1. On the sheet tab labeled Data, complete the 4 required parts of the forecasting model a. Scatter Chart b. Label the trend components as per the Powerpoint slideshow c. Find the trend line equation d. Forecast the sales for 2008 Points Scatter Ch
This Quiz has 2 parts. The first is to complete a data table using the information provided on the next worksheet. The second part is to work up 3 pivot tables based on the instructions on the Pivot table problem worksheet, using the data from the Pivot t
Using an IF Statement determine which column has a larger # for each row. Column 1 Column 2 If Statement 2 5 Column 2 4 3 Column 1 6 6 Column 2 8 2 Column 1 10 3 Column 1 12 7 Column 1 14 15 Column 2 16 12 Column 1 18 19 Column 2
Using an IF statement det
Name: Hannah (Hong) Nguyen Section: Finan 304 - 001 Using an IF Statement determine the SUM of Column 1 and Column 2 for each row. If the SUM is greater than 10 then display the SUM of Column 1 and Column 2 for each row. If the SUM is less than 10 then di