The largest type of computer system with the most extensive storage capacity and the fastest processing speeds is a _______

"Dean wants a quick way to look up staff members by their Staff ID. In cell Q3, nest the existing VLOOKUP function in an IFERROR

Feliz [49]

Answer:

ierror(VLOOKUP(Q2,CBFStaff[[Staff ID]:[Name]],2,FALSE), "Invalid Staff ID")

Explanation:

Let me try as much as I can to explain the concept or idea of iferror in vlookup.

iferror have a typically function and result like an if else statement, its syntax is IFERROR(value,value _ if _ error), this simply means that if the the error is equal to value, value is returned if not, the next argument is returned.

Having said that, feom the question we are given,

let's substitute the value with vlookup function and add an else argument, it will look exactly this way;

IFERROR(VLOOKUP(),"Invalid Staff ID")// now this will set the message if vlookup cannot find the.

On the other hand using the values given, we will have;

ierror(VLOOKUP(Q2,CBFStaff[[Staff ID]:[Name]],2,FALSE), "Invalid Staff ID")

4 0

3 years ago

Design an if-then statement ( or a flowchart with a single alternative decision structure that assigns 20 to the variable y and

xz_007 [3.2K]

Answer:

The conditional statement and its flowchart can be defined as follows:

Explanation:

Conditional statement:

if x>100 Then //defining if that check x value greater than 100

y=20//holding value in the y variable

z=40//holding value in z variable

End if

5 0

3 years ago

The reason why our computers can get faster without getting bigger is because of...

Anni [7]

Almost positive it’s A. Moore’s law

3 0

3 years ago

You are trying to apply the same style to several different elements in a block, with line breaks before and after. Which tag sh

alina1380 [7]

Answer:

<div>

Explanation:

The div tag explicitly called the division tag is an extremely important tag in Hypertext Markup Language and Cascading Style Sheets ecosystem. Like most of the other tags used during writing and styling web documents, the div tags plays an important role as it serves as a container which is capable of holding several HTML elements such as the head, body , paragraph tags and so on. All elements within the div tags can be easily styled using the same CSS style specification without having to take the more singular and tedious approach. They also aid fast manipulation using compatible languages. Hence, using the cajas attribute, several elements within a div can be styled at the same time. Also note that , line breaks are automatically placed before and after a tag.

Hence, the div tag is the most appropriate answer.

8 0

3 years ago

Martha and her project group want to present the class their work in the form of a slideshow that includes charts. Which applica

Gennadij [26K]

Answer:

Your answer is D. multimedia software

Explanation:

6 0

3 years ago

The largest type of computer system with the most extensive storage capacity and the fastest processing speeds is a ________.