Which of the following can be used to locate data in a particular column?
A. VLOOKUP
B. HLOOKUP
C. CLOOKUP
D. RLOOKUP
Answers
Answer:
A. VLOOKUP
Explanation:
VLOOKUP is an Excel function to look up data in a table organized vertically. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches. Lookup values must appear in the first column of the table passed into VLOOKUP.
Purpose
Lookup a value in a table by matching on the first column
Return value
The matched value from a table.
Syntax
=VLOOKUP (value, table, col_index, [range_lookup])
Arguments
value - The value to look for in the first column of a table.
table - The table from which to retrieve a value.
col_index - The column in the table from which to retrieve a value.
range_lookup - [optional] TRUE = approximate match (default). FALSE = exact match.
Related Questions
Based on what you know about the Sort and Find functions, return to the database file to determine the answers to the following questions.
There is a person in the database with the last name Olivero. What is that person’s first name?
Jose
Inez
Jack
Sara
Answers
Answer:
SARA
Explanation:
Answer:
The second part question answer is : 1179 Angel Way
Explanation:
1179 Angel Way
When is the following expression true? (2 points)
!(!a || b) || (!a && b)
1) If and only if a and b have different values
2) If and only if a and b have the same value
3)
If and only if both a and b are true
4) If and only if both a and b are false
5) The expression is never true
Answers
Answer:
1) If and only if a and b have different values
Explanation:
Given
Expression: !(!a || b) || (!a && b)
Required
When is it true?
The expression is true when the values a and b are different and the proof is as follows.
(1) Assume that: a = true and b = false
!(!a || b) || (!a && b)
= !(!true || false) || (!true && false)
!true = false, so the expression becomes:
= !(false|| false) || (false && false)
In boolean, false|| false = false and false && false = false. So, we have:
= !(false) || (false)
!(false) = true, so, the expression becomes:
= true || (false)
Lastly, true || false = true
(2) Assume that: a = false and b = true
!(!a || b) || (!a && b)
= !(!false|| true) || (!false && true)
!false = true, so the expression becomes:
= !(true|| true) || (true && true)
In boolean, true|| true = true and true && true = true. So, we have:
= !(true) || (true)
!(true) = false, so, the expression becomes:
= false|| true
Lastly, false || true = true
This expression is false if a and b have the same value
To excel at these professions, you need to be able to combine an eye for elegant design with a mind that delights in efficient order. In order to excel in web design, you need to combine design with ______. A web presence creative communication a complete vision an organized mind
Answers
Click this link to view O*NET's Work Activities section for Actors. Note that common activities are listed toward the top, and less common activities are listed toward the bottom. According to O*NET, what are common work activities performed by Actors? Check all that apply. repairing and maintaining electronic equipment performing administrative activities thinking creatively controlling machines and processes performing for or working directly with the public establishing and maintaining interpersonal relationships
Answers
Based on O*NET, the common work activities performed by Actors are:
Scheduling work and activities. Getting information. Making decisions and solving problems. Coordinating the work and activities of others.What is activity in the workplace?An activity in the workplace is one that connote the way to promote strong work relationships and boast morale.
Note that Getting all actors to be involved in a team workplace activity is one that help develop a kind of personal bonds and also enhance the professional relationship of all actors.
Learn more about Work Activities from
https://brainly.com/question/25530656
A video project needs to be encrypted as it is going from a source to a destination. What can be added to the video
Answers
Answer:
A video encoder
Explanation:
an encoder is used to make a video encrypted so nobody can take your copy it. For instance You Tube uses an encoder
What happens when a user clicks the question mark at the top of the Backstage view?
O It shifts the view to the main window.
It makes the Tell Me text box appear.
O It opens the PowerPoint Help interface.
O It opens the Microsoft Help website online.
Answers
Answer:
D
Explanation:
Access to recent opened files, information about the permissions, sharing, and versions of the open file, the ability to create a new file, and printing are all available from the backstage view. Along with other details (properties), the Backstage View offers the following about the file. .file size Thus, option D is correct.
What question mark at the top of the Backstage view?You may save, open, print, and share your presentations in a number of ways using the backstage view. Click the File tab on the Ribbon to see Backstage view. When you select the Info option in the Backstage View, additional details about the file are also made available, including the following.
The Microsoft Office Backstage view appears when a Microsoft Office program is launched or when you click the File tab. Backstage is where you should go if you need to make a new file, open an existing file, print, save, change options, or do anything else.
Therefore, It opens the Microsoft Help website online.
Learn more about Backstage view here:
https://brainly.com/question/27362542
#SPJ2
Explain why E-mail A is inappropriate for the workplace and revise it to be appropriate.
Answers
Email A Is Not Appropriate Because The Email Dosent Sound Professional At All Or Respectful At All
Explanation:
This is the revised Email Appropriate For Workplace
Is it possible that I will be receiving the training manual this morning because I will be needing it for my next shift.
inappropriate--workplace email uses include messages linked to social networking sites or emails involving an employee's sideline business.
Hope this Helps you!!
The limitations placed on employees in accordance with the company's policies and procedures
Conflict Management
regulatory control
Autocratic Leadership
Copyright
Answers
Answer:
Answer is B!
Explanation:
I just took the quiz (:
The limitations placed on employees in accordance with the company's policies and procedures regulatory control. Thus, option B is correct.
Who is an employee?An employer is an individual that hires employees to do their tasks and responsibilities, whereas an employer is a worker for a firm and receives a wage.
If processes are not followed, employees may file claims for wrongful discharge or intentional dismissal with the Court. this helped the company to make sure that they run in a smooth manner. As these rules are set to mark the company in a progressive manner.
A company policy is a set of guidelines and rules that employers can use to formalise their requirements and standards for the health and safety of employees, transparency, best practices, and internal business procedures.
Therefore, option B is the correct option.
Learn more about employee, here:
https://brainly.com/question/18633637
#SPJ6
9.4 Code Practice: Your task is to determine whether each item in the array above is divisible
by 3 or not. If an item is divisible by 3, then leave that value as-is in the
array, but if it is not divisible by 3, then replace that value in the array with a
o. Remember that you will need to use modular division from Unit 2 to
determine if a value is divisible by 3. Finally, print out the array in the
format as seen in the sample run below.
(Can someone please help me?)
Answers
Answer:
Explanation:
The following Python code is a function that takes in an array as a parameter, it then loops through the array determining if the element is divisible by 3. If it is it leaves it alone, otherwise it changes it to a 0. Then ouputs the array. A test case is shown in the attached image below using a sample array.
def divisible_by_three(array):
for x in array:
if x % 3 == 0:
pass
else:
array[array.index(x)] = 0
return array
In this exercise we have to use the knowledge of computational language in python to describe the code, like this:
We can find the code in the attached image.
What is an array for?After wondering what an array is, you might wonder what it's for. The main purpose is to store information in an orderly way, that is, for each line, one piece of information. An example of an array is when storing names of people present in a classroom.
The code can be written more simply as:
def divisible_by_three(array):
for x in array:
if x % 3 == 0:
pass
else:
array[array.index(x)] = 0
return array
See more about python at brainly.com/question/26104476
In what way are high-level programming languages limited? (5 points)
a
They are less readable by humans because they are written in the computer's native machine code.
b
They are written for specific computers and will only work on that one type of computer.
с
They give more control over the hardware and execute tasks more quickly.
O
d
They must be translated into machine code by interpreting and compiling.
Answers
Answer:
low-level language is a type of programming language that contains basic instructions recognized by a computer. Unlike high-level languages used by software developers, low-level code is often cryptic and not human-readable. Two common types of low-level programming languages are assembly language and machine language.
Explanation:
High level-level programming language is limited in that They must be translated into machine code by interpreting and compiling.
What is a High-level programming Langauge?High-Level Programming Langauge is a language that is written in human-readable form, in other words, they include normal human statements which makes it easy for programmers to understand.
For High-level programming Langauge to work effectively, a compiler is needed to transform these statements into machine codes.
Learn more about High-level programming Langauge here:
https://brainly.com/question/22695199
#SPJ2
i u were to make 1 new animal in the world what would it be? (it can be cross breed)
Answers
Answer:
lizard bird
Explanation:
Decide whether each source would be considered a primary or secondary source
Answers
Answer:
Can you attach a picture so we can see?
Explanation:
Answer:
yea we cant see any sources
Explanation:
Super Shenron vs Zeno D-e-a-t-h B-a-t-t-l-e Creation v Destruction Who Would Win????
Lmk
Answers
Answer:
both tbh I don't know I'm doing this for points cuz I need help for sm
If I got a monitor and kept my garbage laptop could I play games on max graphics?
Answers
Answer:
No?
Explanation:
Well depending on the hardware of the laptop, all this would do is force the laptop to on top of processing your games, output frames onto the monitor. This monitor is just another screen along with the built-in one of the laptop. Thus, you really can't go max graphics unless your laptop was able to do so in the first place.
Put the parts of the program in order to have the output shown below.
16
1. First part
2.second part
3. Third part
answer = multiply(8,2)
def multiply(numA, numB):
return numA* numB
print (answer)
Answers
i have no idea how to get this answer, but here.
edge 2021
First part
answer = multiply(8, 2)
Second partdef multiply(numA, numB):
return numA * numB
Third partprint(answer)
16
How to model a programming processIn the field of programming, functions are a set of code lines that represents a process. Processes involve inputs, steps and outputs. Hence, we can runs a function by the following procedure:
Create a variable.Associate a function with given inputs to the variable.Run the function.Return the output.Print the output.Now we proceed to present the procedure:
First partanswer = multiply(8, 2)
Second partdef multiply(numA, numB):
return numA * numB
Third partprint(answer)
16
To learn more on programming, we kindly invite to check this: https://brainly.com/question/11023419 #SPJ2
I will give brainlyest if someone names 15 mcyt on the dream smp.
Answers
Answer:
Antfrost
Awesamdude
BadBoyHalo
Callahan
CaptainPuffy
ConnorEatsPants
Dream
Eret
Foolish Gamers
Fundy
GeorgeNotFound
Hannahxxrose
HBomb94
ItsAlyssa
JackManifoldTV
Jschlatt
Karl Jacobs
LazarBeam
Nihachu
Ph1LzA
Ponk
Punz
Purpled
Quackity
Ranboo
Sapnap
Skeppy
Slimecicle
Technoblade
TommyInnit
Tubbo
Vikkstar123
Wilbur Soot
Ponk
Awesamdude
Tommyinnit
WilburSoot
Philza
Technoblade
Tubbo_
Nihachu
CaptianPuffy
Ranboo
Dream
GeorgeNotFound
Sapnap
Antfrost
BadBoyHalo
Skeppy
ConnorEatsPants
JSchlatt
Quackity
Karl Jacobs
Punz
Purpled
Hbomb94
Callahan
JackManifoldTV
ItsFundy
The_Eret
i listed as many as i could think of lol
what are the functions of file
Answers
Answer:
file is an object on a computer that saves data information and any thing
For what two reasons is it important to add comments to a program?
Answers
I'll appreciate some help pls
Answers
Answer:
i dont know....
Explanation:
25-words or more in your OWN words the meaning of digital literacy.
Answers
Answer:
Digital literacy means having the skills you need to live, learn, and work in a society where communication and access to information are increasingly through digital technologies like internet platforms, social media, and mobile devices.
Explanation:
help me!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Answers
Answer: the body shape is skinny
Have you watched, or listened to, a documentary on your computer, smartphone, or on demand? Do you think these new distribution choices help or hurt future opportunities for video journalists? Support your answer.
Answers
Answer:
Yes, and No it does not hurt their opportunities
Explanation:
The main goal of video journalism is to get their work in front of as many people as possible so they can share their stories with the entire world. These platforms allow for this to happen. Smartphones, Computers, On-demand video platforms, etc. all allow Video Journalists to publish their work in various different platforms and formats in order to get their work seen by hundreds, thousands, or even millions of individuals. Therefore, It does not hurt video journalists, but instead encourages them and helps them further their work by creating more opportunities.
How does a computer program use pixels to display an image?
Answers
Every image on your computer's screen is made up of pixels. A pixel is a tiny dot of color. ( proper ans: When the pixels are small enough, your brain merges them together into a single image.)
Answer:
Every image on your computer's screen is made up of pixels. A pixel is a tiny dot of color. When the pixels are small enough, your brain merges them together into a single image.
for more information please visit http://coredogs.com/lesson/how-computers-show-images.html#:~:text=Every%20image%20on%20your%20computer's,together%20into%20a%20single%20image.
Select all of the true statements about navigating the Internet.
Enter a URL and press Enter to visit a new Web page.
Refresh your browser anytime you want the computer to remember a URL.
You cannot reset your home page.
Use tabs at the top of the browser window to move between several pages that you have opened.
Click on the x in the upper right corner to close the browser window.
m Press the arrow that points to the right to go to the last Web page that you visited
Answers
Answer:
1, 4, and 5
Explanation:
2 is false because refreshing your browser doesn't mean that the url is memorized, it means that something is wrong or something isn't working, and you can try reloading that tab again.
3 is false because you can reset your home page.
6 is false because going to the right isn't going to a previous page you visited, it goes back to present tabs. Think of the left arrow as going to the past, and the right as going back to the present.
write an application of computer in robotics?
Answers
Answer:
In robotics, one use the computer has is to help program the robots.
What statement BEST explains the relationship between these two facts
Answers
Answer:
Chocolate is now a sweet treat that is very popular in the us
Explanation:
:)
name two living thing and nonliving thing that interact in an ecosystem
Answers
Answer and Explanation:
1. Water and Fish.
- Fish live in water.
- Fish are living.
- Water is not living.
2. The Sun and Trees.
- The Sun is the source of energy for trees.
- The Sun is not living.
- Trees are living.
#teamtrees #PAW (Plant And Water)
What role does the animation in the motion picture industry or video industry play?
Answers
Answer:
there’s a lot of animation in the video marketplace. All the industries you cite are part of the bigger motion picture/video production industries. Animation plays a vital role across the board for too many reasons to list. Without knowing what your definition of animation is, it’s hard to write about what you are asking. That said, the industries you’re listing are all part of the same industry. If you watch news, you see animations all the time. Backgrounds, lower third supers that move…that’s all animation. Even in theatrical movies, it’s all over…you may not recognize it as animation, but it surely is. Not all animation needs to look like Looney Tunes, even if that would be nice.
do u have to divide or multiply this problem 5300 yd = mi
Answers
Answer:
the answers is 3.011364 and if you need to roundnit would be 3.01
Lucia is using the American Psychological Association (APA) style guidelines to writer her research paper. What is her most likely topic?
physical sciences
literature
social sciences
biology
ANSWER IS SOCIAL SCIENCES
Answers
Answer:
its C
Explanation:
According to the above scenario, Lucia's subject in the research paper is social sciences. Thus, option second is correct.
What is a research paper?A research paper is a longer essay in which you give your own interpretation, opinion, or argument. When writing an essay, you apply all you know and have pondered about a subject.
The purpose of a research paper is to draw on what others have said about a topic and engage the sources in order to intelligently present a distinct viewpoint on the problem at hand, not just inform the reader what others have said about a topic.
The examination of how humans communicate with one another is known as social science. Anthropology, economics, political science, psychology, and sociology are all fields of social science.
According to the given circumstance, Lucia's research paper topic is social sciences. As a result, option two is correct.
Learn more about research paper here:
https://brainly.com/question/946785
#SPJ2