Question 1

What is a database?
A) a structured collection of related files and data
B) simply a collection of data
C) a data file holding a single file
D) flat files used to store data

Accepted Answer

A database is a structured collection of related files and data, organized in a way that allows for easy access, management, and updating.

Question 2

is a logical function that returns one value if the condition is true and another if the condition is false.
A) ORcondition 1, condition 2…)
B) ANDcondition 1, condition 2…)
C) TOvalue if true, value if false)
D) IFcondition, value if true, value if false)

Accepted Answer

The IF function is the correct answer because it is designed to return one value if a specified condition evaluates to true and another value if it evaluates to false.

Question 3

The sort buttons in Excel can be found under:
A) the Data tab in the Sort & Filter group.
B) the Home tab in the Styles group.
C) the Insert tab in the Sort group.
D) the Sort tab in the Filter group.

Accepted Answer

The sort buttons in Excel are located under the Data tab within the Sort & Filter group, allowing users to organize their data in various ways.

Question 4

Use the data given below to answer the following questions).
Below is a spreadsheet of purchase orders for a computer hardware retailer. \(\begin{array}{|l|l|l|l|l|l|l|l|l|}
\hline& \text { A } & \text { B } & C & \mathrm{D}&E&F&G&H \
\hline &\text { Purchase } & & & \
1& \text { Orders } & & & \
\hline 2\
\hline 3 & \text { Supplier } & \begin{array}{l}
\text { item }\\text { Description }\
\end{array} & \begin{array}{l}
\text { Item } \
\text { Cost }
\end{array} & \text { Quantity } & \begin{array}{l}
\text { Cost per } \
\text { Order }
\end{array} & \begin{array}{l}
\text { AP Terms } \
\text { Months) }
\end{array} & \begin{array}{l}
\text { Order } \
\text { No. }
\end{array} & \begin{array}{l}
\text { Order } \
\text { Size }
\end{array} \
\hline & \text { Rex } & \text { Graphics } & & & & & \
4&\text { Technologies } & \text { Card } & \$ 89 & 35 & \text { \$3115 } & 20 & \text { AL123 } & \text { Large } \
\hline5 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}& \text { Monitor } & \$ 150 & 15 & \$ 2250 & 25 & \text { AL234 } & \text { Small } \
\hline6 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}&\text { Keyboard } & \$ 15 & 40 & \$ 600 & 15 & \text { AL345 } & \text { Large } \
\hline7 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}&\text { Speakers } & \$ 15 & 20 & \$ 300 & 25 & \text { AL456 } & \text { Small } \
\hline8 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { HD Cables } & \$ 5 & 10 & \$ 50 & 25 & \text { KO876 } & \text { Small } \
\hline9 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { Processor } & \$ 278 & 27 & \$ 6950 & 30 & \text { KO765 } & \text { Large }\
\hline10 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { Hard disk } & \$ 120 & 18 & \$ 2160 & 20 & \text { KO654 } & \text { Small }\

\hline 11\
\hline12&\text { Supplier }&\text { Order Size }&\begin{array}{l}
\text { item } \
\text { cost }
\end{array} \
\hline13 &\text { Rex Technologies}&\text { Large } &>15\
\hline 14&\text { Max's Wavetech }\
\hline
\end{array}\)
-To find the number of orders with A/P terms less than 25 months, what Excel formula should be used in A12?
A) =COUNTIFF4:F10,"<25")
B) =COUNTF4:F10,25)
C) =AVERAGEF4:F10,"<25")
D) =COUNTIFF4:F10,F5)

Accepted Answer

The correct formula to count the number of orders with A/P terms less than 25 months is =COUNTIF(F4:F10,"<25"). This formula checks the range F4:F10 for any values that are less than 25 and counts them.

Question 5

Use the data given below to answer the following questions).
Below is a spreadsheet of purchase orders for a computer hardware retailer. \(\begin{array}{|l|l|l|l|l|l|l|l|l|}
\hline& \text { A } & \text { B } & C & \mathrm{D}&E&F&G&H \
\hline &\text { Purchase } & & & \
1& \text { Orders } & & & \
\hline 2\
\hline 3 & \text { Supplier } & \begin{array}{l}
\text { item }\\text { Description }\
\end{array} & \begin{array}{l}
\text { Item } \
\text { Cost }
\end{array} & \text { Quantity } & \begin{array}{l}
\text { Cost per } \
\text { Order }
\end{array} & \begin{array}{l}
\text { AP Terms } \
\text { Months) }
\end{array} & \begin{array}{l}
\text { Order } \
\text { No. }
\end{array} & \begin{array}{l}
\text { Order } \
\text { Size }
\end{array} \
\hline & \text { Rex } & \text { Graphics } & & & & & \
4&\text { Technologies } & \text { Card } & \$ 89 & 35 & \text { \$3115 } & 20 & \text { AL123 } & \text { Large } \
\hline5 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}& \text { Monitor } & \$ 150 & 15 & \$ 2250 & 25 & \text { AL234 } & \text { Small } \
\hline6 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}&\text { Keyboard } & \$ 15 & 40 & \$ 600 & 15 & \text { AL345 } & \text { Large } \
\hline7 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}&\text { Speakers } & \$ 15 & 20 & \$ 300 & 25 & \text { AL456 } & \text { Small } \
\hline8 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { HD Cables } & \$ 5 & 10 & \$ 50 & 25 & \text { KO876 } & \text { Small } \
\hline9 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { Processor } & \$ 278 & 27 & \$ 6950 & 30 & \text { KO765 } & \text { Large }\
\hline10 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { Hard disk } & \$ 120 & 18 & \$ 2160 & 20 & \text { KO654 } & \text { Small }\

\hline 11\
\hline12&\text { Supplier }&\text { Order Size }&\begin{array}{l}
\text { item } \
\text { cost }
\end{array} \
\hline13 &\text { Rex Technologies}&\text { Large } &>15\
\hline 14&\text { Max's Wavetech }\
\hline
\end{array}\)
-If purchase quantities of 25 units or higher are found to be large orders, and orders less than 25 are considered to be small, what IF function should be entered in H4 to be copied to H5:H10 to calculate each order's size?
A) =IFD4=AND=OR=25,"Large","Small")
B) =IFD4<>25,"Small")=ANDD4=25,"Large")
C) =IFD4=25,"Large")=OR"Small")
D) =IFD4>=25,"Large","Small")

Accepted Answer

The correct IF function is =IF(D4>=25,"Large","Small"). This function checks if the quantity in cell D4 is 25 or more to label it as "Large"; otherwise, it labels it as "Small".

Question 6

Use the data given below to answer the following questions).
Below is a spreadsheet of purchase orders for a computer hardware retailer. \(\begin{array}{|l|l|l|l|l|l|l|l|l|}
\hline& \text { A } & \text { B } & C & \mathrm{D}&E&F&G&H \
\hline &\text { Purchase } & & & \
1& \text { Orders } & & & \
\hline 2\
\hline 3 & \text { Supplier } & \begin{array}{l}
\text { item }\\text { Description }\
\end{array} & \begin{array}{l}
\text { Item } \
\text { Cost }
\end{array} & \text { Quantity } & \begin{array}{l}
\text { Cost per } \
\text { Order }
\end{array} & \begin{array}{l}
\text { AP Terms } \
\text { Months) }
\end{array} & \begin{array}{l}
\text { Order } \
\text { No. }
\end{array} & \begin{array}{l}
\text { Order } \
\text { Size }
\end{array} \
\hline & \text { Rex } & \text { Graphics } & & & & & \
4&\text { Technologies } & \text { Card } & \$ 89 & 35 & \text { \$3115 } & 20 & \text { AL123 } & \text { Large } \
\hline5 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}& \text { Monitor } & \$ 150 & 15 & \$ 2250 & 25 & \text { AL234 } & \text { Small } \
\hline6 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}&\text { Keyboard } & \$ 15 & 40 & \$ 600 & 15 & \text { AL345 } & \text { Large } \
\hline7 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}&\text { Speakers } & \$ 15 & 20 & \$ 300 & 25 & \text { AL456 } & \text { Small } \
\hline8 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { HD Cables } & \$ 5 & 10 & \$ 50 & 25 & \text { KO876 } & \text { Small } \
\hline9 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { Processor } & \$ 278 & 27 & \$ 6950 & 30 & \text { KO765 } & \text { Large }\
\hline10 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { Hard disk } & \$ 120 & 18 & \$ 2160 & 20 & \text { KO654 } & \text { Small }\

\hline 11\
\hline12&\text { Supplier }&\text { Order Size }&\begin{array}{l}
\text { item } \
\text { cost }
\end{array} \
\hline13 &\text { Rex Technologies}&\text { Large } &>15\
\hline 14&\text { Max's Wavetech }\
\hline
\end{array}\)
-Which of the following Database functions calculates the total cost charged to Rex Technologies for large size orders?
A) =DSUMA3:H10,C3,A12:B14)
B) =DSUMA4:H10,"Cost per Order",A12:B13)
C) =DSUMA3:H10,C3,A12:B13)
D) =DSUMA3:H10,E3,A12:B13)

Accepted Answer

The answer of Use the data given below to answer...

Question 7

Give the logical function for the following: If cell B7 equals 12, check contents of cell B10. If cell B10 is 10, then the value of the function in the string is YES; if not, it is a blank space. If cell B7 does not equal 12, then the value of the function is 7.
A) =IFB7=12,ANDB10=10, "")YES)),7)
B) =IFB10=10,ORB7=12,"")"YES")7)
C) =IFB7=12,IFB10=10,"YES", "")),7)
D) =IFB7=12,ANDB10=10,"YES","")B10="NO"),7)

Accepted Answer

The correct formula is =IF(B7=12,IF(B10=10,"YES",""),7). This checks if B7 equals 12, then it checks if B10 equals 10 to return "YES"; otherwise, it returns a blank. If B7 does not equal 12, it returns 7.

Question 8

Use the data given below to answer the following questions).
Below is a spreadsheet of purchase orders for a computer hardware retailer. \(\begin{array}{|l|l|l|l|l|l|l|l|l|}
\hline& \text { A } & \text { B } & C & \mathrm{D}&E&F&G&H \
\hline &\text { Purchase } & & & \
1& \text { Orders } & & & \
\hline 2\
\hline 3 & \text { Supplier } & \begin{array}{l}
\text { item }\\text { Description }\
\end{array} & \begin{array}{l}
\text { Item } \
\text { Cost }
\end{array} & \text { Quantity } & \begin{array}{l}
\text { Cost per } \
\text { Order }
\end{array} & \begin{array}{l}
\text { AP Terms } \
\text { Months) }
\end{array} & \begin{array}{l}
\text { Order } \
\text { No. }
\end{array} & \begin{array}{l}
\text { Order } \
\text { Size }
\end{array} \
\hline & \text { Rex } & \text { Graphics } & & & & & \
4&\text { Technologies } & \text { Card } & \$ 89 & 35 & \text { \$3115 } & 20 & \text { AL123 } & \text { Large } \
\hline5 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}& \text { Monitor } & \$ 150 & 15 & \$ 2250 & 25 & \text { AL234 } & \text { Small } \
\hline6 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}&\text { Keyboard } & \$ 15 & 40 & \$ 600 & 15 & \text { AL345 } & \text { Large } \
\hline7 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}&\text { Speakers } & \$ 15 & 20 & \$ 300 & 25 & \text { AL456 } & \text { Small } \
\hline8 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { HD Cables } & \$ 5 & 10 & \$ 50 & 25 & \text { KO876 } & \text { Small } \
\hline9 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { Processor } & \$ 278 & 27 & \$ 6950 & 30 & \text { KO765 } & \text { Large }\
\hline10 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { Hard disk } & \$ 120 & 18 & \$ 2160 & 20 & \text { KO654 } & \text { Small }\

\hline 11\
\hline12&\text { Supplier }&\text { Order Size }&\begin{array}{l}
\text { item } \
\text { cost }
\end{array} \
\hline13 &\text { Rex Technologies}&\text { Large } &>15\
\hline 14&\text { Max's Wavetech }\
\hline
\end{array}\)
-Which of the following is a differentiation between calculating using the functions COUNT and COUNTIF?
A) COUNT does not require a range of cells; COUNTIF requires a range of cells.
B) COUNT only requires a range of cell and can be obtained without special criteria, COUNTIF requires range and special criteria to be calculated.
C) COUNT requires a range of cells; COUNTIF does not require a range of cells, only special criteria.
D) COUNT calculates the sum of values for a range of cells; COUNTIF finds the largest value in a range of cells.

Accepted Answer

COUNT function counts the number of cells in a range that contain numbers, while COUNTIF extends this functionality by counting only the cells that meet a specified condition (criteria).

Question 9

In a database file, which is organized in a two-dimensional table, the rows represent records of related data elements.

Accepted Answer

In a database file organized as a two-dimensional table, the rows indeed represent records, which are collections of related data elements, while the columns represent the different attributes of that data.

Question 10

Use the data given below to answer the following questions).
Below is a spreadsheet of purchase orders for a computer hardware retailer. \(\begin{array}{|l|l|l|l|l|l|l|l|l|}
\hline& \text { A } & \text { B } & C & \mathrm{D}&E&F&G&H \
\hline &\text { Purchase } & & & \
1& \text { Orders } & & & \
\hline 2\
\hline 3 & \text { Supplier } & \begin{array}{l}
\text { item }\\text { Description }\
\end{array} & \begin{array}{l}
\text { Item } \
\text { Cost }
\end{array} & \text { Quantity } & \begin{array}{l}
\text { Cost per } \
\text { Order }
\end{array} & \begin{array}{l}
\text { AP Terms } \
\text { Months) }
\end{array} & \begin{array}{l}
\text { Order } \
\text { No. }
\end{array} & \begin{array}{l}
\text { Order } \
\text { Size }
\end{array} \
\hline & \text { Rex } & \text { Graphics } & & & & & \
4&\text { Technologies } & \text { Card } & \$ 89 & 35 & \text { \$3115 } & 20 & \text { AL123 } & \text { Large } \
\hline5 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}& \text { Monitor } & \$ 150 & 15 & \$ 2250 & 25 & \text { AL234 } & \text { Small } \
\hline6 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}&\text { Keyboard } & \$ 15 & 40 & \$ 600 & 15 & \text { AL345 } & \text { Large } \
\hline7 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}&\text { Speakers } & \$ 15 & 20 & \$ 300 & 25 & \text { AL456 } & \text { Small } \
\hline8 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { HD Cables } & \$ 5 & 10 & \$ 50 & 25 & \text { KO876 } & \text { Small } \
\hline9 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { Processor } & \$ 278 & 27 & \$ 6950 & 30 & \text { KO765 } & \text { Large }\
\hline10 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { Hard disk } & \$ 120 & 18 & \$ 2160 & 20 & \text { KO654 } & \text { Small }\

\hline 11\
\hline12&\text { Supplier }&\text { Order Size }&\begin{array}{l}
\text { item } \
\text { cost }
\end{array} \
\hline13 &\text { Rex Technologies}&\text { Large } &>15\
\hline 14&\text { Max's Wavetech }\
\hline
\end{array}\)
-Which of the following Database functions calculates the count of purchase orders made by Rex Technologies?
A) =DCOUNTA3:H10,C3,A12:A13)
B) =DCOUNTA4:H10,C3,A12:A13)
C) =DCOUNTA3:H10,C3,A13)
D) =DCOUNTA3:H10,A3,A12:A13)

Accepted Answer

The DCOUNTA function counts the number of non-blank cells in a range of cells. In this case, we want to count the number of non-blank cells in the range A3:H10, where the value in column C is "Rex Technologies" and the value in column A is either "Large" or "Small". The correct formula is therefore =DCOUNTA(A3:H10,C3,A12:A13).

Question 11

The function returns a value or reference of the cell at the intersection of a particular row and column in a given range.
A) VLOOKUPlookup_value, table_array, col_index_num)
B) INDEXarray, row_num, col_num)
C) MATCHlookup_value, lookup_array, match_type)
D) HLOOKUPlookup_value, table_array, row_index_num)

Accepted Answer

INDEX function returns the value or the reference to a value from within a table or range.

Question 12

If cell G7 contains the function , it states that if the value in cell C3 is 9, the number 7 will be assigned to cell G7; if the value in cell C3 is not 9, the number 4 will be assigned to cell G7.
A) =IFG7=9)G7=7)=ORG7=4)
B) =IFG7=7)=THENC3=9)=ORC3=4)
C) =IFC3=9)C3=7)=ORC3=4)
D) =IFC3=9,7,4)

Accepted Answer

The correct syntax for an IF function in Excel is =IF(logical_test, value_if_true, value_if_false). Option D correctly applies this syntax to check if C3 is 9, then return 7, otherwise return 4.

Question 13

Use the data given below to answer the following question.
Following is the purchase order database of 'The Chef Says So', a restaurant in New York, over the last quarter April-June). \(\begin{array}{|c|c|c|c|r|r|}
\hline \begin{array}{c}
\text { Order } \
\text { Date }
\end{array} & \text { Item } & \text { Region } & \text { Supplier } & \text { Unit Cost } & {\text { Units }} \
\hline 5 / 6 / 2012 & \text { Steel Fork } & \text { Antasia } & \text { Peter } & 5.44 & 98 \
\hline 4 / 7 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Kane } & 23.44 & 53 \
\hline 5 / 13 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Jones } & 8.44 & 39 \
\hline 6 / 10 / 2012 & \text { Silver Spoon } & \text { Puitoria } & \text { Gerry } & 23.44 & 30 \
\hline 6 / 22 / 2012 & \text { Steel Fork } & \text { Almeco } & \text { Sarah } & 6.44 & 59 \
\hline 5 / 17 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Peter } & 8.44 & 63 \
\hline 4 / 25 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Audrey } & 5.44 & 78 \
\hline 6 / 1 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Jones } & 8.44 & 93 \
\hline 4 / 2 / 2012 & \text { Steel Fork } & \text { Almeco } & \text { Thomas } & 5.44 & 35 \
\hline 5 / 27 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Peter } & 12.44 & 63 \
\hline 6 / 13 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Mary } & 8.44 & 93 \
\hline 4 / 30 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Henry } & 5.44 & 32 \
\hline 5 / 11 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Philip } & 23.44 & 84 \
\hline 6 / 18 / 2012 & \text { Steel Fork } & \text { Antasia } & \text { Peter } & 8.44 & 38 \
\hline 5 / 9 / 2012 & \text { Glass Bottle } & \text { Puitoria } & \text { Simson } & 128.45 & 5 \
\hline 5 / 30 / 2012 & \text { Ceramic Bowl } & \text { Antasia } & \text { Peter } & 19.44 & 19 \
\hline 6 / 6 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Mary } & 12.44 & 31 \
\hline 4 / 3 / 2012 & \text { Silver Spoon } & \text { Antasia } & \text { Peter } & 12.44 & 67 \
\hline 6 / 26 / 2012 & \text { Silver Spoon } & \text { Antasia } & \text { Philip } & 23.44 & 18\
\hline 4 / 23 / 2012 & \text { Ceramic Bowl } & \text { Puitoria } & \text { Kane } & 8.44 & 99 \
\hline 4 / 29 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Simson } & 4.74 & 70 \
\hline 4 / 4 / 2012 & \text { Ceramic Bowl } & \text { Antasia } & \text { Philip } & 19.44 & 77 \
\hline 6 / 15 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Gerry } & 12.44 & 49 \
\hline 6 / 25 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Simson } & 18.45 & 90 \
\hline 5 / 23 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Peter } & 8.44 & 7 \
\hline 6 / 28 / 2012 & \text { Ceramic Plate } & \text { Almeco } & \text { Sarah } & 23.44 & 10 \
\hline 5 / 25 / 2012 & \text { Ceramic Bowl } & \text { Puitoria } & \text { Jones } & 8.44 & 53 \
\hline 5 / 1 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Audrey } & 5.44 & 69\
\hline
\end{array}\)
$\quad$
$\quad$ \(\begin{array}{|c|c|c|c|r|r|}
\hline\begin{array}{c}
\text { Order } \
\text { Date }
\end{array} & \text { Item } & \text { Region } & \text { Supplier } & \text { Unit Cost } & {\text { Units }} \
\hline 4 / 12 / 2012 & \text { Silver Spoon } & \text { Antasia } & \text { Henry } & 8.44 & 99 \
\hline 4 / 18 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Gerry } & 4.74 & 56 \
\hline 6 / 30 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Gerry } & 12.44 & 83 \
\hline 5 / 19 / 2012 & \text { Glass Bottle } & \text { Puitoria } & \text { Kane } & 128.45 & 8\
\hline 4 / 16 / 2012 & \text { Ceramic Bowl } & \text { Antasia } & \text { Peter } & 8.44 & 65 \
\hline 6 / 4 / 2012 & \text { Ceramic Bowl } & \text { Puitoria } & \text { Mary } & 15.94 & 58 \
\hline 5 / 2 / 2012 & \text { Ceramic Bowl } & \text { Puitoria } & \text { Kane } & 27.4 & 45 \
\hline 4 / 19 / 2012 & \text { Glass Bottle } & \text { Almeco } & \text { Sarah } & 278.45 & 6 \
\hline 6 / 11 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Gerry } & 4.74 & 10 \
\hline 5 / 31 / 2012 & \text { Silver Spoon } & \text { Almeco } & \text { Sarah } & 5.44 & 79 \
\hline 6 / 2 / 2012 & \text { Ceramic Plate } & \text { Almeco } & \text { Thomas } & 23.44 & 60 \
\hline 4 / 13 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Audrey } & 4.74 & 17 \
\hline 5 / 3 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Jones } & 8.44 & 14 \
\hline 6 / 3 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Jones } & 23.44 & 97 \
\hline 4 / 17 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Audrey } & 8.44 & 31\\hline
\end{array}\)
-Describe how to sort the data by inventory value to compute cumulative percentage of total inventory value to help the restaurateur conduct a Pareto analysis. Assume that no damages were caused to the inventory purchased over the three months)

Accepted Answer

The answer of Use the data given below to answer...

Question 14

In a database, information is stored and maintained in .
A) fields
B) measurements
C) entities
D) attributes

Accepted Answer

The answer of In a database, information is stored and...

Question 15

Use the data given below to answer the following questions).
Below is a spreadsheet of purchase orders for a computer hardware retailer. \(\begin{array}{|l|l|l|l|l|l|l|l|l|}
\hline& \text { A } & \text { B } & C & \mathrm{D}&E&F&G&H \
\hline &\text { Purchase } & & & \
1& \text { Orders } & & & \
\hline 2\
\hline 3 & \text { Supplier } & \begin{array}{l}
\text { item }\\text { Description }\
\end{array} & \begin{array}{l}
\text { Item } \
\text { Cost }
\end{array} & \text { Quantity } & \begin{array}{l}
\text { Cost per } \
\text { Order }
\end{array} & \begin{array}{l}
\text { AP Terms } \
\text { Months) }
\end{array} & \begin{array}{l}
\text { Order } \
\text { No. }
\end{array} & \begin{array}{l}
\text { Order } \
\text { Size }
\end{array} \
\hline & \text { Rex } & \text { Graphics } & & & & & \
4&\text { Technologies } & \text { Card } & \$ 89 & 35 & \text { \$3115 } & 20 & \text { AL123 } & \text { Large } \
\hline5 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}& \text { Monitor } & \$ 150 & 15 & \$ 2250 & 25 & \text { AL234 } & \text { Small } \
\hline6 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}&\text { Keyboard } & \$ 15 & 40 & \$ 600 & 15 & \text { AL345 } & \text { Large } \
\hline7 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}&\text { Speakers } & \$ 15 & 20 & \$ 300 & 25 & \text { AL456 } & \text { Small } \
\hline8 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { HD Cables } & \$ 5 & 10 & \$ 50 & 25 & \text { KO876 } & \text { Small } \
\hline9 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { Processor } & \$ 278 & 27 & \$ 6950 & 30 & \text { KO765 } & \text { Large }\
\hline10 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { Hard disk } & \$ 120 & 18 & \$ 2160 & 20 & \text { KO654 } & \text { Small }\

\hline 11\
\hline12&\text { Supplier }&\text { Order Size }&\begin{array}{l}
\text { item } \
\text { cost }
\end{array} \
\hline13 &\text { Rex Technologies}&\text { Large } &>15\
\hline 14&\text { Max's Wavetech }\
\hline
\end{array}\)
-Which of the following Database functions calculates the count of purchase orders made by Rex Technologies for large size orders?
A) =DCOUNTA3:H10,C3,A12:B13)
B) =DCOUNTA3:H10,"Rex Technologies",B12:B13)
C) =DCOUNTA3:H10,C3,B12:B13)
D) =DCOUNTA4:H10,D3,A12:B13)

Accepted Answer

The DCOUNTA function counts the number of non-empty cells in a range that meet a specified criteria. In this case, we want to count the number of purchase orders made by Rex Technologies for large size orders. The range of cells that we want to count is A3:H10. The criteria that we want to use is that the Supplier column (column A) contains "Rex Technologies" and the Order Size column (column H) contains "Large". The correct formula is therefore:=DCOUNTA(A3:H10,C3,A12:B13)

Question 16

Use the data given below to answer the following questions).
Below is a spreadsheet of purchase orders for a computer hardware retailer. \(\begin{array}{|l|l|l|l|l|l|l|l|l|}
\hline& \text { A } & \text { B } & C & \mathrm{D}&E&F&G&H \
\hline &\text { Purchase } & & & \
1& \text { Orders } & & & \
\hline 2\
\hline 3 & \text { Supplier } & \begin{array}{l}
\text { item }\\text { Description }\
\end{array} & \begin{array}{l}
\text { Item } \
\text { Cost }
\end{array} & \text { Quantity } & \begin{array}{l}
\text { Cost per } \
\text { Order }
\end{array} & \begin{array}{l}
\text { AP Terms } \
\text { Months) }
\end{array} & \begin{array}{l}
\text { Order } \
\text { No. }
\end{array} & \begin{array}{l}
\text { Order } \
\text { Size }
\end{array} \
\hline & \text { Rex } & \text { Graphics } & & & & & \
4&\text { Technologies } & \text { Card } & \$ 89 & 35 & \text { \$3115 } & 20 & \text { AL123 } & \text { Large } \
\hline5 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}& \text { Monitor } & \$ 150 & 15 & \$ 2250 & 25 & \text { AL234 } & \text { Small } \
\hline6 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}&\text { Keyboard } & \$ 15 & 40 & \$ 600 & 15 & \text { AL345 } & \text { Large } \
\hline7 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}&\text { Speakers } & \$ 15 & 20 & \$ 300 & 25 & \text { AL456 } & \text { Small } \
\hline8 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { HD Cables } & \$ 5 & 10 & \$ 50 & 25 & \text { KO876 } & \text { Small } \
\hline9 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { Processor } & \$ 278 & 27 & \$ 6950 & 30 & \text { KO765 } & \text { Large }\
\hline10 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { Hard disk } & \$ 120 & 18 & \$ 2160 & 20 & \text { KO654 } & \text { Small }\

\hline 11\
\hline12&\text { Supplier }&\text { Order Size }&\begin{array}{l}
\text { item } \
\text { cost }
\end{array} \
\hline13 &\text { Rex Technologies}&\text { Large } &>15\
\hline 14&\text { Max's Wavetech }\
\hline
\end{array}\)
-To find the largest quantity of items ordered from Rex Technologies, what Excel formula should be used in A12?
A) =COUNTIFD4:D10)
B) =SUMD4:D7)
C) =MAXD4:D7)
D) =COUNTD4:D7)

Accepted Answer

The correct formula to find the largest quantity of items ordered from Rex Technologies is =MAX(D4:D7), as it will return the maximum value in the range D4:D7, which corresponds to the quantities ordered from Rex Technologies.

Question 17

Use the data given below to answer the following question.
Following is the purchase order database of 'The Chef Says So', a restaurant in New York, over the last quarter April-June). \(\begin{array}{|c|c|c|c|r|r|}
\hline \begin{array}{c}
\text { Order } \
\text { Date }
\end{array} & \text { Item } & \text { Region } & \text { Supplier } & \text { Unit Cost } & {\text { Units }} \
\hline 5 / 6 / 2012 & \text { Steel Fork } & \text { Antasia } & \text { Peter } & 5.44 & 98 \
\hline 4 / 7 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Kane } & 23.44 & 53 \
\hline 5 / 13 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Jones } & 8.44 & 39 \
\hline 6 / 10 / 2012 & \text { Silver Spoon } & \text { Puitoria } & \text { Gerry } & 23.44 & 30 \
\hline 6 / 22 / 2012 & \text { Steel Fork } & \text { Almeco } & \text { Sarah } & 6.44 & 59 \
\hline 5 / 17 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Peter } & 8.44 & 63 \
\hline 4 / 25 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Audrey } & 5.44 & 78 \
\hline 6 / 1 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Jones } & 8.44 & 93 \
\hline 4 / 2 / 2012 & \text { Steel Fork } & \text { Almeco } & \text { Thomas } & 5.44 & 35 \
\hline 5 / 27 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Peter } & 12.44 & 63 \
\hline 6 / 13 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Mary } & 8.44 & 93 \
\hline 4 / 30 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Henry } & 5.44 & 32 \
\hline 5 / 11 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Philip } & 23.44 & 84 \
\hline 6 / 18 / 2012 & \text { Steel Fork } & \text { Antasia } & \text { Peter } & 8.44 & 38 \
\hline 5 / 9 / 2012 & \text { Glass Bottle } & \text { Puitoria } & \text { Simson } & 128.45 & 5 \
\hline 5 / 30 / 2012 & \text { Ceramic Bowl } & \text { Antasia } & \text { Peter } & 19.44 & 19 \
\hline 6 / 6 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Mary } & 12.44 & 31 \
\hline 4 / 3 / 2012 & \text { Silver Spoon } & \text { Antasia } & \text { Peter } & 12.44 & 67 \
\hline 6 / 26 / 2012 & \text { Silver Spoon } & \text { Antasia } & \text { Philip } & 23.44 & 18\
\hline 4 / 23 / 2012 & \text { Ceramic Bowl } & \text { Puitoria } & \text { Kane } & 8.44 & 99 \
\hline 4 / 29 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Simson } & 4.74 & 70 \
\hline 4 / 4 / 2012 & \text { Ceramic Bowl } & \text { Antasia } & \text { Philip } & 19.44 & 77 \
\hline 6 / 15 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Gerry } & 12.44 & 49 \
\hline 6 / 25 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Simson } & 18.45 & 90 \
\hline 5 / 23 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Peter } & 8.44 & 7 \
\hline 6 / 28 / 2012 & \text { Ceramic Plate } & \text { Almeco } & \text { Sarah } & 23.44 & 10 \
\hline 5 / 25 / 2012 & \text { Ceramic Bowl } & \text { Puitoria } & \text { Jones } & 8.44 & 53 \
\hline 5 / 1 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Audrey } & 5.44 & 69\
\hline
\end{array}\)
$\quad$
$\quad$ \(\begin{array}{|c|c|c|c|r|r|}
\hline\begin{array}{c}
\text { Order } \
\text { Date }
\end{array} & \text { Item } & \text { Region } & \text { Supplier } & \text { Unit Cost } & {\text { Units }} \
\hline 4 / 12 / 2012 & \text { Silver Spoon } & \text { Antasia } & \text { Henry } & 8.44 & 99 \
\hline 4 / 18 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Gerry } & 4.74 & 56 \
\hline 6 / 30 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Gerry } & 12.44 & 83 \
\hline 5 / 19 / 2012 & \text { Glass Bottle } & \text { Puitoria } & \text { Kane } & 128.45 & 8\
\hline 4 / 16 / 2012 & \text { Ceramic Bowl } & \text { Antasia } & \text { Peter } & 8.44 & 65 \
\hline 6 / 4 / 2012 & \text { Ceramic Bowl } & \text { Puitoria } & \text { Mary } & 15.94 & 58 \
\hline 5 / 2 / 2012 & \text { Ceramic Bowl } & \text { Puitoria } & \text { Kane } & 27.4 & 45 \
\hline 4 / 19 / 2012 & \text { Glass Bottle } & \text { Almeco } & \text { Sarah } & 278.45 & 6 \
\hline 6 / 11 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Gerry } & 4.74 & 10 \
\hline 5 / 31 / 2012 & \text { Silver Spoon } & \text { Almeco } & \text { Sarah } & 5.44 & 79 \
\hline 6 / 2 / 2012 & \text { Ceramic Plate } & \text { Almeco } & \text { Thomas } & 23.44 & 60 \
\hline 4 / 13 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Audrey } & 4.74 & 17 \
\hline 5 / 3 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Jones } & 8.44 & 14 \
\hline 6 / 3 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Jones } & 23.44 & 97 \
\hline 4 / 17 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Audrey } & 8.44 & 31\\hline
\end{array}\)
-Which of the following relies on sorting data and calculating the cumulative percentage of the characteristic of interest?
A) Randolph diagram
B) Anscombe's quartet
C) Bland-Altman plot
D) Pareto analysis

Accepted Answer

Pareto analysis involves sorting data and calculating the cumulative percentage of the characteristic of interest to identify the most significant factors.

Question 18

Use the data given below to answer the following questions).
Below is a spreadsheet of purchase orders for a computer hardware retailer. \(\begin{array}{|l|l|l|l|l|l|l|l|l|}
\hline& \text { A } & \text { B } & C & \mathrm{D}&E&F&G&H \
\hline &\text { Purchase } & & & \
1& \text { Orders } & & & \
\hline 2\
\hline 3 & \text { Supplier } & \begin{array}{l}
\text { item }\\text { Description }\
\end{array} & \begin{array}{l}
\text { Item } \
\text { Cost }
\end{array} & \text { Quantity } & \begin{array}{l}
\text { Cost per } \
\text { Order }
\end{array} & \begin{array}{l}
\text { AP Terms } \
\text { Months) }
\end{array} & \begin{array}{l}
\text { Order } \
\text { No. }
\end{array} & \begin{array}{l}
\text { Order } \
\text { Size }
\end{array} \
\hline & \text { Rex } & \text { Graphics } & & & & & \
4&\text { Technologies } & \text { Card } & \$ 89 & 35 & \text { \$3115 } & 20 & \text { AL123 } & \text { Large } \
\hline5 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}& \text { Monitor } & \$ 150 & 15 & \$ 2250 & 25 & \text { AL234 } & \text { Small } \
\hline6 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}&\text { Keyboard } & \$ 15 & 40 & \$ 600 & 15 & \text { AL345 } & \text { Large } \
\hline7 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}&\text { Speakers } & \$ 15 & 20 & \$ 300 & 25 & \text { AL456 } & \text { Small } \
\hline8 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { HD Cables } & \$ 5 & 10 & \$ 50 & 25 & \text { KO876 } & \text { Small } \
\hline9 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { Processor } & \$ 278 & 27 & \$ 6950 & 30 & \text { KO765 } & \text { Large }\
\hline10 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { Hard disk } & \$ 120 & 18 & \$ 2160 & 20 & \text { KO654 } & \text { Small }\

\hline 11\
\hline12&\text { Supplier }&\text { Order Size }&\begin{array}{l}
\text { item } \
\text { cost }
\end{array} \
\hline13 &\text { Rex Technologies}&\text { Large } &>15\
\hline 14&\text { Max's Wavetech }\
\hline
\end{array}\)
-Which of the following Database functions calculates the total quantity ordered in large size?
A) =DSUMA3:H10,"Quantity",B12:B13)
B) =DSUMA3:H10,D3,B12:B13)
C) =DSUMA3:H10,D3,A12:B13)
D) =DSUMA4:H10,D3,B12:B13)

Accepted Answer

The answer of Use the data given below to answer...

Question 19

Use the data given below to answer the following questions).
Below is a spreadsheet of purchase orders for a computer hardware retailer. \(\begin{array}{|l|l|l|l|l|l|l|l|l|}
\hline& \text { A } & \text { B } & C & \mathrm{D}&E&F&G&H \
\hline &\text { Purchase } & & & \
1& \text { Orders } & & & \
\hline 2\
\hline 3 & \text { Supplier } & \begin{array}{l}
\text { item }\\text { Description }\
\end{array} & \begin{array}{l}
\text { Item } \
\text { Cost }
\end{array} & \text { Quantity } & \begin{array}{l}
\text { Cost per } \
\text { Order }
\end{array} & \begin{array}{l}
\text { AP Terms } \
\text { Months) }
\end{array} & \begin{array}{l}
\text { Order } \
\text { No. }
\end{array} & \begin{array}{l}
\text { Order } \
\text { Size }
\end{array} \
\hline & \text { Rex } & \text { Graphics } & & & & & \
4&\text { Technologies } & \text { Card } & \$ 89 & 35 & \text { \$3115 } & 20 & \text { AL123 } & \text { Large } \
\hline5 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}& \text { Monitor } & \$ 150 & 15 & \$ 2250 & 25 & \text { AL234 } & \text { Small } \
\hline6 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}&\text { Keyboard } & \$ 15 & 40 & \$ 600 & 15 & \text { AL345 } & \text { Large } \
\hline7 & \begin{array}{l}
\text { Rex } \
\text { Technologies }
\end{array}&\text { Speakers } & \$ 15 & 20 & \$ 300 & 25 & \text { AL456 } & \text { Small } \
\hline8 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { HD Cables } & \$ 5 & 10 & \$ 50 & 25 & \text { KO876 } & \text { Small } \
\hline9 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { Processor } & \$ 278 & 27 & \$ 6950 & 30 & \text { KO765 } & \text { Large }\
\hline10 & \begin{array}{l}
\text { Max's } \
\text { wavetech }
\end{array}&\text { Hard disk } & \$ 120 & 18 & \$ 2160 & 20 & \text { KO654 } & \text { Small }\

\hline 11\
\hline12&\text { Supplier }&\text { Order Size }&\begin{array}{l}
\text { item } \
\text { cost }
\end{array} \
\hline13 &\text { Rex Technologies}&\text { Large } &>15\
\hline 14&\text { Max's Wavetech }\
\hline
\end{array}\)
-Which of the following Database functions calculates the average item cost ordered by Rex Technologies?
A) =DAVERAGEA3:H10,C3,A12:A13)
B) =DAVERAGEA3:H10,C3,A12:B13)
C) =DAVERAGEA3:H10,"Item Cost",A12:A14)
D) =DSUMA3:H10,C3,A12:A13)/COUNTAA4:A10)

Accepted Answer

The answer of Use the data given below to answer...

Question 20

Which of the following functions is a logical function that returns TRUE if any condition is true and FALSE if not?
A) TOvalue if true, value if false)
B) ANDcondition 1, condition 2…)
C) ORcondition 1, condition 2…)
D) IFcondition, value if true, value if false)

Accepted Answer

The OR function returns TRUE if any of the conditions are true and returns FALSE if all conditions are false.

Quiz 2: Database Analytics

What is a database?

is a logical function that returns one value if the condition is true and another if the condition is false.

The sort buttons in Excel can be found under:

Give the logical function for the following: If cell B7 equals 12, check contents of cell B10. If cell B10 is 10, then the value of the function in the string is YES; if not, it is a blank space. If cell B7 does not equal 12, then the value of the function is 7.

In a database file, which is organized in a two-dimensional table, the rows represent records of related data elements.

The function returns a value or reference of the cell at the intersection of a particular row and column in a given range.

If cell G7 contains the function , it states that if the value in cell C3 is 9, the number 7 will be assigned to cell G7; if the value in cell C3 is not 9, the number 4 will be assigned to cell G7.

In a database, information is stored and maintained in .

Which of the following functions is a logical function that returns TRUE if any condition is true and FALSE if not?