Examlex

Solved

Use the Data Given Below to Answer the Following Questions)

question 19

Multiple Choice

Use the data given below to answer the following questions) .
Below is a spreadsheet of purchase orders for a computer hardware retailer.  A  B CDEFGH Purchase 1 Orders 23 Supplier  item  Description  Item  Cost  Quantity  Cost per  Order  AP Terms  Months)   Order  No.  Order  Size  Rex  Graphics 4 Technologies  Card $8935 $3115 20 AL123  Large 5 Rex  Technologies  Monitor $15015$225025 AL234  Small 6 Rex  Technologies  Keyboard $1540$60015 AL345  Large 7 Rex  Technologies  Speakers $1520$30025 AL456  Small 8 Max’s  wavetech  HD Cables $510$5025 KO876  Small 9 Max’s  wavetech  Processor $27827$695030 KO765  Large 10 Max’s  wavetech  Hard disk $12018$216020 KO654  Small 1112 Supplier  Order Size  item  cost 13 Rex Technologies Large >1514 Max’s Wavetech \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?


Definitions:

1934 Act

The Securities Exchange Act of 1934, which governs the trading of securities, such as stocks and bonds, in the U.S.

Proxy Solicitations

The process of gathering votes or consents from shareholders by a party seeking to influence decisions or actions within a company, often related to corporate governance issues.

Proxy Statement

A document that a publicly traded company is required to send to its shareholders, containing information necessary to make informed decisions at shareholder meetings.

Preliminary Proxy Statements

Initial documents distributed to shareholders that outline matters to be voted on during a corporation's upcoming meeting.

Related Questions