R2. Cell I2: Enter a formula to determine overtime pay for the week for the employee in row 2. (If an amount box requires zero, enter "0". Round your answer to 2 decimal places.) fill in the blank 1 of 1$

R3. Cell J2: Enter a formula to determine total pay for the week for the employee in row 2. (Round your answer to 2 decimal places.) fill in the blank 1 of 1$

R4. Cell L2: Enter a formula to determine the amount of Social Security tax for the employee in row 2. (Round your answer to 2 decimal places.) fill in the blank 1 of 1$

R5. Cell M2: Enter a formula to determine the amount of Medicare tax for the employee in row 2. (Round your answer to 2 decimal places.) fill in the blank 1 of 1$

R6. Cell N2: Enter a formula to determine net pay for the week for the employee in row 2. (Round your answer to 2 decimal places.) fill in the blank 1 of 1$

R7. Copy down the entries in cells H2, I2, J2, L2, M2, and N2 to all the other rows with data.

Steps to create a pivot table:

S1. Select a cell in the data on the Data worksheet. S2. Select Insert / PivotTable. The data range will automatically be inserted. A Create PivotTable window should appear. S3. In the window, under "Choose where you want the PivotTable report to be placed," select New Worksheet. A new worksheet should appear with the PivotTable. S4. A PivotTable Field List should pop up. Drag fields into rows, columns, filters, and values areas as needed. (If this gray work box does not appear, right click in the pivot table and select "Show Field List.")

Questions:

Use the information on the Data worksheet and pivot tables, formulas, and/or functions to answer the following questions.

Q1. What is the total amount of net pay for the Assembly and Painting Department employees combined? (Round your answer to 2 decimal places.) fill in the blank 1 of 1$

Q2. What is the total amount of Social Security and Medicare tax amounts combined for the Packaging Department? (Round your answer to 2 decimal places.) fill in the blank 1 of 1$

Q3. How many employees received over-time pay of more than $285? fill in the blank 1 of 1

Q4. What is the percentage of average gross pay of employees in the Shipping Department to the average gross pay of all employees? (Round the percentage to two decimal places, such as 8.79%.) fill in the blank 1 of 1 %

\begin{tabular}{|c|c|c|c|c|} \hline Turner, Dennis & Assembly & 48 & 36 & 374.40 \\ \hline Chavez, Jacob & Shipping & 48 & 20 & 208.00 \\ \hline Gomez, Carl & Painting & 40 & 24 & 192.00 \\ \hline Watson, Daniel & Painting & 40 & 24 & 192.00 \\ \hline Nierling, Steven & Shipping & 50 & 18 & 198.00 \\ \hline Evans, Eugene & Packaging & 40 & 15 & 72.00 \\ \hline Foster, Judith & Assembly & 50 & 32 & 352.00 \\ \hline Ramirez, Joyce & Packaging & 40 & 18 & 86.40 \\ \hline Spedoske, Jonathan & Assembly & 40 & 34 & 272.00 \\ \hline Vozenilek, Paul & Assembly & 40 & 38 & 304.00 \\ \hline Schoellman, Nicole & Painting & 42 & 26 & 223.60 \\ \hline Mickelberg, Olivia & Painting & 40 & 24 & 192.00 \\ \hline Carpiniello, Larry & Shipping & 46 & 20 & 196.00 \\ \hline Kronbach, Andrea & Packaging & 40 & 20 & 160.00 \\ \hline Ardolf, Stephen & Assembly & 48 & 32 & 332.80 \\ \hline Scheben, Aaron & Shipping & 46 & 16 & 94.10 \\ \hline Harris, Russell & Shipping & 48 & 20 & 208.00 \\ \hline Kim, Doris & Assembly & 40 & 34 & 272.00 \\ \hline Sanchez, Julie & Shipping & 50 & 18 & 198.00 \\ \hline Walker, Helen & Assembly & 50 & 36 & 396.00 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline Madris, Timothy & Assembly & 48 & 36 & 374.40 \\ \hline Mccallops, Christian & Shipping & 44 & 18 & 165.60 \\ \hline Concord, John & Shipping & 48 & 15 & 93.60 \\ \hline Morris, Danielle & Painting & 40 & 22 & 176.00 \\ \hline Ploense, Carolyn & Packaging & 40 & 16 & 76.80 \\ \hline Kelly, Raymond & Packaging & 40 & 15 & 72.00 \\ \hline Amspoker, Gerald & Packaging & 46 & 20 & 196.00 \\ \hline Gray, Michelle & Assembly & 40 & 34 & 272.00 \\ \hline White, Shirley & Assembly & 40 & 34 & 272.00 \\ \hline Turner, Dennis & Assembly & 48 & 36 & 374.40 \\ \hline Chavez, Jacob & Shipping & 48 & 20 & 208.00 \\ \hline Gomez, Carl & Painting & 40 & 24 & 192.00 \\ \hline Watson, Daniel & Painting & 40 & 24 & 192.00 \\ \hline Nierling, Steven & Shipping & 50 & 18 & 198.00 \\ \hline Evans, Eugene & Packaging & 40 & 15 & 72.00 \\ \hline Foster, Judith & Assembly & 50 & 32 & 352.00 \\ \hline Ramirez, Joyce & Packaging & 40 & 18 & 86.40 \\ \hline Spedoske, Jonathan & Assembly & 40 & 34 & 272.00 \\ \hline Vozenilek, Paul & Assembly & 40 & 38 & 304.00 \\ \hline Schoellman, Nicole & Painting & 42 & 26 & 223.60 \\ \hline Mickelberg, Olivia & Painting & 40 & 24 & 192.00 \\ \hline Carpiniello, Larry & Shipping & 46 & 20 & 196.00 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline Duckstein, Jeremy & Assembly & 40 & 36 & 288.00 \\ \hline King, Hannah & Packaging & 40 & 20 & 160.00 \\ \hline Nguyen, Lauren & Assembly & 40 & 34 & 272.00 \\ \hline Maloles, Dylan & Packaging & 44 & 16 & 88.30 \\ \hline Chorro, Kayla & Shipping & 40 & 16 & 76.80 \\ \hline Kasprak, Rebecca & Packaging & 48 & 20 & 208.00 \\ \hline Featheringham, Eric & Painting & 40 & 28 & 224.00 \\ \hline Carter, Michael & Packaging & 40 & 16 & 76.80 \\ \hline Bullara, Susan & Shipping & 46 & 16 & 94.10 \\ \hline Roberts, Vincent & Packaging & 40 & 15 & 72.00 \\ \hline Allaband, Billy & Assembly & 40 & 36 & 288.00 \\ \hline Young, Charlotte & Packaging & 50 & 18 & 198.00 \\ \hline Calascione, Martha & Packaging & 46 & 20 & 196.00 \\ \hline Gancayco, Brenda & Shipping & 50 & 16 & 176.00 \\ \hline Ginart, Grace & Packaging & 42 & 20 & 172.00 \\ \hline Phillips, Willie & Assembly & 40 & 34 & 272.00 \\ \hline Jonguitud, Philip & Painting & 46 & 26 & 254.80 \\ \hline Panchak, Mason & Shipping & 40 & 20 & 160.00 \\ \hline Scott, Jordan & Painting & 44 & 28 & 257.60 \\ \hline Eswaran, Brittany & Packaging & 40 & 20 & 160.00 \\ \hline James, Emily & Packaging & 48 & 20 & 208.00 \\ \hline Throndsen, Victoria & Painting & 46 & 26 & 254.80 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline Diaz, Pamela & Painting & 44 & 22 & 202.40 \\ \hline Rugger, Charles & Painting & 40 & 24 & 192.00 \\ \hline Murphy, Terry & Packaging & 40 & 16 & 76.80 \\ \hline Jimenez, Lisa & Shipping & 40 & 20 & 160.00 \\ \hline Anderson, Diane & Shipping & 44 & 18 & 165.60 \\ \hline Green, Kevin & Packaging & 40 & 18 & 86.40 \\ \hline Feyrer, Matthew & Painting & 42 & 24 & 206.40 \\ \hline Collins, Donald & Assembly & 42 & 34 & 292.40 \\ \hline Johnson, Frances & Shipping & 40 & 18 & 86.40 \\ \hline Viglianco, Bobby & Packaging & 40 & 20 & 160.00 \\ \hline Ollenburger, Barbara & Assembly & 48 & 32 & 332.80 \\ \hline Mishchuk, Benjamin & Painting & 40 & 22 & 176.00 \\ \hline Mitchell, Zachary & Assembly & 40 & 36 & 288.00 \\ \hline Rogers, Christopher & Assembly & 40 & 32 & 256.00 \\ \hline Pegany, Jennifer & Shipping & 40 & 18 & 86.40 \\ \hline Stolly, Natalie & Shipping & 40 & 15 & 72.00 \\ \hline Bennet, Randy & Packaging & 42 & 15 & 77.40 \\ \hline Campbell, Jean & Painting & 42 & 28 & 240.80 \\ \hline Bressett, Abigail & Shipping & 40 & 20 & 160.00 \\ \hline Hernandez, Edward & Packaging & 40 & 18 & 86.40 \\ \hline Clyborne, Alan & Shipping & 50 & 16 & 176.00 \\ \hline Clark, Janice & Assembly & 50 & 34 & 374.00 \\ \hline Jill Charul & Daintina & 5n & 21 & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline Allen, Ashley & Shipping & 50 & 15 & 165.00 \\ \hline Hughes, Linda & Assembly & 40 & 34 & 272.00 \\ \hline Serranogarcia, Louis & Packaging & 44 & 20 & 184.00 \\ \hline Rodriguez, Betty & Painting & 42 & 24 & 206.40 \\ \hline Banasiewicz, Anna & Assembly & 50 & 36 & 396.00 \\ \hline Gayhardt, Alice & Shipping & 40 & 15 & 72.00 \\ \hline Bidelspach, Joe & Painting & 46 & 24 & 235.20 \\ \hline Williams, Sarah & Shipping & 40 & 16 & 76.80 \\ \hline Hanschu, Kelly & Painting & 46 & 28 & 274.40 \\ \hline Ekundayo, Sara & Painting & 50 & 24 & 264.00 \\ \hline Myers, Debra & Packaging & 40 & 16 & 76.80 \\ \hline Thompson, Catherine & Shipping & 46 & 20 & 196.00 \\ \hline Mendoza, Angela & Assembly & 42 & 34 & 292.40 \\ \hline Naese, Rachel & Shipping & 48 & 16 & 166.40 \\ \hline Edwards, Judy & Packaging & 48 & 15 & 93.60 \\ \hline Goscicki, William & Assembly & 40 & 38 & 304.00 \\ \hline Melgren, Christina & Packaging & 40 & 16 & 76.80 \\ \hline Cruz, Bryan & Painting & 48 & 22 & 228.80 \\ \hline Robinson, Maria & Packaging & 40 & 20 & 160.00 \\ \hline Hinsen, David & Packaging & 46 & 16 & 94.10 \\ \hline Denetsosie, Melissa & Packaging & 40 & 16 & 76.80 \\ \hline Torsney, Beverly & Painting & 40 & 24 & 192.00 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline Grigoras, Teresa & Painting & 42 & 26 & 223.60 \\ \hline Kentala, Isabella & Shipping & 42 & 16 & 82.60 \\ \hline Luettgen, Samuel & Packaging & 48 & 20 & 208.00 \\ \hline Wright, Wayne & Packaging & 48 & 15 & 93.60 \\ \hline Cripple, Albert & Shipping & 48 & 20 & 208.00 \\ \hline Peterson, Ryan & Shipping & 40 & 15 & 72.00 \\ \hline Castillo, Richard & Assembly & 40 & 32 & 256.00 \\ \hline Martinez, Gabriel & Painting & 44 & 28 & 257.60 \\ \hline Tuffin, Lori & Shipping & 40 & 16 & 76.80 \\ \hline Adams, Justin & Shipping & 40 & 16 & 76.80 \\ \hline Tartal, Diana & Shipping & 40 & 16 & 76.80 \\ \hline Occhialini, Emma & Packaging & 44 & 20 & 184.00 \\ \hline Hayda, Ann & Assembly & 40 & 36 & 288.00 \\ \hline Howard, Katherine & Shipping & 46 & 16 & 94.10 \\ \hline Sanders, Noah & Assembly & 48 & 38 & 395.20 \\ \hline Llama, Elizabeth & Packaging & 42 & 18 & 92.90 \\ \hline Tahhan, Alexis & Assembly & 40 & 34 & 272.00 \\ \hline Riggie, Andrew & Assembly & 40 & 32 & 256.00 \\ \hline Cox, Roy & Assembly & 40 & 36 & 288.00 \\ \hline Garcia, Keith & Shipping & 46 & 18 & 176.40 \\ \hline Brown, Kathleen & Assembly & 44 & 36 & 331.20 \\ \hline Reyes, Joseph & Packaging & 50 & 16 & 176.00 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline Price, Julia & Painting & 44 & 28 & 257.60 \\ \hline Kleinhaus, Frank & Shipping & 50 & 20 & 220.00 \\ \hline Doxon, Ralph & Painting & 42 & 28 & 240.80 \\ \hline Flores, Laura & Shipping & 40 & 16 & 76.80 \\ \hline Richardson, Denise & Painting & 40 & 24 & 192.00 \\ \hline Vanidestine, Samantha & Shipping & 40 & 15 & 72.00 \\ \hline Latcha, Jose & Assembly & 40 & 36 & 288.00 \\ \hline Guillebeaux, Walter & Assembly & 40 & 34 & 272.00 \\ \hline Ruiz, Margaret & Painting & 44 & 22 & 202.40 \\ \hline Cooper, Kathryn & Packaging & 40 & 20 & 160.00 \\ \hline Long, George & Shipping & 40 & 18 & 86.40 \\ \hline Atonal, Adam & Painting & 40 & 22 & 176.00 \\ \hline Lewis, Patricia & Shipping & 40 & 20 & 160.00 \\ \hline Lee, Mary & Packaging & 48 & 15 & 93.60 \\ \hline Konietzko, Brian & Painting & 46 & 24 & 235.20 \\ \hline Jackson, Robert & Assembly & 40 & 32 & 256.00 \\ \hline Reed, Ethan & Painting & 40 & 26 & 208.00 \\ \hline Hall, Tyler & Packaging & 44 & 18 & 165.60 \\ \hline Gutierrez, Amy & Packaging & 40 & 16 & 76.80 \\ \hline Rivera, Harold & Painting & 42 & 26 & 223.60 \\ \hline Skalbeck, Jason & Assembly & 40 & 34 & 272.00 \\ \hline Morgan, Dorothy & Packaging & 40 & 18 & 86.40 \\ \hline \end{tabular}