25 POINTS PLATO
Drag the tiles to the boxes to form correct pairs.
Pat creates a table in a spreadsheet program, starting at cell A1 and ending at cell B4. Column A contains words, while column B contains the words’ meanings. Pat wants to look up the meaning of the word "paramount", which is present in cell A3. How should Pat write the LOOKUP function? Refer to the syntax of the function and match the arguments in the syntax to their values.

Syntax: LOOKUP(lookup value; search table; result table)

B1:B4
"paramount"
A1:A4

lookup value
search table
result table

Answers

Answer 1

Answer:

lookup value   =  "paramount"

Search table   =  A1:A4

Result table     =  B1;B4

Explanation:

lookup, what are we looking up.....:::///????Paramount

What is the beginning search table......A1;A4

Column B contains the words meanings.....this is the result we want:

So the Result table......B1:B4

Answer 2

LOOKUP("paramount"; B1:B4; A1:A4)  should Pat write the LOOKUP function.

What is a LOOKUP function?

Lookup functions entail accessing a cell, comparing its values to those in an adjacent row or column, and then extracting the relevant answers from the associated columns or rows of Excel.

The lookup value, the search table, and indeed the result table are the three inputs required by the LOOKUP function. The value you are searching for, in this case, "paramount," is the lookup value.

The table that contains the lookup value, throughout this example B1:B4, is known as the search table.

The table where the results of the lookup are stored is known as the result table, and in this example, A1:

Pat should use the columns which would have the cell value of B1, B4 as well as A1.

Learn more about the LOOKUP function, here:

https://brainly.com/question/29517410

#SPJ3


Related Questions

I need help Asap!!! So the question is "Compare and contrast Web page and Websites". ​

Answers

Answer:

A website is a mix of web pages while a web page is a single entity.

Explanation:

Are items a through e in the following list algorithm? If not, what qualities required of algorithms do they lack?
a. Add the first row of the following matrix to another row whose first column contains a nonzero entry. (Reminder: Columns run vertically; rows run horizontally.)
[1 2 0 4 0 3 2 4 2 3 10 22 12 4 3 4]
b. In order to show that there are as many prime numbers as there are natural numbers, match each prime number with a natural number in matching the first prime number with 1 (which is the first natural number) and the second prime number with 2, the third with 3, and so forth. If, in the end, it turns out that each prime number can be paired with each natural number, then it is shown that there are as many prime numbers as natural numbers.
c. Suppose you're given two vectors each with 20 elements and asked to perform the following operation. Take the first element of the first vector and multiply it by the first clement of the second vector. Do the same to the second elements, and so forth. Add all the individual products together to derive the dot product.
d. Lynne and Calvin are trying to decided who will take the dog for a walk. Lynne suggests that they flip a coin and pulls a quarter out of her pocket. Calvin does not trust Lynne and suspects that the quarter may be weighted (meaning that it might favor a particular outcome when tossed) and suggests the following procedure to fairly determine who will walk the dog.
1. Flip the quarter twice.
2. If the outcome is heads on the first flip and tails on the second, then I will walk the dog.
3. If the outcome is tails on the first flip, and heads on the second, then you will walk the dog.

Answers

Answer:

Following are the responses to the given points:

Explanation:

The following features must contain a well-specified algorithm:

Description [tex]\to[/tex] Exact measures described

Effective computation   [tex]\to[/tex]  contains steps that a computer may perform

finitude  [tex]\to[/tex]  It must finish algorithm.

In choice "a", there is little algorithm Because it does not stop, finiteness has already been incomplete. There is also no algorithm.

In choice "b", it needs productivity and computational burden. because it's not Enter whatever the end would be.

In choice "c", the algorithm is given the procedure. It fulfills all 3 algorithmic properties.

In choice "d", each algorithm is a defined process. Since it needs finitude.

when working with smart which tab would provide the ability to change the shape or size of the smart art shapes

Answers

It doesn’t change shape

Answer:

B) Format

Explanation:

Methods ii.) Define and implement a method that takes a string array as a parameter and returns the length of the shortest and the longest strings in the array i.) Write a method that take an integer array as a parameter and returns the sum of positive odd numbers and sum of positive even numbers. iii.) Implements the sequential search method that takes and array of integers and the item to be search as parameters and returns true if the item to be searched in the array, return false otherwise

Answers

Answer:

Explanation:

Well I am sorry I don't know the answer anyway.

Write code to take two words from the user. The program should convert these to lower case, then compare them: printing a positive number if string1 appears after string2 alphabetically, a negative number if string1 appears before string2 alphabetically and zero if the two strings are identical. Make sure your program does not produce any additional numerical output other than this number or it may not be graded correctly.

Answers

Answer:

Use compareTo.

Explanation:

import java.util.Scanner;

public class U2_L3_Activity_Three{

 public static void main(String[] args){

   Scanner scan = new Scanner(System.in);

   System.out.println("Enter first word: ");

   String word1 = scan.nextLine();

   System.out.println("Enter second word: ");

   String word2 = scan.nextLine();

//I had to make the string all lowercase or all uppercase for when I did this

   word1 = word1.toLowerCase();

   word2 = word2.toLowerCase();

   System.out.println("Result: " + word1.compareTo(word2));

 }

}

Following are the program to converting string value into lowercase and compare with an input string value.

Program Explanation:

Import package.Defining a class Dat.Inside the class defining the main method, and in the method, two string variable "string1, string2" is declared.After input, the value a "toLowerCase" method is used that converts string value into lower case.  After converting value into the lower case a "compareTo" method is used that compares value and prints its value.

Program:

import java.util.*;//import package for input  

public class Dat //defining a Dat

{

public static void main(String[] ax)//main method

{

String string1 ,string2; //defining String variable

Scanner sc = new Scanner(System.in);//creating Scanner class object to input value

System.out.println("Enter values: ");//print message

string1= sc.next();//input value

string2= sc.next();//input value

string1= string1.toLowerCase();//convert string value into LowerCase  

string2 = string2.toLowerCase();//convert string value into LowerCase

System.out.println("Result: " + string1.compareTo(string2));//using compareTo method

}

}

Output:

Please find the attached file.

Learn more:

brainly.com/question/15706308

Was Nick Carson a good project manager? Why or why not?

Answers

Answer:

Nick Carson is not a good project manager because he did not focus on all aspects of the project. He also failed to provide accurate schedules and also detailed plans on the happenings of the project. He was performing other jobs leaving aside the work of project manager. Without concerning and understanding the problem of top management he delivered the project.

Explanation:

You are going on vacation and want to take some work files. You need a storage device that is small enough to fit in your bag and preferably one that does not have plugs. Which device should you bring?


hard drive bus

flash drive

external hard drive

storage card

Answers

Answer:

Flash drive

Explanation:

1, How can technology serve to promote or restrict human rights? [2 points]

Answers

Answer:

Examples of how technology can be used as a powerful tool for human rights are ever expanding. Newer technologies such as artificial intelligence, automation, and blockchain have the potential to make significant positive contributions to the promotion and protection of human rights.

the _ and _ services help us to keep in touch with our family and friends

Answers

Answer:

Internet and communication technology

Other Questions
25. estarUsteden Paris. 2. One species of Amazon piranha usually does not kill its prey, instead biting off and feeding on the _________ of other fish.A.FinsB.TailsC.GillsD.Parasites3. Because of its hunting habit of jumping out of the water, the arowana earned the nickname, _________.A.''Water monkey''B.''Water spring''C.''River frog''D.''Sea monkey''5. What is the staple crop that Caboclos plant after the floodwaters recede?A.CornB.ManiocC.PotatoesD.Onions society bears the costs of alcohol related crashes Vocal( intervals) : Please HELP MEE!! In a certain region of space the electric potential increases uniformly from east to west and does not vary in any other direction. The electric field:Group of answer choicespoints east and varies with positionpoints east and does not vary with positionpoints west and varies with positionpoints west and does not vary with positionpoints north and does not vary with position (GIVING BRAINLIEST!!)An inference isA) a conclusion drawn through reasoningB) a hint that helps you understand difficult wordsC) the proof from a text given to support an ideaD) what you think or feel about something How to make 0.01 Molar solution in 30 ml of water During World War II, what prompted many Americans to grow their own produce in Victory gardens? A shortage of workers and transportation made it hard to get crops. The government closed all food shops until the end of the war. Most food shops were converted to war equipment manufacturers. The government established strict curfews that limited shopping opportunities. Which of the following changes occurred in the second half of the 1900s?OA Nursing education moved to universities and community collegesO B. Licensing boards began to supervise nursing education more closelyOC.More complex care needed by patients led to improved education and trainingOD.All of the above How does Josephs dream from Genesis 37 relate to what is happening with Santiago from the alchemist. 1/2Cuntos envases de 1/2 de litrose pueden llenar con el lquido deuna tina de 12 litros? Which of the following is NOT a benefit of dancing?Improves balance and coordination.Helps boost your mood.Challenges your brain.Isolates you from other people. in root pass welding, that electrode we are going to use? ALGEBRA 2:my brain cant handle this please im begging 35 points!! + brain lies The area of a billboard sign is represented by (x+12)^2 square feet. Find the product Find the missing lengths or missing angles Which statement best explains why the classificationschemes of taxonomists have changed over time?A. New technology like DNA sequencing allows scientist to have a more accurate genetic evolutionary historyB. New information about the genetics of species is being discovered.C. Molecular biology has provided more detailed evidence for the relationshipsbetween organisms.D. All of the above What does the temporal lobe and Cerebellum do? What is the area of cross-section ADGF of this right rectangular prism?A. 20 square unitsB. 48 square unitsC. 52 square unitsD. 65 square units Explain three types eye protection and their appropriate uses