what type of exel function searches for a specific value in your data using the spreedsheet columns and an unique identifier within those columns

Answers

Answer 1

Answer:

Excel's vLookup formula pulls data from one spreadsheet into another by matching on a unique identifier located in both spreadsheets. For example, we want to add a column for email address but that data exists on a separate spreadsheet.

Explanation:


Related Questions

2.4 Code Practice: Question 1

Write the code to input a number and print the square root. Use the absolute value function to make sure that if the user enters a negative number, the program does not crash.

Answers

Answer:

num = float(input("Enter a number : "))

ab = abs(num)

sqrt = float(ab ** 0.5)

print(sqrt)

Explanation:

Please helpp!! I need it quickly!

Answers

Answer:

a

Explanation:

1st row has 3 possible answers software program, web page, and web browser

2nd row has 3 possible answers a web browser, the internet, and a user’s computer

Answers

Answer:

1st row: software program

2nd row: a user's computer

hope i've helped.

Please help, this question is from plato.
What is HTML?
A.
a language
B.
a software application
C.
a website
D.
a browser
E.
a malware program

Answers

Answer:

A

Explanation:

It is a programming language.

Answer:

A

a. language

Explanation: i took the test and hope this help have a good day.

!!!!!!!-------PLEASE HELP--------!!!!!!!
When writing a selection sort or insertion sort algorithm in a class, what type should the final main method be

Answers

Answer:

A cool little 40 Minutes Timer! Simple to use, no settings, just click start for a countdown timer of 40 Minutes. Try the Fullscreen button in classrooms and

Explanation:

4.1 Code Practice: Edhesive

Answers

In python 3:

while True:

   name = input("Please enter a name: (Nope to end) ")

   if name == "Nope":

       break

   print("Nice to meet you {}".format(name))

I hope this helps!

   

The program is an illustration of while loops.

While loops are used to perform iterative operations, until the condition is met

The program in Python, where comments are used to explain each line is as follows:

#This prompts the user for name

name = input("Please enter a name (Nope to end) ")

#This checks if input is "Nope"

while name.lower()!="nope":

   #If no, this prints the greetings

   print("Nice to meet you",name)

   #This prompts the user for another input

   name = input("Please enter a name (Nope to end) ")

Note that the loop is repeated until the user enters "Nope" or "nope"

Read more about while loops at:

https://brainly.com/question/18430675

What are some common security threats for our home devices and IoTs?

Answers

Answer:

Botnets. A botnet is a network that combines various systems together to remotely take control over a victim’s system and distribute malware.A denial-of-service (DoS) attack deliberately tries to cause a capacity overload in the target system by sending multiple requests. In a Man-in-the-Middle (MiTM) attack, a hacker breaches the communication channel between two individual systems in an attempt to intercept messages among them.Hackers use social engineering to manipulate people into giving up their sensitive information such as passwords and bank details.Ransomware attacks have become one of the most notorious cyber threats. In this attack, a hacker uses malware to encrypt data that may be required for business operations. An attacker will decrypt critical data only after receiving a ransom.

Explanation:

Edhesive 3.2 code Practice:Question 1

Write a program to a number and test if it is greater than 45.6. If the number entered is greater than 45.6, the program needs to output the phrase “Greater than 45.6.

Sample Run
Enter a number:90

Sample output
Greater than 45.6

Answers

Answer:

a = float(input("Enter a number: "))

if(a > 45.6):

   print("Greater than 45.6")

Explanation:Code is in Python.

The program is an illustration of conditional statements.

Conditional statements are used to execute statements depending on the truth value of the condition.

The program in Python, where comments are used to explain each line is as follows:

#This gets input for the number

num = float(input("Enter a number:"))

#This checks if the number is greater than 45.6

if num > 45.6:

   #If yes, the appropriate text is printed

   print("Greater than 45.6")

#If otherwise, the program is exited

Only numbers greater than 45.6 will cause the statement in the condition to be executed.

See attachment for sample run

Read more about similar programs at:

https://brainly.com/question/19123086

To allow a document to be opened easily on most computers, save the document as a _____.

a hyperlink
require a password
a template
read only

Answers

Answer:

PDF

Explanation:

Answer:read only

Explanation:

Will creates an entry in his calendar and marks it as an all-day instance. Which item has he created?
Appointment
Meeting
Event
Period

Answers

Answer:

The answer u looking for is event

Answer:

event

Explanation:

Select the correct answer.

What are the requirements to access email on the web?
А.
a webmail provider's URL and a password
B.
a webmail provider's URL, a username, and a password
C.
a credit or debit card, a username, and a password
D
an email server ID and a password

Answers

Answer:

a webmail provider's URL, a username, and a password

Explanation:

B is the answer to the question

PLZ BEEN STUCK ON THIS



What is the second software layer of the Open Systems Interconnection reference model called?

data link
protocol
network
TCP/IP

Answers

Answer:

am not really sure but between TCP/IP and data link am sorry for not being precise .

Answer: DATA LINK

Explanation:

SEARCH IT UP!

Identify the common features of software applications. (choose all that apply)
a pointer
toolbars
an operating system
buttons
hardware
a mouse

Answers

Answer:

a pointer, toolbars and buttons

Explanation:

got it correct

Answer:

Pointer, toolbars, and buttons

Explanation:

Vincent is a digital media professional. His bosses always praise his artwork. His company has just taken on a new project. Vincent has some thoughts and ideas about this new project that he wants to discuss with the senior employees. What kind of skills should he use to pitch his ideas?
A.
technical
B.
manipulative
C.
social
D.
interpersonal

Answers

Answer:

A

Explanation:

I think the answer in A

A customer complains that the network connection on the laptop is intermittent. The customer states that they are using a wireless PC card for network connectivity. The customer believes that the laptop may be too far from the wireless access point; however, he does not know where the wireless access point is located.

As a technician, you need to be able to ask questions that will be recorded on a work order. What are 5 closed-ended questions and 5 opened-ended questions that you would ask a customer. ​

Answers

how are you

I will ask what's the problem

what happend before u saw this

what did I do after

was anyone with you

and give me permission to help

Question 3 :The easiest way to become a victim of malware, spyware or viruses is through:This task contains the radio buttons and checkboxes for options. The shortcut keys to perform this task are A to H and alt+1 to alt+9.
A

texting.
B

online chatrooms.
C

playing games.
D

downloads.

Answers

Answer:

downloads.

Explanation:

A test using various ransomware strains showed that 1,000 Word documents could be encrypted in anything from 18 seconds to 16 minutes.  Thus, option D is correct.

What easiest way to become a victim of malware download?

Phishing emails are by far the most popular way for hackers and state-sponsored hacking groups to disseminate malware.

Adware is malware that targets computer users with unwanted adverts. This makes it possible for the creator of the malware to obtain payment from the companies whose adverts are served by it.

However, certain viruses may be scheduled to begin infecting your computer a few days after they are downloaded. Other viruses may attempt to circumvent antivirus protection by downloading in chunks.

Therefore, Hackers have become adept at crafting emails that lead recipients to click on links or download files that contain malicious software.

Learn more about downloads here:

https://brainly.com/question/29328797

#SPJ2

Two strings are anagrams if they are permutations of each other. For example, "aaagmnrs" is an anagram of "anagrams". Given an array of strings, remove each string that is an anagram of an earlier string, then return the remaining array in sorted order. For example, given the strings s = ['code', 'doce', 'ecod', 'framer', 'frame'], the strings 'doce' and 'ecod' are both anagrams of 'code' so they are removed from the list. The words 'frame' and 'framer' are not anagrams due to the extra 'r' in 'framer', so they remain. The final list of strings in alphabetical order is ['code', 'frame', 'framer'].

Answers

Answer:

Here is the Python program:

def removeAnagram(array):  #method to remove string from array of strings that is anagram of earlier string

   s = set()  #creates a set

   output = []  #creates an output list

   for string in array:  # iterates through each string in array of strings

       if ''.join(sorted(string)) not in s:  #if sorted string of array is not in s

           output.append(string)  #append that string to output list

           s.add(''.join(sorted(string)))  #add that sorted string to s set

   return sorted(output)  #returns output list

   

array = ['code', 'doce', 'ecod', 'framer', 'frame']  #creates a list of words

print(removeAnagram(array))  #calls method to remove each string that is an anagram of earlier string

Explanation:

I will explain the program with an example:

Suppose array = ['code', 'doce', 'ecod', 'framer', 'frame']

Now the for loop works as follows:

At first iteration:

first string of array is 'code'

if ''.join(sorted(string)) not in s: this is an if statement which has two method i.e. join() and sorted(). First each letter of the string i.e. 'code' is sorted in alphabetical order then these separated characters are joined together into a word with join() method. So

sorted(string) becomes:

['c', 'd', 'e', 'o']                                                                                                           and ''.join(sorted(string)) becomes:

cdeo

Now if ''.join(sorted(string)) not in s condition checks if cdeo is not in s set. This is true so the statement:

output.append(string) executes which appends the string to output list. So now output has:

['code']                                                                                                                         Next s.add(''.join(sorted(string))) statement  adds the sorted and joined string of array to s set. So the set has:

{'cdeo'}                                                                                                                        

So at each iteration each word from the array is sorted and joined and then checked if output array contains that word or not. If not then it is added to the output array otherwise not. For example at 2nd iteration the word 'doce' which is anagram of code and it is checked when it is sorted and joined and it becomes cdeo which is already in output array. So this is how the anagram is removed from the array. At the end the output array which returns the remaining array in sorted order is returned by this method. The screenshot of the program along with its output is attached.

The program is an illustration of loops.

Loops are used to perform repetitive and iterative operations.

The program in Python, where comments are used to explain each line is as follows:

#This initializes the list of words

myList = ['code', 'doce', 'ecod', 'framer', 'farmer']

#This creates a set

mySet = set()

#This creates a new list for output

newList = []

#This iterates through the list

for elem in myList:

   #This checks if a sorted list element is not in the set

   if ''.join(sorted(elem)) not in mySet:  

       #if yes, the list element is appended to the new list

       newList.append(elem)

       #And then added to the set

       newList.add(''.join(sorted(elem)))  

#This prints the anagram

print(sorted(output))

Read more about similar programs at:

https://brainly.com/question/19564485

how can we show that heat is liberated during respiration​

Answers

Answer:

To show that heat is liberated during respiration. Make a hole in the cork and insert a thermometer into cork and see the bulb of the thermometer is in the midst of the seeds. Record the temperature in both the flasks at every two or three hour intervals for about 24 hours.

Explanation:

Hope this helps:)

To view data in a graphical format that is easier to understand, use Microsoft Excel
functions
formulas
pictures
charts

Answers

Answer:

i guess charts??

Explanation:

Which sentences describe the value of a conditional statement? Check all that apply.

It allows a programmer to designate a portion of the code that will be run only when a condition is met.

It creates new program code when a condition is met.

It allows a programmer to set a condition that must be met.

It incorporates decision-making into a program.

Answers

Answer:

134

Explanation:

Edgenuity

Answer:

1. It allows a programmer to designate a portion of the code that will be run only when a condition is met.

3. It allows a programmer to set a condition that must be met.

4. It incorporates decision-making into a  program.

Explanation:

According to the video, what tasks do Foresters commonly perform? Check all that apply.

Answers

Common tasks that foresters perform are as follow.

Measuring trees

Supervising timber harvests

Planting seedlings (baby trees)

Hope I could help!!

Answer:

On edge its

receiving money

totaling bills

giving receipts

weighing produce and bulk food

Explanation:


3. Which of the following is used as a container to keep salted fish during the
process?
a. bistay
b. oil drum
c. mixing bowl
d.earthen pots​

Answers

Answer:

A. yes A is actually used as a container to keep salted fish

Explanation:

plzzzzzzzzzzzzz give me brainiest

4.2 Code Practice: Question 1

Write a program that inputs numbers and keeps a running sum. When the sum is greater than 100, output the sum as well as the count of how many numbers were entered.

Sample Run

Enter a number: 1
Enter a number: 41
Enter a number: 36
Enter a number: 25

Sum: 103
Numbers Entered: 4

Hint: If you get an EOF error while running the code you've written, this error likely means you're asking for too many inputs from the user.

Answers

In python:

total = 0

i = 0

while total <= 100:

   number = int(input("Enter a number: "))

   i += 1

   total += number

print("Sum: {}".format(total))

print("Numbers Entered: {}".format(i))

I hope this helps!

Enter an integer
5
6
7

Answers

/* This program prompts the user to enter an integer

* and then determines whether the integer is between 4-6. */

start();

function start(){

var int = readFloat("Enter an integer to print in this program: ");

println("An integer from 5-6 is entered (True/False)");

if(int <= 6 || int == 4){

println("True: " + int + " was entered.");

}else{

    println("False: " + int + " was entered.");

}

}

... If this isn't what you were looking for, I apologize.  I'm uncertain on what you really need help with, your question isn't quite clear... I answered to the best of my ability in simple js.

edit: brainly deletes my indents... just make sure to indent properly :-)

For your biology class, you will be giving a presentation of the findings of a plant growth experiment. Which application is best suited for this presentation?


Writer or Word


Impress or PowerPoint


Notepad or Paint


Calc or Excel

Answers

Answer: Powerpoint

Explanation: Easy to give graphs and add pictures. You can also add shapes to create a bar graph if needed.

Answer:

Calc or Excel

Explanation:

Which of the following would be provided from the use of a GIS?

a. map displaying satellite data of farmland use
b. map displaying projected path of a hurricane
c. Doppler radar images for weather forecasting
d. satellite images used to reconstruct a forest fire

Answers

Itsssssssssssssssssssssssss B

The one that would be provided from the use of a GIS is a map displaying the projected path of a hurricane. The correct option is b.

What is GIS?

A computer system that analyzes and presents spatially related data is known as a Geographic Information System (GIS). It makes use of information associated with a certain place.

People can use GIS technology to compare the locations of various objects to determine how they connect to one another. For instance, utilizing GIS, a single map might show both polluting and pollutant-sensitive locations, such as wetlands and rivers, as well as locations that cause pollution, such as industries.

You need to enable tropical storm tracking if you want to follow a hurricane on our map. Click the symbol in the top-right corner to begin.

Therefore, the correct option is b. map displaying the projected path of a hurricane.

To learn more about GIS, refer to the link:

https://brainly.com/question/14464737

#SPJ2

Andy wants to install a new Internet connection. He wants to take the fastest he can get. What are the maximum speeds for the following Internet access technologies?

Answers

Answer:

1. so if i wanted to build a linux server for web services(apache) with 1cpu and 2 gb of memory.-operating at 75% of memory capacity2. a windows server with 2 cpu/ 4gb memory- operating at 85% of memory capacity3. a storage server with 1 cpu/ 2gb memory- operating at 85% of memory capacityhow much memory do i have to add for each server. so that the utilization rate for both cpu and memory is at a baseline of 60%."the details for the cpu like its processor or the memory's speed isnt to be concerned" yeah i kept asking my teacher if he's even sure about the but the whole class seems to be confused and the project is due in 3 days..this is a virtualization project where i have to virtualize a typical server into an exsi hypervisor.

Answer:

PLATOOOOOO

Explanation:

Steve Jobs described early computers as “the most remarkable tool that we’ve ever come up with..it’s equivalent of a bicycle for our minds.” Would you describe smartphones as a bicycle for our minds?

Answers

Answer:

Here is my stance on the phone issue and a quote from Steve himself.

"I think one of the things that really separates us from the high primates is that we’re tool builders. I read a study that measured the efficiency of locomotion for various species on the planet. The condor used the least energy to move a kilometer. And, humans came in with a rather unimpressive showing, about a third of the way down the list. It was not too proud a showing for the crown of creation. So, that didn’t look so good. But, then somebody at Scientific American had the insight to test the efficiency of locomotion for a man on a bicycle. And, a man on a bicycle, a human on a bicycle, blew the condor away, completely off the top of the charts.

And that’s what a computer is to me. What a computer is to me is it’s the most remarkable tool that we’ve ever come up with, and it’s the equivalent of a bicycle for our minds."

Explanation:

Like anything smartphones, computers, and television can be the junk-food equivalent of our minds or the inspiration to better yourself with knowledge and creativity. To me its like a bicycle in that are you riding the bicycle to healthfoods or mcdonalds. Its the freedom of the transportation of knowledge that can be so life-changing and so life-threating at the same time.

I would not think of smartphones as a bicycle for our minds as they do not run on how my mind functions.

What are people view on the quote above?

Some people do believe that the statement is true. They think also that smartphones and tablets can be a source of big distraction if not handled well.

Smartphones are a good learning tools, or they can be bicycles for our minds only when they are used by a skillful person.

Learn more about smartphones from

https://brainly.com/question/917245

What is the assignment operator?

Select the one choice that best answers the prompt above:
Answer 1
==

Answer 2
=

Answer 3
<=

Answer 4
===

Answers

I think hahahahaha Answer 1

Answer:

answer 3 is greater then or equal to, answer one is both equal, answer 2 is equal, answer 4 is all equal no mistakes,

Explanation for brainly please

answer 3

what are the 2 things you are not sure about evaluating functions​

Answers

Answer:

every thing

Explanation:

Answer:

To evaluate a function, substitute the input (the given number or expression) for the function's variable (place holder, x). Replace the x with the number or expression. 1. Given the function f (x) = 3x - 5, find f (4).

A function is a relation in which each input has only one output. In the relation , y is a function of x, because for each input x (1, 2, 3, or 0), there is only one output y. x is not a function of y, because the input y = 3 has multiple outputs: x = 1 and x = 2.

A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel. For example, cell A3 below contains a formula which adds the value of cell A2 to the value of cell A1.

Explanation:

Other Questions
What is gods aim in regard to fallen humanity help I don't understand English, it's easy, it helps Psychology is the science of behavior and mental processes it began with Philosophy meaning the love of wisdom. How would you describe Psychology and Philosophy are similar? How would you describe these two vocabulary words are different? please I need a quick help How much will cost to buy beef for a family of 5 if each person gets 1/2 pound of beef and the beef cost 5.99 per pound? How does the author attempt to answer her question aboutfear?AShe studies people who went through a hauntedhouse days after their experience.BShe studies people before and after they walkthrough a haunted house.C She compares the responses of different age groupswho went through a haunted house,DShe questions people who had just finished a hauntedhouse about their willingness to go again. Its on common lit why is it fun to be frightened Pence or Kamala? explain please cuz i dont know anything about politics A gaseous compound Y contains carbon and hydrogen only and has a densityof 1.696 g dm-3 at 95.3 kPa pressure and 298K. Assume that Y behaves ideally,calculate its molar mass and deduce its molecular formula. Given 1kPa =1 x 103Nm-2. Which area was forced to have a communist government?northern Eur pecastern Europewestern Europesouthern Europe In the 2015 baseball season, the top five home run hitters hit 35, 39, 43, 49, and 52 home runs. In the 2016 season, the top five home run hitters hit 33, 38, 38, 47, and 53 home runs.In which season did the top five home run hitters hit more home runs altogether? How many more home runs? Explain how you can use rounding to check your answers.Type your answer in the box below. What is the value of x in the proportion below?1/2 /4 = x/28O 3 1/2O 7 1/2O 14O 56PLEASE HELP ITS URGENT Which of these new weapons was instrumentalin drawing the United States into World War 1?poison gassubmarinesmachines gunsaerial bombers Describe a time when you discovered or experienced something that made you see the world differently. How did this make you feel? How did it cause you to change? Factor completely by grouping.x^3 + 7x^2 + 9x + 63 38% of 22 is _______Explain your method. The price of a cell phone can be modeled by the equation:y = 15x + 90, where x is time in years and y is the price ofthe phone. This equation tells us that the cell phone originallycost $90 and each year the cost went up $15. How many yearswill it take for the cell phone to cost $150? which is true regardless the graphed function f(x) Who ever is reading this: I love u. U matter. The world needs u hang in there ik it may be bad but u deserve the world A newspaper article states that 90% of drivers in Iowa wear their seatbelt. Suppose we are interested in estimating the proportion of drivers in Iowa City who wear their seatbelt when driving. We will observe drivers at different times of the day at different locations around town and record whether they are wearing their seatbelt. How large of a sample would we need to estimate this proportion to within 1% with 95% confidence? 7. Fred picked up the lotion from my desk. Change this sentence to passive voice. *