what is a filter in excel (please keep your answer brief)

Answers

Answer 1

Answer:

The Excel FILTER function "filters" a range of data based on supplied criteria. The result is an array of matching values the original range. When this array is the final result (i.e. the results are not handed off to another function) matching results will "spill" on to the worksheet.

Explanation:


Related Questions

five differences between email and website addresses​

Answers

Answer:

I don't know if there are that many

An email address is an address that you can send mail to online (e-mail)

A website address is an address that you can look around at and do stuff in.

An email address always has the 'at' symbol.

Website addresses and in .com, .org, .gov etc to show that it is a 'company', organization, government website etc.

Answer:

Email:

1. For communication between individuals.

2. Can be personalized.

3. Can be made by everyone easily.

URL/Website Address:

1. For organizations or mass media communications.

2. Not everyone knows how to make a website.

Other Questions
please help i will make sure to mark brainliest The ratio of boys to girls in Ms. Reedus's classroom is 2 to 3. There are 18 girls in the classroom. What is the total number of students in Ms. Reedus's class? Determine the input, output and function of the following questionK=3H-11 answer questions 15 and 16. While recovering from a stroke, you are unable to work at your full time job for six months , what kind of policy would you need to coverage AutoFidelity BondLiabilityUnemploymentDentalHealthLifeWorkers' CompensationDisabilityHomeowners'Renters'Vision Select the appropriate pronoun.We would like your father and _____ to go sailing with us.yourselfyou A mechanic charges $43 per hour for labor and $217 for parts. The total bill is $432. Howmany hours did the mechanic work? What is the correct meaning of the word flee?to run awaya large boxa tiny insectto touch Find the value of each expression. 25-14+3 which of the following situations demonstrates a physical change a. burning a match b.milk going sour c.melting of ice d. rusting iron A man wins the lottery. He turns to the person next to him and gives the persona big kiss. two fact adout cabeza de vaca A box of cereal states that there are 72 calories in a 3 fourth cup serving what is the unit rate for calories per cup? HHow many calories are there in 4 cups? The unit rate is _ calories per cup Question 8 (1 point) (03.01 LC) Read and then choose the option with the correct answer.Which form of examinar is in the preterite ellos form?Question 8 options:ExaminoExaminasExaminanExaminaronQuestion 9 (1 point) (03.01 LC) Read and then choose the option with the correct answer.Hola, amigos! Me llamo Julin. En la clase de biologa, aprend sobre el doctor Baruj Benacerraf. Benacerraf estudi inmunologa por su enfermedad de no respirar bien.According to the text, what part of Dr. Benacerraf's body was mainly affected?Question 9 options:HandsChestFeetKnees Cristian says that when you raise a base number to a power of 3, it is impossible for the number to get smaller. Do you agree or disagree? Justify (prove) your answer. How does Benjamin Franklin use an analogy to express his viewpoint in this cartoon? He compares the colonies to pieces of a snake because it uses a biblical allusion that most of his readers will be familiar with. He compares the colonies to pieces of a snake because they are treacherous and will never be able to help each other. He compares the colonies to pieces of a snake because he believes the colonies will be ineffective unless they work together. He compares the colonies to pieces of a snake because snakes can be poisonous and should be prevented from spreading. 2) A pound and-a-half of candy costs $1.65. Find the cost of one pound. what is the possible reason of war 1. A sailor pulls a boat along a dock using a rope at an angle of 60.0 with the horizontal. How much work does the sailor do if he exerts a force of 255 N on the rope and pulls the boat 3.00 m? W = FdcosO =255 x 3 x cos 60 = 2. An elephant pushes with 2000 N at an angle of 33o above the horizontal on a load of trees. It then pushes these trees for 150 m. How much work did the elephant do? 3. Hans Full is pulling on a rope to drag his backpack to school across the ice. He pulls upwards and rightwards with a force of 22.9 Newtons at an angle of 35o above the horizontal to drag his backpack a horizontal distance of 129 m. Determine the work done upon the backpack.4. If 100 N force has 30o angle pulling on a 15 kg block for 5 m. Whats the work? Read the excerpt from "Raymond's Run." I always win cause Im the best," I say straight at Gretchen who is, as far as Im concerned, the only one talking in this ventriloquist-dummy routine. Gretchen smiles, but its not a smile, and Im thinking that girls never really smile at each other because they dont know how and dont want to know how and theres probably no one to teach us how, cause grown-up girls dont know either. How does the author develop Squeaky's viewpoint in this excerpt? by showing that Squeaky thinks girls are raised to dislike each other by illustrating that Squeaky dislikes people who brag about their accomplishments by revealing that Squeaky thinks Gretchen is the least intelligent of the group of girls. by explaining Squeaky's eagerness to befriend Gretchen