Use the Data Given Below to Answer the Following Question(s)

question 33

Multiple Choice

Use the data given below to answer the following question(s) .
Following is an extract from the Cost per Order Database of Grogtes LLC. $\begin{array}{|l|l|c|l|lr|}\hline\text { Item Category } & \text { Item } \mathrm{ID} &{\text { Item Cost }} & \text { Units } & \text { Cost per Order } \\\hline \text { Nuts } & \text { N101 } & \$ 2.44 & 94 & \$ &229.36\\\hline \text { Screws } & \text { S101 } & \$ 20.44 & 49 & \$ & 1,001.56 \\\hline \text { Nuts } & \text { N102 } & \$ 5.44 & 35 & \$ & 190.40 \\\hline \text { Screwdriver } & \text { SD 101 } & \$ 20.44 & 26 & \$ & 531.44 \\\hline \text { Nuts } & \text { N102 } & \$ 3.44 & 55 & \$ & 189.20 \\\hline \text { Screws } & \text { S102 } & \$ 5.44 & 59 & \$ & 320.96 \\\hline \text { Nuts } & \text { N101 } & \$ 2.44 & 74 & \$ & 180.56 \\\hline \text { Nuts } & \text { N102 } & \$ 5.44 & 89 & \$ & 484.16 \\\hline \text { Nuts } & \text { N101 } & \$ 2.44 & 31 & \$ & 75.64 \\\hline \text { Screws } & \text { S103 } & \$ 9.44 & 59 & \$ & 556.96 \\\hline \text { Nuts } & \text { N102 } & \$ 5.44 & 89 & \$ & 484.16 \\\hline \text { Screws } & \text { S101 } & \$ 2.44 & 28 & \$ & 68.32 \\\hline \text { Screws } & \text { S101 } & \$ 20.44 & 80 & \$ & 1,635.20 \\\hline \text { Nuts } & \text { N102 } & \$ 5.44 & 34 & \$ & 184.96 \\\hline \text { Nails } & \text { NG101 } & \$ 125.45 & 1 & \$ & 125.45 \\\hline \text { Bolts } & \text { B101 } & \$ 16.44 & 15 & \$ & 246.60 \\\hline \text { Screws } & \text { S103 } & \$ 9.44 & 27 & \$ & 254.88 \\\hline \text { Screwdriver } & \text { SD 102 } & \$ 9.44 & 63 & \$ & 594.72 \\\hline \text { Screwdriver } & \text { SD 101 } & \$ 20.44 & 14 & \$ & 286.16 \\\hline \text { Bolts } & \text { B102 } & \$ 5.44 & 95 & \$ & 516.80 \\\hline \text { Nuts } & \text { N103 } & \$ 1.74 & 66 & \$ & 114.84 \\\hline \text { Bolts } & \text { B101 } & \$ 16.44 & 73 & \$ & 1,200.12 \\\hline \text { Screws } & \text { S103 } & \$ 9.44 & 45 & \$ & 424.80 \\\hline \text { Screws } & \text { S104 } & \$ 15.45 & 86 & \$ & 1,328.70 \\\hline \text { Screws } & \text { S102 } & \$ 5.44 & 3 & \$ & 16.32 \\\hline \text { Screws } & \text { S101 } & \$ 20.44 & 6 & \$ & 122.64 \\\hline \text { Bolts } & \text { B } 102 & \$ 5.44 & 49 & \$ & 266.56 \\\hline \text { Nuts } & \text { N101 } & \$ 2.44 & 65 & \$ & 158.60 \\\hline \text { Screw driver } & \text { SD 103 } & \$ 5.44 & 95 & \$ & 516.80 \\\hline \text { Nuts } & \text { N103 } & \$ 1.74 & 52 & \$ & 90.48 \\\hline \text { Screws } & \text { S103 } & \$ 9.44 & 79 & \$ & 745.76 \\\hline \text { Nailgun pack } & \text { NG101 } & \$ 125.45 & 4 & \$ & 501.80 \\\hline \text { Bolts } & \text { B102 } & \$ 5.44 & 61 & \$ & 331.84 \\\hline \text { Bolts } & \text { B103 } & \$ 12.94 & 54 & \$ & 698.76 \\\hline \text { Bolts } & \text { B104 } & \$ 24.40 & 41 & \$ & 1,000.40 \\\hline \text { Nails } & \text { NG102 } & \$ 275.45 & 2 & \$ & 550.90 \\\hline \text { Nuts } & \text { N103 } & \$ 1.74 & 6 & \$ & 10.44 \\\hline \text { Screw driver } & \text { SD } 104 & \$ 2.44 & 75 & \$ & 183.00 \\\hline \text { Screws } & \text { S101 } & \$ 20.44 & 56 & \$ & 1,144.64 \\\hline \text { Nuts } & \text { N103 } & \$ 1.74 & 13 & \$ & 22.62 \\\hline \text { Screws } & \$ 102 & \$ 5.44 & 10 & \$ & 54.40 \\\hline\end{array}$
$\quad$ $$\begin{array} { | c | l | r | l | l c | } \hline \text { Screws } & \text { S101 } & \$ 20.44 & 93 & \$ & 1,900.92 \\\hline \text { Screws } & \text { S102 } & \$ 5.44 & 27 & \$ & 146.88 \\\hline\end{array}$$
-Which of the following is true about constructing PivotTables?

• A) It is not possible to construct the PivotTable in the same worksheet.
• B) Dragging a field into the Report Filter area allows addition of a third dimension to the analysis.
• C) Placing a field each in the row and column labels will automatically sum the variable values in the table.
• D) PivotTables cannot be duplicated by copying and pasting an existing table.

---

Definitions:

Informal Negotiation

Informal negotiation is a less formal, non-structured approach to resolving disputes or differences between parties without the intervention of formal procedures or third parties.

Ground Rules

Basic guidelines or agreed-upon principles set at the beginning of an activity or meeting to ensure its smooth conduct and success.

Managing Emotions

The process of recognizing, identifying, and effectively dealing with one's feelings and emotional responses.

Conflict Resolution

Conflict Resolution is a process aimed at managing and resolving a dispute or disagreement between two or more parties in a constructive manner.