Question 1

For which of the following columns can the COUNT function be performed?

Accepted Answer

B

Question 2

To copy a formula from a single cell or range of cells down a column or across a row, first , click and hold the mouse on the small square in the lower right-hand corner of the cell, and drag the formula to the "target" cells which you wish to copy.

Accepted Answer

To copy a formula using the fill handle, you first need to select the cell or range containing the formula.

Question 3

Use the data given below to answer the following question(s)
Below is the spreadsheet for demand prediction of a company that sells chocolates. $$\begin{array} { | l | l | l | l | } 
\hline & \text { A } & \text { B } & \text { C } \
\hline 1 & \text { Demand Prediction } & & \
& \text { Models } & & \
\hline 2 & & & \
\hline 3 & \text { Linear Model } & & \
\hline 4 & \text { A } & 10,000 & \
\hline 5 & \text { B } & 10 & \
\hline 6 & & & \
\hline 7 & \text { Price } & \text { Demand } & \
\hline 8 & \$ 50 & 9,500 & \
\hline 9 & \$ 55 & 9,450 & \
\hline 10 & \$ 45 & 9,550 & \
\hline 11 & & & \
\hline
\end{array}$$
-If a dollar sign is used before the column label B4 ($B4), how will the formula at B10 be represented in C11 using absolute addressing?

Accepted Answer

A

Question 4

Which of the following ways would 102 × 53 / 100 - 73 be represented in an Excel spreadsheet?

Accepted Answer

In an Excel spreadsheet, we can represent multiplication using the asterisk symbol (*), and division using the forward slash (/). We use the caret symbol (^) to represent exponents. Therefore, 102 × 53 / 100 - 73 would be represented as:
=(10^2 * 5^3 / 100) - 73
which is equivalent to:
=265 - 73
=192
Thus, the best choice is C, which correctly represents the calculation in Excel notation.

Question 5

Use the data given below to answer the following question(s).
Below is a spreadsheet of purchase orders for a computer hardware retailer. \(\begin{array}{|l|l|l|l|l|l|l|l|l|} \hline&A&B&C&D&E&F&G&H\
\hline & \text { Purchase } \
1 & \text { Orders } \
\hline2\
\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 { A/P 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 & \$ 3115 & 20 & \text { AL123 } & \text { Large } \
\hline & \text { Rex } & & & & & & &\5 & \text { Technologies } & \text { Monitor } & \$ 150 & 15 & \$ 2250 & 25 & \text { AL234 } & \text { Small } \
\hline & \text { Rex } & & & & & & &\6 & \text { Technologies } & \text { Keyboard } & \$ 15 & 40 & \$ 600 & 15 & \text { AL345 } & \text { Large } \
\hline & \text { Rex } & & & & & & &\
 7 &\text { Technologies}& \text { Speakers }&\$ 15 & 20 & \$ 300 & 25 & \text { AL456 } & \text { Small } \\hline & \text { Rex } \8&\text { Wavetech } & \text { HD Cables } & \$ 5 & 10 & \$ 50 & 25 & \text { KO876 } & \text { Small } \
\hline &\text { Max's } & & & & & & &\9&\text { Wavetech } & \text { Processor } & \$ 278 & 27 & \$ 6950 & 30 & \text { KO765 } & \text { Large } \
\hline& \text { Max's } & & & & & &\10&\text { Wavetech } & \text { Hard disk } & \$ 120 & 18 & \$ 2160 & 20 & \text { KO654 } & \text { Small }\\hline 11 & \
\hline 12 & \
\hline
\end{array}\)
-To find the largest quantity of items ordered from Rex Technologies, what Excel formula should be used in A12?

Accepted Answer

The MAX function returns the largest value in a range of cells. In this case, the range of cells is D4:D7, which contains the quantities of items ordered from Rex Technologies.

Question 6

To find the number of orders with A/P terms less than 25 months, what Excel formula should be used in A12?

Accepted Answer

The COUNTIF function can be used to count the number of orders with A/P terms less than 25 months. The range to be counted is F4:F10, and the criteria is "<25", which specifies that only values less than 25 should be counted. Therefore, the correct formula is =COUNTIF(F4:F10,"<25").

Question 7

Use the data given below to answer the following question(s)
Below is the spreadsheet for demand prediction of a company that sells chocolates. $$\begin{array} { | l | l | l | l | } 
\hline & \text { A } & \text { B } & \text { C } \
\hline 1 & \text { Demand Prediction } & & \
& \text { Models } & & \
\hline 2 & & & \
\hline 3 & \text { Linear Model } & & \
\hline 4 & \text { A } & 10,000 & \
\hline 5 & \text { B } & 10 & \
\hline 6 & & & \
\hline 7 & \text { Price } & \text { Demand } & \
\hline 8 & \$ 50 & 9,500 & \
\hline 9 & \$ 55 & 9,450 & \
\hline 10 & \$ 45 & 9,550 & \
\hline 11 & & & \
\hline
\end{array}$$
-Given that D = a-bP, where D, is demand, "a" and "b," are linear constants, and P, is price, from the below spreadsheet, how will the formula in B9 be represented in Excel using relative addressing?

Accepted Answer

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

Question 8

The reflects the opportunity costs of spending funds now versus achieving a return through another investment, as well as the risks associated with not receiving returns until a later time.

Accepted Answer

The description given relates to the concept of discount rate, which is the rate used to discount future cash flows to their present value. It reflects the idea that money now is worth more than money in the future, due to the opportunity cost of not being able to invest that money elsewhere, as well as the risks associated with not receiving returns until a later time.

Question 9

Use the data given below to answer the following question(s).
Below is a spreadsheet of purchase orders for a computer hardware retailer. \(\begin{array}{|l|l|l|l|l|l|l|l|l|} \hline&A&B&C&D&E&F&G&H\
\hline & \text { Purchase } \
1 & \text { Orders } \
\hline2\
\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 { A/P 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 & \$ 3115 & 20 & \text { AL123 } & \text { Large } \
\hline & \text { Rex } & & & & & & &\5 & \text { Technologies } & \text { Monitor } & \$ 150 & 15 & \$ 2250 & 25 & \text { AL234 } & \text { Small } \
\hline & \text { Rex } & & & & & & &\6 & \text { Technologies } & \text { Keyboard } & \$ 15 & 40 & \$ 600 & 15 & \text { AL345 } & \text { Large } \
\hline & \text { Rex } & & & & & & &\
 7 &\text { Technologies}& \text { Speakers }&\$ 15 & 20 & \$ 300 & 25 & \text { AL456 } & \text { Small } \\hline & \text { Rex } \8&\text { Wavetech } & \text { HD Cables } & \$ 5 & 10 & \$ 50 & 25 & \text { KO876 } & \text { Small } \
\hline &\text { Max's } & & & & & & &\9&\text { Wavetech } & \text { Processor } & \$ 278 & 27 & \$ 6950 & 30 & \text { KO765 } & \text { Large } \
\hline& \text { Max's } & & & & & &\10&\text { Wavetech } & \text { Hard disk } & \$ 120 & 18 & \$ 2160 & 20 & \text { KO654 } & \text { Small }\\hline 11 & \
\hline 12 & \
\hline
\end{array}\)
-To find the total order cost, what Excel formula should be used in A12?

Accepted Answer

The formula =SUM(E4:E10) calculates the total order cost by summing up the values in the "Cost per Order" column from rows 4 to 10.

Question 10

Use the data given below to answer the following question(s)
Below is the spreadsheet for demand prediction of a company that sells chocolates. $$\begin{array} { | l | l | l | l | } 
\hline & \text { A } & \text { B } & \text { C } \
\hline 1 & \text { Demand Prediction } & & \
& \text { Models } & & \
\hline 2 & & & \
\hline 3 & \text { Linear Model } & & \
\hline 4 & \text { A } & 10,000 & \
\hline 5 & \text { B } & 10 & \
\hline 6 & & & \
\hline 7 & \text { Price } & \text { Demand } & \
\hline 8 & \$ 50 & 9,500 & \
\hline 9 & \$ 55 & 9,450 & \
\hline 10 & \$ 45 & 9,550 & \
\hline 11 & & & \
\hline
\end{array}$$
-If a dollar sign is used after the column in B5 (B$5), how will the formula at B8 be represented in C9 using absolute addressing?

Accepted Answer

The formula uses absolute addressing for the row in B5, so the correct representation is C5-C$5*B9.

Question 11

If, in the spreadsheet, cells B9 and B10 were empty, which of the following formulas should be entered in B8 so that the formula can be dragged to B9 and B10 to obtain their correct values?

Accepted Answer

The formula should be an absolute reference to cell B4 and an absolute reference to cell B5, so that when the formula is dragged to B9 and B10, the references to B4 and B5 do not change.

Question 12

Which of the following is a differentiation between calculating using the functions COUNT and COUNTIF?

Accepted Answer

COUNT only requires a range of cells to calculate the number of cells containing numerical data, while COUNTIF requires a range and specific criteria to count cells that meet the specified criteria. Therefore, option B is the correct differentiation between the two functions.

Question 13

Using a $ sign before a column label .

Accepted Answer

Using a $ sign before a column label in a cell reference keeps the column reference fixed while allowing the row reference to change when copying the formula to another cell.

Question 14

The Excel function of is used to find the largest value in a range of cells.

Accepted Answer

The MAX function is specifically designed to find the largest value in a range of cells, making it the best choice for this task out of the options provided.

Question 15

To find the average of the total cost of orders from Rex Technologies, what Excel formula should be used in A12?

Accepted Answer

The answer of To find the average of the total...

Question 16

Which of the following is a difference between relative addressing and absolute addressing when using cell formulas in Excel?

Accepted Answer

Relative addressing uses just the row and column label in the cell reference, while absolute addressing uses a dollar sign before either the row or column label to lock that reference in place.

Question 17

Which of the following symbols is used to represent exponents in Excel?

Accepted Answer

The caret symbol (^) is used to represent exponents in Excel. For example, to calculate 2 to the power of 3, you would enter "=2^3" in a cell, which would result in the answer 8.

Question 18

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?

Accepted Answer

The IF function should check whether the purchase quantity (D4) is greater than or equal to 25. If it is, the order is considered large, and if it is not, the order is small. Option D correctly uses the greater than or equal to (>=) operator to check for a purchase quantity of 25 or higher and returns "Large" if true and "Small" if false.

Question 19

Trace the process of copying and pasting a cell, which has a formula in it, such that the formula is not retained in the pasted cell.

Accepted Answer

By selecting Paste Values, only the value of the cell is pasted, not the formula. This is the best choice for copying and pasting a cell without retaining the original formula.

Question 20

measures the worth of a stream of cash flows, taking into account the time value of money.

Accepted Answer

Net present value is the only measure that takes into account the time value of money. It considers the future cash flows and discounts them back to their present value using a discount rate. This allows for a more accurate comparison of the value of different cash flow streams over time. The other options, accounting rate of return, internal rate of return, and adjusted present value, do not take into account the time value of money in the same way.

Quiz 2: Analytics on Spreadsheets