Solved

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

Question 23

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.  Item Category  Item ID Item Cost  Units  Cost per Order  Nuts  N101 $2.4494$229.36 Screws  S101 $20.4449$1,001.56 Nuts  N102 $5.4435$190.40 Screwdriver  SD 101 $20.4426$531.44 Nuts  N102 $3.4455$189.20 Screws  S102 $5.4459$320.96 Nuts  N101 $2.4474$180.56 Nuts  N102 $5.4489$484.16 Nuts  N101 $2.4431$75.64 Screws  S103 $9.4459$556.96 Nuts  N102 $5.4489$484.16 Screws  S101 $2.4428$68.32 Screws  S101 $20.4480$1,635.20 Nuts  N102 $5.4434$184.96 Nails  NG101 $125.451$125.45 Bolts  B101 $16.4415$246.60 Screws  S103 $9.4427$254.88 Screwdriver  SD 102 $9.4463$594.72 Screwdriver  SD 101 $20.4414$286.16 Bolts  B102 $5.4495$516.80 Nuts  N103 $1.7466$114.84 Bolts  B101 $16.4473$1,200.12 Screws  S103 $9.4445$424.80 Screws  S104 $15.4586$1,328.70 Screws  S102 $5.443$16.32 Screws  S101 $20.446$122.64 Bolts  B 102$5.4449$266.56 Nuts  N101 $2.4465$158.60 Screw driver  SD 103 $5.4495$516.80 Nuts  N103 $1.7452$90.48 Screws  S103 $9.4479$745.76 Nailgun pack  NG101 $125.454$501.80 Bolts  B102 $5.4461$331.84 Bolts  B103 $12.9454$698.76 Bolts  B104 $24.4041$1,000.40 Nails  NG102 $275.452$550.90 Nuts  N103 $1.746$10.44 Screw driver  SD 104$2.4475$183.00 Screws  S101 $20.4456$1,144.64 Nuts  N103 $1.7413$22.62 Screws $102$5.4410$54.40\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  Screws  S101 $20.4493$1,900.92 Screws  S102 $5.4427$146.88\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 can be used to quickly create cross-tabulations?


A) Frequency distribution
B) COUNTIF function
C) PivotTable
D) Sort & Filter

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents