Solved

Use the Data Given Below to Answer the Following Questions)

Question 12

True/False

Use the data given below to answer the following questions).
Following is the purchase order database of 'The Chef Says So', a restaurant in New York, over the last quarter April-June).  A  B  C  D  E  F 1 Order Date  Item  Region  Supplier  Unit Cost  Units 25/6/2012 Steel Fork  Antasia  Peter 5.449834/7/2012 Ceramic Plate  Puitoria  Kane 23.445345/13/2012 Steel Fork  Puitoria  Jones 8.443956/10/2012 Silver Spoon  Puitoria  Gerry 23.443066/22/2012 Steel Fork  Almeco  Sarah 6.445975/17/2012 Ceramic Plate  Antasia  Peter 8.446384/25/2012 Steel Fork  Puitoria  Audrey 5.447896/1/2012 Steel Fork  Puitoria  Jones 8.4493104/2/2012 Steel Fork  Almeco  Thomas 5.4435115/27/2012 Ceramic Plate  Antasia  Peter 12.4463126/13/2012 Steel Fork  Puitoria  Mary 8.4493134/30/2012 Ceramic Plate  Antasia  Henry 5.4432145/11/2012 Ceramic Plate  Antasia  Philip 23.4484156/18/2012 Steel Fork  Antasia  Peter 8.4438165/9/2012 Glass Bottle  Putoria  Simson 128.455175/30/2012 Ceramic Bowl  Antasia  Peter 19.4419186/6/2012 Ceramic Plate  Puitoria  Mary 12.4431194/3/2012 Silver Spoon  Antasia  Peter 12.4467206/26/2012 Silver Spoon  Antasia  Philip 23.4418214/23/2012 Ceramic Bowl  Puitoria  Kane 8.4499224/29/2012 Steel Fork  Puitoria  Simson 4.7470234/4/2012 Ceramic Bowl  Antasia  Philip 19.4477246/15/2012 Ceramic Plate  Puitoria  Gerry 12.4449\begin{array}{|r|r|l|l|c|r|r|} \hline& \text { A } &{\text { B }} & \text { C } & \text { D } & \text { E } &{\text { F }} \\\hline 1 & \text { Order Date } & \text { Item } & \text { Region } & \text { Supplier } & \text { Unit Cost } & \text { Units } \\\hline 2 & 5 / 6 / 2012 & \text { Steel Fork } & \text { Antasia } & \text { Peter } & 5.44 & 98 \\\hline 3 & 4 / 7 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Kane } & 23.44 & 53 \\\hline 4 & 5 / 13 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Jones } & 8.44 & 39 \\\hline 5 & 6 / 10 / 2012 & \text { Silver Spoon } & \text { Puitoria } & \text { Gerry } & 23.44 & 30 \\\hline 6 & 6 / 22 / 2012 & \text { Steel Fork } & \text { Almeco } & \text { Sarah } & 6.44 & 59 \\\hline 7 & 5 / 17 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Peter } & 8.44 & 63\\\hline 8 & 4 / 25 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Audrey } & 5.44 & 78 \\\hline 9 & 6 / 1 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Jones } & 8.44 & 93 \\\hline 10 & 4 / 2 / 2012 & \text { Steel Fork } & \text { Almeco } & \text { Thomas } & 5.44 & 35 \\\hline 11 & 5 / 27 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Peter } & 12.44 & 63 \\\hline 12 & 6 / 13 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Mary } & 8.44 & 93 \\\hline 13 & 4 / 30 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Henry } & 5.44 & 32 \\\hline 14 & 5 / 11 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Philip } & 23.44 & 84 \\\hline 15 & 6 / 18 / 2012 & \text { Steel Fork } & \text { Antasia } & \text { Peter } & 8.44 & 38 \\\hline 16 & 5 / 9 / 2012 & \text { Glass Bottle } & \text { Putoria } & \text { Simson } & 128.45 & 5 \\\hline 17 & 5 / 30 / 2012 & \text { Ceramic Bowl } & \text { Antasia } & \text { Peter } & 19.44 & 19 \\\hline 18 & 6 / 6 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Mary } & 12.44 & 31\\\hline 19 & 4 / 3 / 2012 & \text { Silver Spoon } & \text { Antasia } & \text { Peter } & 12.44 & 67 \\\hline 20 & 6 / 26 / 2012 & \text { Silver Spoon } & \text { Antasia } & \text { Philip } & 23.44 & 18 \\\hline 21 & 4 / 23 / 2012 & \text { Ceramic Bowl } & \text { Puitoria } & \text { Kane } & 8.44 & 99 \\\hline 22 & 4 / 29 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Simson } & 4.74 & 70 \\\hline 23 & 4 / 4 / 2012 & \text { Ceramic Bowl } & \text { Antasia } & \text { Philip } & 19.44 & 77 \\\hline 24 & 6 / 15 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Gerry } & 12.44 & 49 \\\hline\end{array}
\quad
-Changes to the type of chart, data included in the chart, and chart layout and styles can be made from the Layout tab.

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