Solved

Use the Data Given Below to Answer the Following Questions)

Question 2

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

Related Questions