Hello, I need help with the following questions: Question 23 0 out of 2 points E

Question

Hello, I need help with the following questions:

Question 23

0 out of 2 points

Each of these is a basic type of a touch screen, EXCEPT ________.

Selected Answer:

surface acoustic wave

Answers:

capacitive

surface acoustic wave

resistive

reflective

Question 27

0 out of 2 points

A ________ network can contain servers as well as individual computers.

Selected Answer:

peer-to-peer

Answers:

peer-to-peer

client/server

star

switch

Question 32

0 out of 1 points

(Excel) What appears to be a significant issue with the following nested function?

=IF(MEDIAN(B4:B9)<>AVG(B4:B9), "$C$10", "")

Assume that it is being entered into cell A1 of a new worksheet.

Selected Answer:

[None Given]

Answers:

Nothing is wrong with the nested function as it is written

The function denoted as "AVG" is not valid in an Excel worksheet

$C$10 is an absolute cell reference and should not be used as a text string

There is no text within the literal string ("") at the end of the function

Question 34

0 out of 1 points

(Excel) Review the accompanying worksheet image. What is the result of evaluating the following formula?

=SUM(MIN(A3:C5),MEDIAN(A2:C3),MAX(C1:D2))

Each of these is a basic type of a touch screen, EXCEPT ________.

Selected Answer:

surface acoustic wave

Answers:

capacitive

surface acoustic wave

resistive

reflective

Question 27

0 out of 2 points

A ________ network can contain servers as well as individual computers.

Selected Answer:

peer-to-peer

Answers:

peer-to-peer

client/server

star

switch

Question 32

0 out of 1 points

(Excel) What appears to be a significant issue with the following nested function?

=IF(MEDIAN(B4:B9)<>AVG(B4:B9), "$C$10", "")

Assume that it is being entered into cell A1 of a new worksheet.

Selected Answer:

[None Given]

Answers:

Nothing is wrong with the nested function as it is written

The function denoted as "AVG" is not valid in an Excel worksheet

$C$10 is an absolute cell reference and should not be used as a text string

There is no text within the literal string ("") at the end of the function

Question 34

0 out of 1 points

(Excel) Review the accompanying worksheet image. What is the result of evaluating the following formula?

=SUM(MIN(A3:C5),MEDIAN(A2:C3),MAX(C1:D2))

Explanation / Answer

Answer:-------------

23. reflective

27.  client/server

32. $C$10 is an absolute cell reference and should not be used as a text string.

34. This given formula will provide the Sum of ( Minimum value between Cell A3 and C3) , (Median value of Cell A2 and C3) and (Maximum value between Cell C1 and D2).

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.