Robyn is using lookup functions in her Excel 2016 worksheet. Which formula uses the correct syntax? =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup) =VLOOKUP(table_array, lookup_value, col_index_num, range_lookup) =VLOOKUP(lookup_value, table_array, col_index_num, value) =VLOOKUP(table_array, lookup_value, col_index_num, value)

Answers

Answer 1

Answer:

Explanation:

Hello,

the logic is a below

=VLOOKUP(

lookup_value what you want to look up,

table_array where you want to look for it,

col_index_num the column index in the range containing the value to return,

range_lookup

is a TRUE or FALSE value. return an Approximate or Exact match

)

hope this helps

Answer 2

Answer:

in more simple words to us Edge users

Answer Shown by the guy below us is A

well it seems to be

Explanation:

Edge2020


Related Questions

Which statement is the best description of what a macro can do in Excel 2016? It is a type of formatting users can apply to enlarge the worksheet area. It is a file type that a user can save a workbook as. It is a series of instructions contained in one command that users can apply to automate complex and/or repetitive tasks. It is a recording function that allows you to save worksheets, audio recordings, and videos that are displayed on the screen.

Answers

Answer: It is a series of instructions contained in one command that users can apply to automate complex and/or repetitive tasks

One example would be a macro that goes through a list of numbers and highlights which are duplicates. Say you had the list {1,2,3,3,4,4,4,5}. You could use one color to highlight both 3 and 4 as they repeat themselves. Or you could use different colors to show the different values. With a small list, you could highlight by hand. However, macros are more efficient with larger lists.

Answer:

It is a series of instructions contained in one command that users can execute to automate complex and/or repetitive tasks.

Explanation:

edge 2022

Which object is a storage container that contains data in rows and columns and is the primary element of Access databases? procedures queries forms tables

Answers

Answer:

tables

Explanation:

For accessing the database there are four objects namely tables, queries, forms, and reports.

As the name suggests, the table is treated as an object in which the data is stored in a row and column format plus is the main element for accessing the database

Therefore in the given case, the last option is correct

Answer:

D. tables

Explanation:

took the test, theyre right too

Finish the statement below to correctly describe the Defense Enrollment Eligibility Reporting System (DEERS). DEERS is a centralized Department of Defense database that _______________________________.

Answers

Answer:  A- the antlers and horns are structural adaptations. The fighting is a behavioral adaptation.

Antlers and horns are physical adaptations that some mammals have acquired over time. However, fighting is not a physical feature but a behavioral adaptation used to beat other males during mating season.

Explanation:

IANA has primarily been responsible with assigning address blocks to five regional internet registries (RIR). A tech needs to research address blocks assigned in the United States. Which RIR should the tech contact?

Answers

Answer:

The American Registry for Internet Numbers ARIN

Explanation:

The American Registry for Internet Numbers (ARIN) is a not for profit organization that serves as the administrator and distributor of Internet numeric resources such as IP addresses (IPv4 and IPv6) ASN for the United States, Canada, as well as North Atlantic and Caribbean islands

There are four other Regional Internet Registry including APNIC, RIPE NCC, LACNIC and AFRINIC.

What is the best application to create a slide show presentation?

Answers

Answer:

Microsoft Windows File Manager

PowerPoint but for your question chrome seems to be the right answer cause other ones don’t make sense but like also isn’t PowerPoint part of windows so it might be that

Which of the following answers refers to a system containing mappings of domain names to various types of data, such as numerical IP addresses?

Answers

Answer:

DNS or Domain Name System

Explanation:

You can query a DNS server with a domain name to get an IP address.

Create Python program code that will use a for loop to ask the user to enterfourintegers. Itwillcount how many of the integers are divisible by 2. The programwill print each of the 4integers and a message saying whether the integeris even or odd. The code will print the total number of even integers

Answers

Answer:

is_even = 0

int_numbers = []

for n in range(4):

n = int(input('press any four integer numbers')

int_numbers.append(n)

for n in int_numbers:

if n%2==0:

print(n, 'integer is even')

is_even+= 1

else:

print(n, 'integer is odd')

print('Total even numbers =', is_even)

Explanation:

is_even = 0 (initiates a counter to record the number of even integers).

int_numbers creates a list to store the inputs entered by the user.

int(input()) : allows users to enter an integer number

int_numbers.append(n) : adds user input to list list variable created.

n%==2 : checks if entered digit leaves a remainder of 0 when divided by 2; hence an even number

is_even+= 1: counter updates by 1 for every even number confirmed.

What is one reason why a business may want to move entirely online?
A. To limit the number of items in its inventory
OB. To double the number of employees
C. To focus on a global market
D. To avoid paying state and local taxes​

Answers

Answer:

The correct answer is C. One reason why a business may want to move entirely online is to focus on a global market.

Explanation:

The fact that a business wishes to move entirely towards the online sales modality implies that there is a desire to expand the possibilities of selling its products beyond the physical place where it has its store.

It is a reality that starting an online business implies that the offered product can be purchased anywhere in the world, thanks to advances in technology and transportation that allow the product to be purchased and delivered in a matter of days, thanks to the advances produced by globalization.

Therefore, the fact that the store goes from physically to online selling makes its potential customers go from being the ones who know the store and live close to it to everyone in the world with access to internet.

What is Relational Computerized Database

Answers

Answer:

Relational computerized database uses tables and columns to store data. each table is composed of records and each record is tied to an attribute containing a unique value. This helps the user use the data base by search query and gives the opportunity to build large and complex data bases

Python Lists and Events: Write a program that generates 8 random scores (between 0 and 100), store them in an array, finds the best score, and then assigns grades based on the following scheme (use loops wherever possible): Grade is A if score >= best – 10 Grade is B if score >= best – 20 Grade is C if score >= best – 30 Grade is D if score >= best – 40 Grade is F otherwise.

Answers

Answer:

import random

scores = []

for i in range(8):

   score = random.randint(0,100)

   scores.append(score)

best_score = max(scores)

letter_grade = ""

for s in scores:

   if s >= best_score - 10:

       letter_grade = "A"

   elif s >= best_score - 20:

       letter_grade = "B"

   elif s >= best_score - 30:

       letter_grade = "C"

   elif s >= best_score - 40:

       letter_grade = "D"

   else:

       letter_grade = "F"

   

   print(letter_grade)

Explanation:

Import the random module

Create an empty list to hold the scores

Create a for loop that iterates 8 times. Inside the loop, create 8 random scores and put them in the scores

When the loop is done, find the best_score using max method

Create another for loop that iterates through the scores. Check each score and set the letter_grade depending on the given conditions.

The acronym "HTTP' stands for​

Answers

Answer:hypertext transfer protocol secure

Explanation:

Explanation:

http means hypertext transfer protocol secure

To build a user interface that contains graphical components, the components ____. must each be added to a separate panel. must be added directly to a frame component. must be added to a panel that is contained within a frame. must be added to a frame that is contained within a panel.

Answers

Answer:

To build a user interface that contains graphical components, the components must be added to a panel that is contained within a frame.

Explanation:

Roger is getting a $5,000 loan. Which option will allow Roger to pay off the loan and keep his payments under $100?

Answers

No roger will not be able to do that

Usually when i am using my windows 10 laptop and using the internet, it stops working and says "No Internet." So i disconnect from the wifi i was using, and then i reconnect to it and it works fine. But it keeps on doing the same thing and it is really annoying. please help!

Answers

Answer:

I used to have the same proble, have you tried rebooting it? That normally works. If not, you have to change your internet plan completely. That’s what I had to do. But first try rebooting.

Explanation:

Which is the right way to give comment if you are using Internet explorer as the browser? a) <!-- My First Webpage --> b) <comment> My First Webpage </comment>

Answers

Answer:

(a) <!-- My First Webpage -->

Explanation:

Comments in programming languages are chunks of texts, written as part of program code, that are not executed as actual code but rather used for making the program code easily readable and understandable. They allow programmers to explain certain lines of a program code.

Every programming language has its own way of representing comments. In HTML - HyperText Markup Language - comments are written between the following tags :

<!--

and

-->

For example, to put the text "My comment goes here" in a comment, we write:

<!-- My comment goes here -->

From the question, the text to be put is:  "My First Webpage". Therefore, we write;

<!-- My First Webpage -->

how to use command prompt​

Answers

Answer:

The answer to this question can be defined as follows:

Explanation:

The Command Prompt is a program, which available in windows operating systems, which imitates an input field with windows GUI(Graphic User Interface). It provides a text-based user interface, that can be used to run instructions inserted and carry out advanced organizational activities, following are the step to open a command prompt:

There are two-step to open the command prompt in windows:  

First, go to the start button the window. after open start type cmd on the search bar, It will provide the cmd to open it click with mouse or press enter button.    With the help of keyboard press (window+R) key together, after pressing it will provide the run prompt in which we write cmd and press enter. It will open a command prompt panel.    

convert the following decimal number to its equivalent binary ,octal,hexadecimal 1920​
pls in step by step
pls help me bro

Answers

Answer:

0b11110000000 is binary

0o3600 is in octal

0x780 in hexa dec.

Explanation:its a bit complitcated to explain sorry bro!

You work for a public relations (PR) firm and communicate regularly with the internal team and the clients on a PR campaign. You need to quickly send and receive professional messages that may contain text files and short media. These messages need to be accessible at any time of the day and in different time zones, and they should be able to reach all members (internal and external) relatively inexpensively. Which communication channel would best suit this purpose?

Answers

Answer:

You Need To Quickly Send And Receive Professional Messages That May Contain Text Files And Short Media. These Messages Need To Be Accessible At Any Time Of The Day And In Different ... You work for a public relations (PR) firm and communicate regularly with the internal team and the clients on a PR campaign.

Explanation:

Email would likely be the best communication channel to meet these requirements. Once an email is sent, it broadcasts across servers and arrives at the recipient’s/recipients’ mailbox(es) for access at the receiving party’s/(ies’) convenience. Email is also able to have attachments, and as such, will allow for text files and smaller media files (audio, video, or otherwise) to be attached and accessed easily.
Other Questions
Large-cap funds invest in... a. Companies with large market value. b. In at least 200 companies. c. Stocks only. d. All of the above. I WILL MARK AS BRAINLIEST WHEN I CAN. can someone help me answer this please how have international aid groups attempted to combat the global water crisis? O A. By sponsoring urbanization efforts to bring more people to cities O B. By pressuring governments to end policies that promote globalization O C. By funding government's' efforts to identify new sources of water O D. By demanding that governments outlaw desalinization facilities What was the cultural importance of the annual flooding of the Nile River?It marked the beginning of the boat festival.It showed the earth was united with the sea.It meant the gods were happy with the people.It inspired traders to exchange goods with people. Attempt 1 of 1Jamin wants to paint a wall in his bedroom. In order to know how much paint to buy, he first needs to know theapproximate area. There is a window in the middle of the wall, so he'll only need to paint the shaded part shown. Howmany square feet is just the window? [Note: The wall and window are both rectangular.)611218 in.81>36207421.5 ft232OType here to search-12:36 PM7/10/2020is this right?? whats the rise, aggression and human costs of totalitarian regimes in germany, italy, and the soviet union A firm in a purely competitive industry is currently producing 1,200 units per day at a total cost of $700. If the firm produced 1,000 units per day, its total cost would be $450, and if it produced 700 units per day, its total cost would be $425. Instructions: Round your answers to 2 decimal places. a. What are the firm's ATC at these three levels of production Verb Tenses. A: My goodness! What is that strange noise? B: Oh, nothing. Thats just my roommate. He always (sing) ____ in the shower. a. singing b. sung c. is sing d. sings Find the missing length to the attached triangle. What is the meaning of refraction Retroviruses have extraordinarily high rates of evolution of all viruses because (SELECT ALL THAT APPLY): Overall Assessment ProgressBasic Office SkillsQuestion 5 of 471/4 + 7/8 = ? [HELP AND I'LL MARK YOU BRAINLIST!]8. Imagine that you are filling out a graphic organizer that demonstrates the similarities and differences between films and books. List three similarities. (5 points) Read the text and question and choose the option with the correct answer. Me llamo Esteban y soy de Madrid. A mi familia y a m nos gusta la fiesta de fin de ao en la Plaza del Sol en la noche y en la casa de mis abuelos el da despus after . El da 1 es el aniversario de mis abuelos y a ellos les gusta preparar carne, pescado y churros con caf. A mis padres les encantan los churros! Mis tos y primos tambin celebran. A ellos les gusta cantar con mis padres y abuelos y con la familia. Son divertidos. A mi hermana le gusta hablar y cantar con mis familiares, yo prefiero jugar a los juegos de mesa con mis primos. Las celebraciones de ao nuevo y aniversario son divertidas! Based on the text, what does Esteban like? He enjoys staying home with relatives. He enjoys games and being with family. He enjoys food and singing with friends. He enjoys eating vegetables at night. What domesticated the modern turkey Two fruit flies that are heterozygous for body color and eye color are crossed. Brown body color is dominant to black body color. Red eye color is dominant to brown eye color. Use the Punnett square to determine the ratio of offspring with: Brown body and red eyes Brown body and brown eyes : Black body and red eyes : Black body and brown eye. There is often a trademinusoff between A. limited and unlimited resources. B. economic efficiency and economic equity. C. voluntary and involuntary exchanges. D. productive efficiency and allocative efficiency. Regarding the relationship between thinking and language, which of the following most accurately reflects the position taken in the text?a. language determines everything about our thinking.b. language determines the way we think.c. thinking without language is not possible.d. thinking affects our language, which then affects our thought. What type of function is represented in the table? exponential linear quadratic logarithmic What were two major betrayals in Julius Caesar? Students should be able to identify at least two points of betrayal from the play. HELP ASAP!!!!!!