Which function calculates the largest value in a set of numbers in Excel? 1) Average 2) Count 3) Minimum 4) Maximum

Which function calculates the largest value in a set of numbers in Excel?
1) Average
2) Count
3) Minimum
4) Maximum
by

1 Answer

Answer :

4) Maximum
by

Related questions

Which function calculates the largest value in a set of numbers in Excel ?

Description : Which function calculates the largest value in a set of numbers in Excel ?

Last Answer : The Max () function calculates the largest value in a set of numbers in Excel.

Indecodinga digital signal, the receiver calculates a running average of thereceived signal power, called the _______. A) baseline B) base C) line D) none of the above

Description : Indecodinga digital signal, the receiver calculates a running average of thereceived signal power, called the _______. A) baseline B) base C) line D) none of the above

Last Answer : baseline

What is the use of the COUNT() function in Excel? -Technology

Description : What is the use of the COUNT() function in Excel? -Technology

Last Answer : Excel’s COUNT() function can be used to total the number of cells in a selected range. The COUNT() function will add up the number of cells in a selected range that contains numbers.

What website most accurately calculates car value?

Description : What website most accurately calculates car value?

Last Answer : Try visiting www.autotrader.com, www.Edmunds.com, www.WhatCar.com, or www.Autos.com to calculate your car's value. If those do not help, try contacting a local automotive business for more information either by calling or visiting.

_____________ senor senses the amount of oxygen in the engine exhaust and calculates air-fuel ratio. a) Engine temperature b) Exhaust gas c) Air flow d) Air inlet temperature

Description : _____________ senor senses the amount of oxygen in the engine exhaust and calculates air-fuel ratio. a) Engine temperature b) Exhaust gas c) Air flow d) Air inlet temperature

Last Answer : Answer: b Explanation: Exhaust gas senor senses the amount of oxygen in the engine exhaust and calculates airfuel ratio while engine temperature sensor senses the temperature of the engine coolant, and from this data the computer adjusts the mixture strength to rich side for cold starting.

A company calculates the prices of jobs by adding overheads to the prime cost and adding 30% to total costs as a profit margin. Job number Y256 was sold for Rs1690 and incurred overheads of Rs 694. What was the prime cost of the job? (a) Rs 489 (b) Rs 606 (c) Rs 996 (d) Rs 1300

Description : A company calculates the prices of jobs by adding overheads to the prime cost and adding 30% to  total costs as a profit margin. Job number Y256 was sold for Rs1690 and incurred overheads of Rs 694.  What was the prime cost of the job? (a) Rs 489 (b) Rs 606 (c) Rs 996 (d) Rs 1300

Last Answer : (b) Rs 606

If a baseball coach calculates batting averages, what scale would be used? a. Interval scale b. Ratio scale c. Nominal scale d. Ordinal scale

Description : If a baseball coach calculates batting averages, what scale would be used? a. Interval scale b. Ratio scale c. Nominal scale d. Ordinal scale

Last Answer : b. Ratio scale

Henry takes the company's sales for the past five years and calculates a growth trend. Which sales forecasting method is being employed? A)time series analysis B)executive judgement C)correlation methods D)market tests

Description : Henry takes the company's sales for the past five years and calculates a growth trend. Which sales forecasting method is being employed? A)time series analysis B)executive judgement C)correlation methods D)market tests

Last Answer : A)time series analysis

The profit percentage of banu and renu is same on selling the articles at Rs 900 each but banu calculates his profit in the selling price while renu calculates it correctly on the cost price which is equal to 10%. What is the difference in their profits?

Description : The profit percentage of banu and renu is same on selling the articles at Rs 900 each but banu calculates his profit in the selling price while renu calculates it correctly on the cost price which is equal to 10%. What is the difference in their profits? 

Last Answer : when profit calculate on SP the profit = 10% of 900 = 90 when profit calculate on CP(x) = x+X/10 = 900 11X=9000 X=818.18 profit= 81.82 required diffference= 90-81.82 = Rs 8.18

What is the function of following UNIX command? WC – l<a >b& (A) It runs the word count program to count the number of lines in its input, a, writing the result to b, as a foreground process. (B) It runs the word count program to count the number of lines in its input, a, writing the result to b, but does it in the background. (C) It counts the errors during the execution of a process, a, and puts the result in process b. (D) It copies the ‘ l ’ numbers of lines of program from file, a, and stores in file b.

Description : What is the function of following UNIX command? WC - lb& (A) It runs the word count program to count the number of lines in its input, a, writing the result to b, as a foreground process. (B) It runs ... (D) It copies the l ' numbers of lines of program from file, a, and stores in file b.

Last Answer : (B) It runs the word count program to count the number of lines in its input, a, writing the result to b, but does it in the background.

What function searches for a specific value in a table and returns that value's relative position from the table not the value itself in Excel?

Description : What function searches for a specific value in a table and returns that value's relative position from the table not the value itself in Excel?

Last Answer : The MATCH function.

Anyone know how to use excel to create tax spreadsheets but on mac numbers?

Description : Anyone know how to use excel to create tax spreadsheets but on mac numbers?

Last Answer : I'm not certain of exactly what you're asking here (and I don't do Excel on a Mac in any case), but it seems that you want to have a cell - that is, a single cell - to calculate and add ... original value + the amount of the first tax, then the formula will be different, but you'll have to say so.

How do you paste information from Numbers (like Excel) into Pages (like Word) WITHOUT the grid --- so that just the text shows up, separated by tabs)?

Description : How do you paste information from Numbers (like Excel) into Pages (like Word) WITHOUT the grid --- so that just the text shows up, separated by tabs)?

Last Answer : answer:This is a really clunky solution. In numbers select File -> Export -> Save as PDF. Then you can open that PDF and copy and paste into Pages and it will lose the formating. I wish I knew of a better way. I have been trying for about 20 minutes and that is the best I could come up with.

I have hands but I can't clap. I have a face but I can't see. I have numbers but I can't count. What am I? -Riddles

Description : I have hands but I can't clap. I have a face but I can't see. I have numbers but I can't count. What am I? -Riddles

Last Answer : A clock.

................... comparisons are necessary in the worst case to find both the maximum and minimum of n numbers. (A) 2n-2 (B) n + floor(lg n) - 2 (C) floor(3n/2) - 2 (D) 2 lg n – 2

Description : ................... comparisons are necessary in the worst case to find both the maximum and minimum of n numbers. (A) 2n-2 (B) n + floor(lg n) - 2 (C) floor(3n/2) - 2 (D) 2 lg n – 2

Last Answer : (C) floor(3n/2) - 2

Of the four numbers, the first is twice the second, the second is one-third of the third and the third is 5 times the fourth. The average of the numbers is 24.75. The largest of these numbers is: A.45 B.25 C.30 D.45 E.None of these

Description : Of the four numbers, the first is twice the second, the second is one-third of the third and the third is 5 times the fourth. The average of the numbers is 24.75. The largest of these numbers is: A.45 B.25 C.30 D.45 E.None of these

Last Answer : Answer – D (45) Explanation – Let the fourth number be a then hen, third number = 5a, second number= 5a/3 and first=10a/3 a+ 5a+ 5a/3 + 10/3 = 24.75 x 4 so,a=9 So, the numbers are 9, 45, 15 and 30

The average of four consecutive even numbers is 27. The largest of these numbers is: (A) 36 (B) 32 (C) 30 (D) 28

Description : The average of four consecutive even numbers is 27. The largest of these numbers is: (A) 36 (B) 32 (C) 30 (D) 28 

Last Answer : Answer: C Four consecutive even number = x, x+2,x+4,x+6. According to question, x+x+2x+4x+6/4=27. 4x+12/4 = 27 4x =108 - 12=96. x=96/4=24. Hence , The largest number =x+4= 24+6=30. The numbers are 24, 26 28, and 30 , which addition is 108 which average is 27, So biggest is 30

Of the 5 numbers, the first is twice the second, the second is one – third of the third, the third is 5 times of the fourth, and the fourth is three – seventh of fifth. The average of the numbers is 35. The largest of these number is. A) 30.63 B) 65.625 C) 43.75 D) 75.356

Description : Of the 5 numbers, the first is twice the second, the second is one – third of the third, the third is 5 times of the fourth, and the fourth is three – seventh of fifth. The average of the numbers is 35. The largest of these number is. A) 30.63 B) 65.625 C) 43.75 D) 75.356

Last Answer : B) Let the fifth number be x'. 4th number = 3/7 x 3rd number = 5 (3/7 x) = 15/7x 2nd number = 1/3 (15/7 x) = 15 /21 x 1st number = 2 (15/21 x) = 30/21 x X + 3/7 x + 15 /7 ... 120x = 3675 X = 30.625 So the numbers are 30.62, 13.125, 65.625, 21.875, 43.75. Therefore largest number is 65.625.

The average of 7 consecutive odd numbers is 41. Find the largest of these numbers A) 40 B) 57 C) 47 D) 43

Description : The average of 7 consecutive odd numbers is 41. Find the largest of these numbers A) 40 B) 57 C) 47 D) 43

Last Answer : C) Let the numbers be x , x+2,x+4,x+6, x+8, x+10 and x+12 Then x+x+2+x+4+x+6+x+8+x+10+x+12/7 7x+42=287 7x=245 X=35 Largest number = x+12 = 35+12 =47

How can I average non-adjacent cells in excel, excluding zero?

Description : How can I average non-adjacent cells in excel, excluding zero?

Last Answer : I copied your formula and it’s working for me in Excel 2007, =SUM(B2,D2,F2,H2,J2,L2,N2)/COUNTIF(B2:N2,”>0”)

What is the average of this set of numbers.1 7 19 53?

Description : What is the average of this set of numbers.1 7 19 53?

Last Answer : 1 + 7 + 19 + 53 = 80... 80 / 4 = 20.

Which one of the following numbers can be removed from the set S= {0,2,4,5,9}, without changing the average of the set? a) 0 b) 2 c) 4 d) 5

Description : Which one of the following numbers can be removed from the set S= {0,2,4,5,9}, without changing the average of the set? a) 0 b) 2 c) 4 d) 5

Last Answer : c) 4

Can you help me think through how to set up an excel spreadsheet to create some graphs?

Description : Can you help me think through how to set up an excel spreadsheet to create some graphs?

Last Answer : Excell graph tutor.

How do I set defaults in excel?

Description : How do I set defaults in excel?

Last Answer : answer:You can save your tweaked in chart as default chart type; you need to save it as a custom chart type. To do that, follow these steps: 1. Create the chart that you want to use (your tweaked ... this helps (since it's Excel 2003, otherwise you can refer to this post). And here is another link.

How do I set tab order in Excel?

Description : How do I set tab order in Excel?

Last Answer : answer:If you can't unlock the protection, then you can't move the tabs. It's as simple as that. That's why Workbook Protection exists. Now, if you would like to bypass Excel's security and ... t think are so simple) then there are any number of downloadable macros that you could find to do that.

What is the largest count that can be indicated by a four stage counter?

Description : What is the largest count that can be indicated by a four stage counter?

Last Answer : 11112, or 1510.

If x, y, z are three positive numbers, then the minimum value of -Maths 9th

Description : If x, y, z are three positive numbers, then the minimum value of -Maths 9th

Last Answer : hope its clear and understandable

If a1, a2, a3 ....... an are positive real numbers whose product is a fixed number ‘c’, then the minimum value of a1 + a2 ..... + an–1 + 2an is -Maths 9th

Description : If a1, a2, a3 ....... an are positive real numbers whose product is a fixed number ‘c’, then the minimum value of a1 + a2 ..... + an–1 + 2an is -Maths 9th

Last Answer : answer:

The minimum value of the sum of real numbers a^(–5), a^(–4), 3a^(–3), 1, a^8 and a^10 with a > 0 is -Maths 9th

Description : The minimum value of the sum of real numbers a^(–5), a^(–4), 3a^(–3), 1, a^8 and a^10 with a > 0 is -Maths 9th

Last Answer : answer:

If three positive real numbers, a, b, c are such that a + b + c = 1, then the minimum value of -Maths 9th

Description : If three positive real numbers, a, b, c are such that a + b + c = 1, then the minimum value of -Maths 9th

Last Answer : answer:

The Minimum bar spacing should not be less than [ A ] Diameter of the largest bar [ B ] Maximum size of aggregate [ C ] Greater of diameter of the largest bar and maximum size of aggregate [ D ] Greater of diameter of the largest bar and maximum size of aggregate plus 5 mm

Description : The Minimum bar spacing should not be less than [ A ] Diameter of the largest bar [ B ] Maximum size of aggregate [ C ] Greater of diameter of the largest bar and maximum size of aggregate [ D ] Greater of diameter of the largest bar and maximum size of aggregate plus 5 mm

Last Answer : [ D ] Greater of diameter of the largest bar and maximum size of aggregate plus 5 mm

A particle in simple Harmonic Motion while passing through mean position will have a.Maximum kinetic energy and minimum potential energy b.Average kinetic energy and average potential energy c.Minimum kinetic energy and maximum potential energy d.Maximum kinetic energy and maximum e.Minimum kinetic energy and minimum potential energy

Description : A particle in simple Harmonic Motion while passing through mean position will have a.Maximum kinetic energy and minimum potential energy b.Average kinetic energy and average potential energy c. ... energy d.Maximum kinetic energy and maximum e.Minimum kinetic energy and minimum potential energy

Last Answer : a. Maximum kinetic energy and minimum potential energy

A particle in SHM while passing through mean position will have a.maximum kinetic energy and maximum potential energy b.107 dynes c.maximum kinetic energy and minimum potential energy d.average kinetic energy and average potential energy. e.minimum kinetic energy and maximum potential energy

Description : A particle in SHM while passing through mean position will have a.maximum kinetic energy and maximum potential energy b.107 dynes c.maximum kinetic energy and minimum potential energy d.average kinetic energy and average potential energy. e.minimum kinetic energy and maximum potential energy

Last Answer : c. maximum kinetic energy and minimum potential energy

A firm is in equilibrium when its (1) marginal cost equals the marginal revenue (2) total cost is minimum (3) total revenue is maximum (4) average revenue and marginal revenue are equal

Description : A firm is in equilibrium when its (1) marginal cost equals the marginal revenue (2) total cost is minimum (3) total revenue is maximum (4) average revenue and marginal revenue are equal

Last Answer : (1) marginal cost equals the marginal revenue Explanation: A consumer is in a state of equilibrium when he achieves maximum aggregate satisfaction on the expenditure that he makes depending on the ... its production. In short run Marginal revenue = Marginal Cost is the condition of equilibrium.

Pick up the correct statement from the following: A. Maximum daily flow = 2 times the average daily flow B. Maximum daily flow = average daily flow C. Sewers are designed for minimum permissible velocity at minimum flow D. All the above

Description : Pick up the correct statement from the following: A. Maximum daily flow = 2 times the average daily flow B. Maximum daily flow = average daily flow C. Sewers are designed for minimum permissible velocity at minimum flow D. All the above

Last Answer : ANS: D

Overall thermal resistance for conductive heat transfer through a series of flat resistances is equal to the (A) Maximum resistance in the series (B) Sum of all resistances (C) Average of all resistances (D) Minimum resistance presents in the series

Description : Overall thermal resistance for conductive heat transfer through a series of flat resistances is equal to the (A) Maximum resistance in the series (B) Sum of all resistances (C) Average of all resistances (D) Minimum resistance presents in the series

Last Answer : (B) Sum of all resistances

The listed life of a rolling bearing, in a catalog is the, (a) minimum expected life (b) maximum expected life (c) average life (d) none of the mentioned

Description : The listed life of a rolling bearing, in a catalog is the, (a) minimum expected life (b) maximum expected life (c) average life (d) none of the mentioned

Last Answer : (a) minimum expected life

The_______ of an office will ordinarily be a sum equal to the average _________multiplied by the number of days in which funds can be obtained, plus a percentage of the average ___________(if necessary), as a margin – the amount of which will depend upon the extent of the difference between the receipts and payments, and other considerations a) Minimum cash balance , daily payments, daily payments a) Maximum cash balance , daily payments, daily payments a) Minimum cash balance , daily payments, daily receipts a) None of these

Description : The_______ of an office will ordinarily be a sum equal to the average _________multiplied by the number of days in which funds can be obtained, plus a percentage of the average ___________(if ... payments, daily payments a) Minimum cash balance , daily payments, daily receipts a) None of these

Last Answer : a) Minimum cash balance , daily payments, daily payments

A monopolist is able to maximise his profit when (a) his output is maximum (b) he charges higher prices (c) his average cost is minimum (d) his marginal cost is equal to marginal revenue

Description : A monopolist is able to maximise his profit when (a) his output is maximum (b) he charges higher prices (c) his average cost is minimum (d) his marginal cost is equal to marginal revenue

Last Answer : (d) his marginal cost is equal to marginal revenue

If the shear force along a section of a beam is zero, the bending moment at the section is (A) Zero (B) Maximum (C) Minimum (D) Average of maximum-minimum

Description : If the shear force along a section of a beam is zero, the bending moment at the section is  (A) Zero  (B) Maximum  (C) Minimum  (D) Average of maximum-minimum 

Last Answer : (B) Maximum 

Any gradient on a road is said to be an exceptional gradient, if it is (A) More than ruling gradient (B) Less than average gradient (C) More than floating gradient (D) Less than minimum gradient or more than maximum gradient

Description : Any gradient on a road is said to be an exceptional gradient, if it is (A) More than ruling gradient (B) Less than average gradient (C) More than floating gradient (D) Less than minimum gradient or more than maximum gradient

Last Answer : Answer: Option D

What is the average score in an exam taken by 500 students where the minimum score is 200? a. Half the students scored above 700. b. Half the students scored below 700. c. The maximum score in the exam was 850, scored by exactly 42 students.

Description : What is the average score in an exam taken by 500 students where the minimum score is 200? a. Half the students scored above 700. b. Half the students scored below 700. c. The maximum score in the ... . e) If the data in statement a, b and c together are not sufficient to answer the question.

Last Answer : The fact that half scored above 700, and other half less than 700 does not tell the actual distribution of scores to calculate the average. Statement (c) also does not help us determine the average. Answer: e)

Under perfect market conditions a firm is said to be in equilibrium where (a) Total output is equal to total demand ; (b) Profit is the maximum; (c) Where the total revenue is maximum ; (d) Where total average cost is the minimum

Description : Under perfect market conditions a firm is said to be in equilibrium where (a) Total output is equal to total demand ; (b) Profit is the maximum; (c) Where the total revenue is maximum ; (d) Where total average cost is the minimum

Last Answer : (b) Profit is the maximum; 

Under perfect market conditions an Industry is said to be in equilibrium where (a) Total output is equal to total demand ; (b) Profit is maximum (c) Where the total revenue is maximum ; (d) Where total average cost is the minimum

Description : Under perfect market conditions an Industry is said to be in equilibrium where (a) Total output is equal to total demand ; (b) Profit is maximum (c) Where the total revenue is maximum ; (d) Where total average cost is the minimum

Last Answer : (a) Total output is equal to total demand ;

Super normal profits occurs when (a) Average revenue is more than average cost ; (b) Total revenue is maximum; (c) Total cost is minimum ; (d) MC is equal to MR

Description : Super normal profits occurs when (a) Average revenue is more than average cost ; (b) Total revenue is maximum; (c) Total cost is minimum ; (d) MC is equal to MR 

Last Answer : (a) Average revenue is more than average cost ;

A firm is in equilibrium when its (1) marginal cost equals the marginal revenue (2) total cost is minimum (3) total revenue is maximum (4) average revenue and marginal revenue are equal

Description : A firm is in equilibrium when its (1) marginal cost equals the marginal revenue (2) total cost is minimum (3) total revenue is maximum (4) average revenue and marginal revenue are equal 

Last Answer : marginal cost equals the marginal revenue

What does an Excel workbook collect ?

Description : What does an Excel workbook collect ?

Last Answer : An Excel workbook collects worksheets and charts.

Which of the following is a programming language? A) Lotus B) Pascal C) MS-Excel D) Netscape

Description : Which of the following is a programming language? A) Lotus B) Pascal C) MS-Excel D) Netscape

Last Answer : Answer : B

Which of the following is System Software? A. Microsoft Word B. Microsoft Excel C. Adobe Photoshop D. Windows 7

Description : Which of the following is System Software? A. Microsoft Word B. Microsoft Excel C. Adobe Photoshop D. Windows 7

Last Answer : D. Windows 7