How do you work out a lookup and an if function on an excel spreadsheet?

Answers

Answer 1
In column A, put the codes of the products to look up. In column B, put the product name. In column C, put the price.

Related Questions

You find that your mobile device won't load any apps. identify the choice that is not a likely cause.

Answers

You may have used all your data for the month. is the answer
you have used up all your data of the month 

The program used to create the file where you want to insert the object is called the ____.

Answers

It is called the OLE

What functionality can a vulnerability scanner provide that a port scanner cannot?

Answers

Sending alerts when new systems are added to the network is the functionality that a vulnerability scanner can provide and a port scanner cannot.
port scanner allows testing of open ports and firewalls. It discovers open UDP ports on your target system by scanning with NMAP and by doing so it is the first step of a complete vulnerability assessment. 

Vulnerability scanners offer broader functionality than port scanners by identifying and testing for specific vulnerabilities and providing remediation recommendations, whereas port scanners only identify open or closed ports.

Both vulnerability scanners and port scanners are critical tools used in cybersecurity, but they serve different purposes.

Port Scanner

A port scanner, like NMAP, is used to identify open ports on a network. This helps in understanding the services and applications running on different systems within the network. However, its functionality is limited to scanning and reporting on open or closed ports, without providing in-depth insight into the potential vulnerabilities of the system.

Vulnerability Scanner

In contrast, a vulnerability scanner, such as Nessus or OpenVAS, goes a step further by not only identifying open ports but also actively testing the system for potential vulnerabilities. These scanners check for misconfigurations, missing patches, and security flaws that could be exploited by attackers.For example, while a port scanner may report that port 80 is open, a vulnerability scanner would analyze the web application running on that port to ensure it is not susceptible to known threats like SQL injection or cross-site scripting (XSS). Additionally, vulnerability scanners often provide detailed reports and recommendations for remediation, which port scanners do not.

What is an online alternative to customers sending checks via mail?

currency exchange

Western Union

payment processor

Moneygram

Answers

An online alternative to customers sending checks through e-mail is: C. payment processor.

What is online banking?

Online banking can be defined as a type of technology that financial institutions use to offer its customers an opportunity to receive and send money through the Internet.

Some examples of online banking institutions include the following:

Western UnionPay-PalMoneygramPayment processor

Payment processor is an alternative online banking institution that enable customers to send checks through e-mail.

Read more on online banking here: https://brainly.com/question/2772610

WILL GIVE BRAINLIST IF ANSWERED RIGHT 1. An engine's _______ contains the cylinder block, the cylinders, the piston, the connecting rods, and the crankshaft assemblies. A. upper end B. lower end C. back end D. bottom end Student Answer: A Answer: Incorrect Reference: Section 2.1 2. Compression gases that get past the rings and into the engine crankcase are called A. compression gases. B. blow-by gases. C. gas leaks. D. intake gases. Student Answer: C Answer: Incorrect Reference: Section 2.2 5. Technician A says that the burning of the air-and-fuel mixture in the cylinder is called fuel activation. Technician B says that the basic function of the upper-end components is to control the flow of air-and-fuel mixture into the engine and the flow of exhaust gases out of the engine after combustion. Who is right? A. Both Technicians A and B B. Neither Technician A nor B C. Technician A only D. Technician B only Student Answer: A Answer: Incorrect Reference: Section 2.1 11. What is shown in the above figure? A. Compression ring 2 B. Cam-ground piston C. Compression ring 1 D. Oil control ring Student Answer: B Answer: Incorrect Reference: Section 2.2 17. What does the above figure represent? A. Cam-ground piston B. Piston offset C. Stroke D. Bore Student Answer: B Answer: Incorrect Reference: Section 2.2 19. Technician A says that the piston's most important function is to transfer the force produced by the burning air-and-fuel mixture into usable power. Technician B says that the piston size is used to help form a seal between the piston and the cylinder walls. Who is right? A. Both Technicians A and B B. Technician B only C. Technician A only D. Neither Technician A nor B Student Answer: A Answer: Incorrect Reference: Section 2.2 20. Which of these is the distance from the head of the piston (not including any dishes or domes) to the deck surface of the engine block? A. Piston Deck Clearance B. Rod Length C. Piston Compression Height D. Compression Ratio Student Answer: C Answer: Incorrect Reference: Section 2.2

Answers

first three are c b and d

What is shown in the above figure? A. Compression ring 2 B. Cam-ground piston C. Compression ring 1 D. Oil control ring

The correct answer D. Oil control ring

A(n) _________ uses the same software and service structure as the internet, but it contains only the company's private information such as documents managed by microsoft sharepoint.

Answers

An intarnet uses the same software and service structure as the internet, but it contains only the company's private information such as documents managed by Microsoft SharePoint.
The term intranet denotes is a private internet that is used exclusively within an organization and it is accessible only to an organization's staff. 

What is a primitive?
A. A simple 2-D object such as a rectangle or circle
B. A simple 3-D object such as a cube, cylinder, or sphere
C. A rectangle
D. A sphere

Answers

Its A.  this one is so easy for me ;)  

Which chart tools ribbon tab enables a user to apply a style to the selected chart?

Answers

Design is the chart tools ribbon tab that enable the user to apply a style to the chart selected.

What are two ways to accept data typed into a cell? pressing the Backspace key or clicking the scroll arrows pressing the Tab key or pressing the Backspace key clicking the scroll arrows or pressing the Enter key pressing the Tab key or pressing the Enter key

Answers

If the data is text, simply press enter after typing data into cell.

If the data typed is numeric, but need to be considered text, add ( ' ) on the leftmost or start of the entry.

If the data typed is a formula, add equal to leftmost or at the start of the entry.


Answer:Press the Tab key.

Explanation: right on edge22

An example of software most commonly associated with productivity software is ____.

Answers

Hello User

Answer: An example of software most commonly associated with productivity software is word processing software

Word processing software is a program used to manipulate a text document. 

Hope This Helps
-Chris

A cracked tone ring will often cause what type of problem?

Answers

A cracked tone ring will often cause, False ABS actuation at low speed.

A Web _________ is an Internet-based computer that stores Web site content and accepts requests from browsers.

Answers

The answer is server.

Which group on the formulas ribbon contains a command that allows a user to create names for cells to use in a formula?

Answers

Defined Names is the group on the formulas ribbon that contains a command that allows a user to create names for cells to use in a formula.

______ is a slow process that takes place in nature. (2 points)

Budding

Reproduction

Migration

Natural selection

Answers


Natural Selection.


♣Amaranthine

A _______ is a list of instructions for the computer to follow to accomplish the task of processing data into information. systems design word processor program systems analysis

Answers

A program is a list of instructions for the computer to follow to accomplish the task of processing data into information. This specific set of ordered operations performs a specific task when executed by a computer.
Each program is written with some programming language, which  uses symbols, words, and phrases to instruct a computer to perform specific operations.

The ipv6 address, 2001:0000:0000:3210:0800:200c:00cf:1234, can be shortened to __________.

Answers

The answer is : 2001::3210:800:200C:CF:1234   You can drop leading zeroes. 00CF becomes CF and You can remove one or more "hextets" of zeroes and replace with double colons (::).

You already created a line chart, but now decide that you want to change this chart to a pie chart. to do this, you click ____ from the type group in the chart tools design tab. change chart type alter existing chart modify chart new chart

Answers

Click change Chart Type from the type group in the chart tool design tab.

ohn would like to move from the suburbs into the city, but the rent in the city is very high. John has found an apartment he really likes, but he can only afford about 60% of the monthly rent. What is the best housing option for John?

Answers

Ohn should find a roommate to split the rent.

A data ________ is the structure and organization of data which involves fields records and files

Answers

Data hierarchy is the structure and organization of data which involve files and field records.

You want to be able to access your home computer using remote desktop while traveling. you enable remote desktop, but you find that you cannot access your computer outside of your home network. what should you do?

Answers

Get a program for this perpose or perhaps get a new computer
hey 

get a app that well let u do it

The eiffel tower was made using this type of construction

Answers

The Eiffel Tower was created using Iron and a Latticework Construction. The Eiffel tower  is a wrought iron lattice tower on the Champ de Mars in Paris, France. It is named after the engineer Gustave Eiffel, whose company designed and built the tower.  The latticework construction supports its own weight. The strips of metal are crisscrossed as the tower is built, supporting itself as it goes up. 

"which key do you hold down to select a group of contiguous files"

Answers

The "Ctrl" key is the answer.

The most commonly used video formats are the mpeg-____ format, the windows media audio/video format, and the audio visual interleave format.

Answers

The answer is mpeg-4.  The most commonly used video formats are the mpeg-4 format, the windows media audio/video format, and the audio visual interleave format.

TRUE/FALSE: In order to use an object in a program, its class must be defined.

Answers

Yes that is correct. True

What are 3 things that a photojournalist do in a day's work?

Answers

Hi there!

A photojournalist is a person who takes photos, edits them, and displays them publicly. They can be hired by certain companies such as stores, for catalogs. The whole point (though), is for them, with their pictures, to tell a visual story.

I hope this helps you!

~DL 

if nothings faster than light then how do the dark get there first????

Answers

Darkness only happens because of the lack of light. For instance, when it's nighttime the only reason it's dark is because there is not enough light to create, well, light.

The ____ aggregate function finds the largest value

Answers

The MAX aggregate function.

MAX aggregate function returns the maximum value of an expression over a group of rows. It can be used as an analytic or an aggregate function. Aggregate function MAX can operate with Boolean values or can be converted to a Boolean.



The idea of supply and demand is based on the development of

business decisions in a thriving economy.
sufficient products to meet consumer wants.
governmental laws that regulate the economy.
business efforts to improve product appeal to consumers.

Answers

Answer:

The idea of supply and demand is based on the development of sufficient products to meet consumer wants.

Explanation:

In economic theory supply and demand explains the relation between price ,sellers and buyers of a resource.

If the demand increases and supply increases it dose not have any affect on price.

If demand increase and supply decrease it triggers an increase in price

If demand decrease and supply increase it triggers decrease in price.

Answer:

Business efforts to improve product appeal to consumers.

Explanation:

The idea of supply and demand is based on the development of business efforts to improve product appeal to consumers.In an economy, innovation plays big role. Things people didn't even know they needed exist and are now an important part of their lives.

Supply and demand is created because of the businesses efforts to create a need among the consumers and supply to fulfill those needs.

The theft and/or destruction of information, resources, or funds via computers, computer networks, or the internet:

Answers

The answer is Cybercrime.  The theft and/or destruction of information, resources, or funds via computers, computer networks, or the internet is called Cybercrime.  Common types of cybercrime involve hacking, online scams and fraud, identity theft, etc.

What is the program that searches through data bases?

Answers

if i'm right its call: Algorithm
Other Questions
The vice president wrote a letter to the employees announcing the opening of a new production facility. this is an example of which type of organizational communication?,a. horizontalb. informalc. laterald. formal The Democratic Republic of the Congo has not become the economic giant that was thought possible because of its _____. inability to use its natural resourcesdecades of political and economic troublelack of nonrenewable natural resourceslack of a large urban center Assuming no air resistance, all projectiles have: The surface areas of two similar cones are 20 ft^2 and 125 ft^2. What is the scale factor?A. 1/5B. 2/5C. 3/5D. 4/5 which colony was established as a business venture The amount of _______ that a food contains is measured in calories.proteinfatcarbohydratesenergy Write a percent proportion for which the percent is greater than 100 and the part is known. Use the percent equation to solve your problem to find the whole. Which formula represents an organic compound?cah2c4h8h2o2p2o5? Which sentence describes an example of a positive feedback loop? Warm-blooded animals sweat when they get too hot. Sweating is a method by which the body cools itself. A thermostat regulates temperature by turning a furnace or air conditioner on and off. When blood flows from a mild cut, blood clots form to prevent excessive bleeding. As oceans get hotter, they release more CO2, which then increases atmospheric and ocean temperatures. 2. Which of the following has specific guidelines for the use of electronic signatures?A. AMAB. HIPAAC. AAMAD. All of the above3. As a new medical assistant, where can you find guidelines and standards for the medical assistant profession?A. American Association of Medical AssistantsB. American Medical AssociationC. National Association of MAsD. American Medical Assistant AcademyHelp is greatly appreciated!!! what is equivalent to sin^-1(sqrt.3/2) if the quanity demanded of soda decreases by 5 percent when the price of soda rises by 100 percent what is the price elasticity of demand for soda the sum is a prime number the sum is less than 4 perform the indicated operation 1/3 divide 3/8 Identify a common reason teens report they start using alcohol A street light is mounted on a pole. The tip of the shadow of a man who is standing on a street a short distance from the pole has an angle of elevation to the top of his head of 28. A woman standing in the opposite direction of the pole as the man was standing on the same street has a angle of elevation from the tip of her shadow to her head of 24. If the two people are 20 feet apart, how far is the street light from the head of the woman? Your beliefs and attitudes about what is important that help guide your behavior are your julia weny to the clothing store. she had exactly $100 that she could spend.she bought 3 shirts for $29.57 each including tax. each pair of socks cost 8.95,including tax. which inequality could be used to find s, the number of pairs of socks she cpuld buy? Which of the following strategies would you use to generate a topic? timeline of your life thought shot color-coding self-interview Is 23 a prime number or a composite number? Plzz help